Skip to main content

Importing Product Fitments

Alex avatar
Written by Alex
Updated over 2 weeks ago

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 levels (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

yearFrom

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

πŸ“‹ 2019

yearTo

Final year of the vehicle’s production range (string). If the product fits a vehicle from a specific year only, enter that year to yearFrom only.

πŸ“‹ 2025


⚠️ Note on setting year range for fitments

If you enter a year range using yearFrom and yearTo fields, fitments will be created only for the vehicles available in your store.

For example, if you enter 2010–2025, but your store has vehicles only for 2010, 2011, 2015, 2020, and 2022, the product will get 5 fitments, not 16.

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?