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
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).
|
year | Year the vehicle was manufactured as a text (string).
|
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!