Importing vehicles from CSV

If you have many vehicles to add at once, or you're migrating from an existing system, CSV import is faster than adding them one by one.

Before you start

• You need Vehicles edit permission.
• Have your vehicle data in a spreadsheet, or export it from your existing system.
• Download the template first so your columns match what the importer expects.

To import

1. From Vehicles, click Import CSV
2. Click Download template to get a CSV with the right headers
3. Fill the template with your vehicle rows and save as CSV
4. Drag the file onto the upload area, or click to browse
5. Review the parsed preview and click Import

What the importer accepts

• CSV format, one vehicle per row
• Headers are case-insensitive and tolerate spaces, so Stock No and stock_no both work
• Numbers can include commas, so 10,000 is read as 10000
• Source type must be one of: auction, agent, dealer, private, trade
• Supplier is matched to your existing non-archived suppliers by name, case-insensitive

Common failure modes

• Supplier not found: the importer won't invent suppliers for you. Add the supplier under Suppliers first, or correct the spelling in your CSV.
• Unknown source type: must be one of the five listed above. Check for typos.
• Duplicate stock number: if a row's stock number matches an existing vehicle, the row is skipped (not overwritten).
• Missing required fields: rows without a stock number, make, or model are skipped. The preview tells you which rows were skipped and why.

After import

Imported vehicles appear in the Vehicles list with the Purchased stage. Open each one to fill in anything the template didn't cover: shipment, costs, documents, photos.