Skip to main content
CSV Import: Dealer Addresses

Learn which attributes the Dealer Locator add-on uses and how to import them correctly.

Alex avatar
Written by Alex
Updated over a month ago

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.

  1. Open your preferred spreadsheet software.

  2. Enter your data into the cells.

  3. Click on File β€Ί Save As or Export or Download (depending on the software).

  4. Select Comma Separated Values (.csv) from the file type dropdown menu.

  5. Name your file using the recommended format.

  6. 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

'dealerName'

Text (String): Use the full name of the dealership as found on the official website, legal documents, or Google.


πŸ“‹ Motor Market

Address

'address'

Text (String): Any structured format for consistency.


πŸ“‹ 2178 N Rainbow Blvd

City

'city'

Text (String): Full city name.


πŸ“‹ Las Vegas

State

(Optional)

'state'

Text (String): Full state name or ISO 3166-2 state code.


πŸ“‹ Nevada or ND

Country

'country'

Text (String): Full state name or ISO 3166-1 alpha-2 country code.


πŸ“‹ United States or US

Zip Code

'zipCode'

Text (String), as zip codes can contain letters in some countries.


πŸ“‹ 89108 or A1B 2C3

Coordinates

'coordinates'

Text (String): Use Decimal Degrees (Latitude, Longitude) format, separated by a comma.


πŸ“‹ 36.198543, -115.240471

Phone

(Optional)

'phone'

Text (String): Any structured format for consistency.


πŸ“‹ (702) 631-7497 or +1 (702) 631-74-97

Working Hours

(Optional)

'workingHours'

Text (String): 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'

Text (String): URL including the protocol (http or https)


πŸ“‹ https://example.com

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


Note: Fields were rearranged for illustration.

πŸ“‹ 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

Note: The '-xxxxxx' part can be customized or left out.

Such format helps our system recognize the file correctly.

πŸ“‹ Example file names

  • dealer-addresses.csv

  • dealer-addresses-2024-11-01.csv

  • dealer-addresses-from-partners.csv


Importing a CSV File

Follow these steps to import a CSV file into your X-Cart Admin:

  1. Navigate to Catalog β€Ί Import & Export.

  2. In the CSV Import tab, click 'Import addresses'.

  3. In the Upload files section, click 'Choose files'.

  4. Select the file to upload.

  5. 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?

  1. Navigate to Catalog β€Ί Import & Export, and select the CSV Export tab.

  2. Check 'Dealer addresses' and uncheck everything else.

  3. Optional: Adjust export settings.

  4. 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!


Did this answer your question?