To update multiple fleets through an XLSX file, navigate to Fleet
The left-most button will download a fleet template that includes all the fields. You can use this template to make edits to the fleet.
The button next to it allows you to perform the update.
Fields marked with * are required for creating a vehicle
Fields marked with ° are required for updating a vehicle
Note: When updating the fleet, only the columns that need to be changed need to be present.
| Column Name | Description |
| Location Name * | Location that owns the vehicle. We do not recommend updating this field after vehicle has been created. |
| Current Vehicle Location Name | Physical Location of the vehicle. When the vehicle is rented to a different location, this value will change. If no value is provided when creating a new vehicle, it will be set to Location Name |
| License Number * | License Plate Number |
| VIN * | VIN |
| Asset Number * ° | Unique internal asset number |
| Custom Inventory Status | A list of custom inventory status can be found under System Settings → Inventory Statuses |
| Make * | Make |
| Model * | Model |
| Trim Level | Trim level |
| Year * | Year |
| Drivetrain | Drivetrain |
| Exterior Color | Exterior Color |
| Interior Color | Interior Color |
| Grounding Miles * | Automatically sets vehicle to Grounded when odometer has passed this value |
| Grounding Date * | Automatically sets vehicle to Grounded when current date has passed this value (yyyy-mm-ddThh:mm:ssZ) |
| Car Class * | A valid car class in the location |
| Transmission * | Acceptable values: Automatic / Manual |
| Number of Doors * | Number of Doors |
| Odometer | Miles traveled indicated by the Odometer |
| Fuel Level | Acceptable values: UNKNOWN / EMPTY / ONE_EIGHTH / QUARTER / THREE_EIGHTHS / HALF / FIVE_EIGHTHS / THREE_QUARTERS / SEVEN_EIGHTHS / FULL |
| Fuel Capacity | Fuel Capacity |
| Keyless Enabled | Indicates whether fleet supports keyless functionality. Acceptable values: TRUE or FALSE. Default of FALSE if not specified |
| Service Status | Acceptable values: Overdue / Approaching due / Serviced |
| Last Serviced Miles | Last services miles |
| Last Serviced Date | Last services date (yyyy-mm-ddThh:mm:ssZ) |
| Next Service Miles | Next service miles |
| Next Service Date | Next service date (yyyy-mm-ddThh:mm:ssZ) |
| Registration Number | Registration Number |
| Registration Amount | Registration Amount |
| First Registered Date | First Registered Date (yyyy-mm-ddThh:mm:ssZ) |
| Vehicle License Fee | Vehicle License Fee |
| Pre-inspection Completed | If pre-inspections are enabled, field indicates whether a pre-inspection has been performed on the vehicle. Acceptable values: TRUE or FALSE. Default of FALSE if not specified |
| Monthly Amount | Monthly Amount |
| Lender | Lender |
| Amount Financed | Amount Financed |
| Term Financed | Term Financed |
| Start Date | Start Date (yyyy-mm-ddThh:mm:ssZ) |
| Principal Amount | Principal Amount |
| Interest Rate | Interest Rate |
| Purchased Location | Purchased Location |
| Fleet Status |
Whether the fleet is put on fleet or off fleet Acceptable values: ON_FLEET / OFF_FLEET |