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
To Create a CSV File
Open your spreadsheet software.
Click on File βΊ Save As (or Export/Download).
Select Comma Separated Values (.csv) as a file type.
Name your file using the recommended format.
Click Save.
To Use Existing CSV File from X-Cart
To Use Existing CSV File from X-Cart
Go to Catalog βΊ Import & Export βΊ CSV Export.
Under What to export select
Vehicles.
Adjust Export settings if needed.
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).
|
model
| Enter the vehicle's specific model as a text (string).
|
year | Enter the year the vehicle was manufactured as a text (string).
|
submodel | Enter the trim level of the vehicle model as a text (string).
|
levelname_logo (Optional)
| Enter the Image location (URL or server path) as a text (string). Read More.
|
levelname_banners (Optional) | Enter multiple image paths/URLs as a text (string), separated by &&. Read More.
|
levelname_cleanURL (Optional) | Enter an SEO-friendly URL for the example-level page as a text (string). Read more.
|
levelname_show_on_frontpage (Optional) | Display in promo block? (Boolean)
|
levelname_enabled (Optional) | Is this level active? (Boolean)
|
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:
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:
Find the logo online (or on your X-Cart Storefront) and copy its URL.
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 |
|
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:
Upload the logo to any folder on your X-Cart server.
Copy the file path to the logo.
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 |
|
Model_Logo |
|
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:
Find the banner online or Upload it on your X-Cart server.
Copy the Direct URL or File Path to the Banner.
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
|
|
Make_Banner
|
|
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
|
|
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
|
|
Clean URLs are imported according to the following rules:
If the CSV file has no cleanURL column, the vehicle's Clean URL stays the same.
If the cleanURL column exists but is empty for a vehicle, its Clean URL will be removed.
If the cleanURL column has a value, it will replace the existing Clean URL.
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:
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.
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!