Importing Vehicle Changes in Bulk

Manually updating multiple vehicle records can be time-consuming and prone to errors. The bulk import feature allows you to streamline this process by preparing a structured spreadsheet and importing it into the system. This method is particularly useful for:

• Bulk price updates (e.g., adjusting sale prices for multiple vehicles).
• Stock list management, including new vehicle additions and status changes.
• Ensuring data consistency by reducing manual input errors.
• Quickly synchronising stock records with external sales platforms or internal databases.

To successfully import vehicle updates, follow these steps:

Step 1: Format the Spreadsheet

Before importing, ensure your spreadsheet is properly formatted to match the system’s requirements:
✅ The first row must contain column headings.
✅ Required fields are indicated in red.
✅ All data should be structured accurately to avoid import errors.

Possible Fields in Your Spreadsheet

⚠ Important: Ensure your column headers exactly match the import file format. If you're exporting a stock list and re-importing, verify the headers before proceeding.

Step 2: Import the File

1. Open the Vehicle Administration Toolkit.
2. Select the Import/Export menu tab.
3. Click on the Update Vehicles button.
4. When prompted, select the spreadsheet file you prepared.
5. The system will begin processing the file and updating stock records accordingly.

Step 3: Review Errors

After the import is complete:

• Any errors or mismatches will be reported on-screen.
• Check for missing required fields, incorrect formats, or mismatched headers.
• Correct errors in the spreadsheet and reattempt the import if needed.

Why This Process is Important

✅ Saves time by automating bulk updates instead of manual entry.
✅ Reduces errors and ensures data consistency.
✅ Enables seamless pricing updates, vehicle listing modifications, and stock synchronisation.
✅ Helps maintain an accurate and up-to-date inventory for both internal records and public sales listings.