Skip to main content
Importing Vehicles via CSV
Alex avatar
Written by Alex
Updated this week

In this article, we'll guide you through the process of adding or updating vehicle information in your store via CSV, along with importing related data such as logos and banners.


How Vehicles are Imported?

Vehicles are imported using the MMY (Make/Model/Year) structure. By default, this includes four levels: Make, Model, Year, and Submodel.

You can customize the structure to include additional details like trim or engine type, or adjust the number of fields (from 2 to 4) in the Make/Model/Year add-on settings.

However, changing the structure may cause incorrect product imports with Data Catalog providers and Warehouse Distributors, as they use all four exact levels.

Additionally, you can import logos, banners, clean URLs, control whether the car brand appears on the front page, or make specific MMY levels active or inactive (e.g., hiding a particular car from your store).


Step 1: Preparations

Start by creating or using existing CSV file via any spreadsheet software like MS Excel, Google Sheets, or Apple Numbers.

To Create a CSV File

  1. Open your spreadsheet software.

  2. Click on File β€Ί Save As (or Export/Download).

  3. Select Comma Separated Values (.csv) as a file type.

  4. Name your file using the recommended format.

  5. Click Save.


To Use Existing CSV File from X-Cart

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

  2. Under What to export select Vehicles.

  3. Adjust Export settings if needed.

  4. Click Start Export to download the file.


Step 2: Entering Data

Now, open your CSV file in spreadsheet software and use the following CSV Field Names for the column titles. Then, fill in each vehicle data row by row, following the examples below.

CSV Field (Column)

Description, Data Type and Example

make

Enter the name of the vehicle manufacturer as a text (string).

πŸ“‹ Ford

model

Enter the vehicle's specific model as a text (string).

πŸ“‹ F-150

year

Enter the year the vehicle was manufactured as a text (string).

πŸ“‹ 2025

submodel

Enter the trim level of the vehicle model as a text (string).

πŸ“‹ Raptor

levelname_logo

(Optional)

Enter the Image location (URL or server path) as a text (string). Read More.

πŸ“‹ images/level1logo/auto/Ford.png

levelname_banners

(Optional)

Enter multiple image paths/URLs as a text (string), separated by &&. Read More.

πŸ“‹ images/level1/banner1.png&&https://example.com/banner2.png

levelname_cleanURL

(Optional)

Enter an SEO-friendly URL for the example-level page as a text (string). Read more.

πŸ“‹ https://example.com/ford

levelname_show_on_frontpage

(Optional)

Display in promo block? (Boolean)

πŸ“‹ Yes/No

levelname_enabled

(Optional)

Is this level active? (Boolean)

πŸ“‹ Yes/No

Replace levelname with the required filter level name (e.g., Make, Model, Year)

Here’s an example of how your CSV file might look like:

Vehicle Information in CSV


Importing Logos for Filter Levels

You can add logo to display it on each filter level page (e.g., brand or model page) using a direct URL, or local file path.

If Using a Direct URL:

  1. Find the logo online (or on your X-Cart Storefront) and copy its URL.

  2. Paste the URL into the levelname_logo CSV field.

Replace levelname with the appropriate filter level name (e.g., Make, Model, Year):

CSV Field

Example of what to paste

Make_Logo

https://example.com/images/ford.png

If Using Local File Path:

Importing images from a local server is much faster than pulling them from external sources. Even if you use a URL, X-Cart checks whether it's stored locally.

If you’re importing many images, save them directly in /images/level[X]logo/auto/ to speed things up:

  1. Upload the logo to any folder on your X-Cart server.

  2. Copy the file path to the logo.

  3. Paste the file path to the levelname_logo field.

Replace levelname with the appropriate filter level name (e.g., Make, Model, Year):

If you store logos in the Images folder of your X-Cart server, make sure they are placed in this /images/level[X]logo subdirectory, where [X] is the filter level number.

CSV Field

Example of what to paste

Make_Logo

/images/level1logo/ford/logo.png

Model_Logo

/images/level2logo/Ford-Logo-11-scaled.jpg

Logos stored outside the level[X]logo subfolder, specifically within the Images folder, will not import.


Importing Banners for Filter Levels

You can import banners to display them on each filter level page (e.g., brand or model page). Import rules are the same as with importing logos.

To import:

  1. Find the banner online or Upload it on your X-Cart server.

  2. Copy the Direct URL or File Path to the Banner.

  3. Place it in the levelname_banner field in your CSV file.

Replace levelname with the appropriate filter level name (e.g., Make, Model, Year):

CSV Field

Example of what to paste

Make_Banner

Direct URL

https://example.com/images/ford.png

Make_Banner

Path in Images

images/level[X]/auto/image1.png , where [X] is the filter level number

Additionally, you can specify more than one image for import by separating the image paths with the && symbols:

CSV Field

Example of what to paste

Make_Banner

Multiple Images

/images/level2logo/Ford-Logo-11-scaled.jpg&&https://example.com/images/ford.png


Adding Clean URLs to the level page

To import SEO-friendly URL, enter the desired url in the levelname_CleanURL field in your CSV file.

CSV Field

Example of what to paste

Make_Banner

Multiple Images

ford


Clean URLs are imported according to the following rules:

  1. If the CSV file has no cleanURL column, the vehicle's Clean URL stays the same.

  2. If the cleanURL column exists but is empty for a vehicle, its Clean URL will be removed.

  3. If the cleanURL column has a value, it will replace the existing Clean URL.

  4. If the imported Clean URL conflicts with an existing one, -1 will be added to the end of the URL.


3. Naming a CSV File for Import

Save your file and rename it using the following format to help X-Cart recognized the file correctly upon import:

πŸ“‹ mmy-xxxxxx.csv

The '-xxxxxx' part can be customized or left out, for example:

  • mmy.csv

  • mmy-01-02-03.csv

  • mmy-from-my-provider.csv


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

Once the import process is completed, X-Cart will automatically add the filter levels and their values to the Catalog β€Ί Manage Vehicles section in your store's Admin area.


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?