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
To Create a CSV File
Open your spreadsheet software to create new file.
Click on File βΊ Save As (or Export/Download).
Select Comma Separated Values (.csv) as a file type.
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
Open your CSV file in a spreadsheet editor.
Ensure you have the following column headers:
Fill in each row with product details.
CSV Field (Column) | Description, Data Type and Example |
sku | This is a unique identifier of a product.
|
make | Name of the vehicle manufacturer as a text (string).
|
model
| Vehicle's specific model as a text (string).
|
yearFrom | Year the vehicle was manufactured as a text (string).
|
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.
β οΈ 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).
|
notes | For Fitment Notes.
|
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
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:
Go to Catalog βΊ Import & Export βΊ CSV Import.
Click Import.
In the Upload files section, click Choose files.
Select the file to upload.
Click Start Import.
Can't find answers you're looking for?
Email us at support@x-cart.com. We will be happy to help!