Skip to main content

Commercial Fleet CSV Guide

Updated over a week ago

You can create, edit or delete bikes on your commercial policy using our CSV Upload flow.

You must use the .CSV template available here:


Field Requirements:

Field

Required?

Accepted Values. If blank any string is accepted

Example

Request

Yes

CREATE; DELETE; PATCH

CREATE

ProductType

Yes

Bicycle; BicycleAccessory; BicycleClothing
Note: We recommend adding accessories into the model name and increasing the individual bike value, otherwise we only store 1 line item for accessories per policy.

Case sensitive.

Bicycle

AccessoryTypes

Yes, if ProductType = BicycleAccessory

See below

GPS;Lock;Gloves

SKU

No


91283751816826

FrameNumberUID

Yes, must be unique

1234ABC

123ABC

ExternalID

No, must be unique


MYFLEETID1

BikeType

Yes

GravelBike
Mountain
Folding
FixedGear
CityBike
Cargo
Cyclocross
Hybrid
TT
Road
Touring
Recumbent

GravelBike

EBike

Yes

null (blank);
assisted;
speedpedelec
Note: Assisted means eBikes upto 25km/h, anything over is speedpedelec

assisted

Brand

Yes


Cannondale

Model

Yes


Topstone

StreetAddress

Yes, this is the address where you store the bicycle.

Some policies are exempt. Do not include any '''


20 St Thomas St

Postcode

Yes, some policies are exempt

Postcodes

SE1 9RS

City

Yes, some policies are exempt


London

ISOCountry

Yes, some policies are exempt

GB; NL; FR etc. (Must be in ISO2 format). All EEA countries supported.

GB

CurrencyCode

Yes

GBP; EUR

GBP

Value

Yes

2000.24, 2 decimal places accepted.

2400.69

Common Errors;

'Validation failed' - This is often in relation to the postcode validation - please double check all addresses. Are postcodes complete / in the correct format for the country? For example, have you accidently listed BE (Belgium) against NL postcodes?

Accepted Accessory Types

Note: There can only be one accessory line item per policy, which can have multiple types. Alternatively, sum the accessories value into the value of the bike, and name the model something like, "Topstone + Bike Lock"

Gloves
BikeAlarm
ActionCamera
BikeComputer
BikeRack
FitnessWatch
GogglesGlasses
GPS
Lock
WaterBottle
Bags
Basket
Bell
BikeBox
BikeCovers
BodyArmour
Charger
ChildSeat
CycleMirrors
Drawbar
Facemask
FrameProtectors
HeartRateMonitor
Helmet
HydrationPack
Light
Mount
Mudguards
NeckBrace
Pannier
PannierRack
Pump
RepairKit
Shoes
Stand
Stickers
Tools
Trailer
WaterBottleCage
Wetsuit
Workstand
BatteryLock

Did this answer your question?