β οΈ 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 CSV file with necessary dealer information. Title the columns of your CSV file using the following CSV Field Names. 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 / or Recommended Formatting |
Dealer Name |
| Use the full name of the dealership as found on the official website, legal documents, or Google. π |
Address |
| Any structured format for consistency. π |
City |
| Full city name. π |
State (Optional) |
| Full state name or ISO 3166-2 state code. π |
Country |
| Full country name or ISO 3166-1 alpha-2 country code. π |
Zip Code |
| Zip codes can contain letters in some countries. π |
Coordinates |
| Use Decimal Degrees (Latitude, Longitude) format, separated by a comma. π |
Phone (Optional) |
| Any structured format for consistency. π |
Working Hours (Optional) |
| Any structured format for consistency, e.g., day of the week followed by open time π |
Website (Optional) |
| URL including the protocol (http or https) π |
Once you have filled in the required data, your CSV file should look similar to this:
Save your file πΎ and name it as explained in the next section.
3. Naming a CSV File for Import
To help our system recognize the file correctly use the following format when naming your CSV file for import:
dealer-addresses-xxxxxx.csv
The '-xxxxxx' part can be customized or left out, for example:
dealer-addresses.csv
dealer-addresses-2024-11-01.csv
dealer-addresses-from-partners.csv
Importing a CSV File
To import a CSV file into your X-Cart Store:
Go to Catalog βΊ Import & Export βΊ CSV Import.
Click Import addresses.
In the Upload files section, click Choose files.
Select the file to upload.
Click Start Import.
Updating Dealer Addresses in Bulk
To update dealer information in your X-Cart Store, export the existing dealer addresses as a CSV, apply your changes to the file and import it back.
Steps:
Go to Catalog βΊ Import & Export βΊ CSV Export.
Check
Dealer addresses and uncheck everything else.
(Optional) Adjust the export settings if needed.
Click Start Export to download the file.
Open the CSV file in spreadsheet software and make your changes.
Re-import the updated CSV file.
Can't find answers you're looking for?
Email us at support@x-cart.com. We will be happy to help!
Related articles