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 2 weeks ago

⚠️ Requirements:

  • X-Cart Auto 5.5.1 or later.

  • Dealer Locator Add-on installed and enabled (Learn more).

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 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:

  1. Go to Catalog β€Ί Import & Export β€Ί CSV Import.

  2. Click Import addresses.

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

  4. Select the file to upload.

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

  1. Go to Catalog β€Ί Import & Export β€Ί CSV Export.

  2. Check Dealer addresses and uncheck everything else.

  3. (Optional) Adjust the export settings if needed.

  4. Click Start Export to download the file.

  5. Open the CSV file in spreadsheet software and make your changes.

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


Did this answer your question?