Before you begin

Download the Dealer Locator add-on for your X-Cart Automotive store.

Get add-on for free

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	`dealerName`	Use the full name of the dealership as found on the official website, legal documents, or Google. 📋 `Motor Market`
Address	`address`	Any structured format for consistency. 📋 `2178 N Rainbow Blvd`
City	`city`	Full city name. 📋 `Las Vegas`
State (Optional)	`state`	Full state name or ISO 3166-2 state code. 📋 `Nevada` or `ND`
Country	`country`	Full country name or ISO 3166-1 alpha-2 country code. 📋 `United States` or `US`
Zip Code	`zipCode`	Zip codes can contain letters in some countries. 📋 `89108` or `A1B 2C3`
Coordinates	`coordinates`	Use Decimal Degrees (Latitude, Longitude) format, separated by a comma. 📋 `36.198543, -115.240471`
Phone (Optional)	`phone`	Any structured format for consistency. 📋 `(702) 631-7497` or `+1 (702) 631-74-97`
Working Hours (Optional)	`workingHours`	Any structured format for consistency, e.g., day of the week followed by open time 📋 `Mon-Fri: 7:00 AM - 6:00 PM`
Website (Optional)	`website`	URL including the protocol (http or https) 📋 `https://example.com`

Once you have filled in the required data, your CSV file should look similar to this:

CSV file Example

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

What is Dealer Locator add-on?

CSV Import: Dealer Addresses