Skip to main content
Importing Product Fitments
Alex avatar
Written by Alex
Updated this week

In this article, we'll show you how to assign specific vehicles to your products using CSV import.


How Product Fitments are Imported?

Product fitments are linked to a product using the SKU. This helps associate the product with the correct vehicle fitment.

Fitments are imported using the MMY (Make/Model/Year) structure, which by default 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.


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 to create new file.

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

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

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

  1. Open your CSV file in a spreadsheet editor.

  2. Ensure you have the following column headers:

  3. Fill in each row with product details.

CSV Field (Column)

Description, Data Type and Example

sku

This is a unique identifier of a product.

πŸ“‹ 100000000001

make

Name of the vehicle manufacturer as a text (string).

πŸ“‹ Ford

model

Vehicle's specific model as a text (string).

πŸ“‹ F-150

year

Year the vehicle was manufactured as a text (string).

πŸ“‹ 2025

submodel

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

πŸ“‹ Raptor

notes

πŸ“‹ Does not fit models with adaptive cruise control

If an SKU is assigned to a vehicle not yet available in your store, the import will automatically add it under Catalog β†’ Manage Vehicles in X-Cart Admin, along with the product fitment data.

For products that fit multiple vehicles, list each SKU + Make/Model/Year/Submodel combination on a separate row, treating each as a unique entry.


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:

πŸ“‹ fitmentvalues-xxxxxx.csv

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

  • fitmentvalues.csv

  • fitmentvalues-01-02-03.csv

  • fitmentvalues-from-my-provider.csv

For X-Cart 5.4 and older, use products-mmy.csv

  • products-mmy.csv

  • products-mmy-01-02-03.csv

  • products-mmy-from-my-provider.csv


Step 4: Importing a CSV File

Finally, import the CSV file into your X-Cart Store:

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

  2. Click Import.

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

  4. Select the file to upload.

  5. Click Start Import.


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?