⚠️ Requirements:
|
Before you begin
Download the Dealer Locator add-on for your X-Cart Automotive store.
Preparations
1. Creating a CSV File
You can use any spreadsheet software like MS Excel, Google Sheets, or Apple Numbers.
Open your preferred spreadsheet software.
Enter your data into the cells.
Click on File › Save As or Export or Download (depending on the software).
Select Comma Separated Values (.csv) from the file type dropdown menu.
Name your file using the recommended format.
Click Save.
2. Entering Your Data into CSV File Fields
Create or update your import file with the necessary dealer information. Use the following Field Names (without quotes) to title the columns of your CSV file. Fill in the attributes for each dealer line by line, following the provided recommendations below 👇.
X-Cart Admin Attribute | CSV Field Name | Value Type and Recommended Formatting |
Dealer Name |
| Text (String): Use the full name of the dealership as found on the official website, legal documents, or Google. 📋 |
Address |
| Text (String): Any structured format for consistency. 📋 |
City |
| Text (String): Full city name. 📋 |
State (Optional) |
| Text (String): Full state name or ISO 3166-2 state code. 📋 |
Country |
| Text (String): Full state name or ISO 3166-1 alpha-2 country code. 📋 |
Zip Code |
| Text (String), as zip codes can contain letters in some countries. 📋 |
Coordinates |
| Text (String): Use Decimal Degrees (Latitude, Longitude) format, separated by a comma. 📋 |
Phone (Optional) |
| Text (String): Any structured format for consistency. 📋 |
Working Hours (Optional) |
| Text (String): Any structured format for consistency, e.g., day of the week followed by open time 📋 |
Website (Optional) |
| Text (String): URL including the protocol (http or https) 📋 |
Note: Only a few attributes are optional (State, Phone, Working Hours, and Website); the rest are required. If you do not include them, the import process will fail. Also, make sure that all required fields are completed correctly to avoid import errors.
💡 Check Your Coordinates
Entering Decimal Degrees incorrectly will place the dealer in the wrong location on the map.
Once you have filled in the required data, your CSV file should look something like this:
 📋 CSV file Example
|
📋 CSV file Example
Note: Fields were rearranged for illustration.
.
Save your file 💾 and name it as explained in the next section.
3. Naming a CSV File for Import
When naming your CSV file for import, use the following format:
dealer-addresses-xxxxxx.csv
|
Such format helps our system recognize the file correctly.
📋 Example file names |
|
Importing a CSV File
Follow these steps to import a CSV file into your X-Cart Admin:
Navigate to Catalog › Import & Export.
In the CSV Import tab, click
'Import addresses'.In the Upload files section, click
'Choose files'.Select the file to upload.
Click
'Start Import'.
Updating Existing Dealer Addresses
If you already have dealer information in your X-Cart Store, whether it was imported via CSV or entered directly in the Admin Area, you can update it in bulk. Export the existing dealer addresses as a CSV, make your changes to the file, and then import it back the same way we explained before.
How to Export Existing Dealer Database as a CSV?
Navigate to Catalog › Import & Export, and select the CSV Export tab.
Check
'Dealer addresses'and uncheck everything else.Optional: Adjust export settings.
Click
'Start Export'.
Related articles
Learn more about Dealer Locator add-on.
Can't find answers you're looking for?
Email us at support@x-cart.com. We will be happy to help!