In this article, we'll show you how to add or update the Fitment Type for multiple products using a CSV file import.
How Fitment Type is Imported?
You can add or update the fitment type by including the fitmentType column in the products.csv file for import. Each product in this CSV file can have one of the following fitment type values, as we've covered before:
Regular
(for Regular Product)Universal
(for Universal Fit Product)Specific
(for Vehicle-Specific Product)
If you leave this field blank, the outcome will vary depending on what you do:
Import New Product | The fitment type will automatically be set to Regular. |
Update Existing Product | The fitment type will remain unchanged, as it was set before the import. |
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 | Enter the unique product identifier, that corresponds with the product.
|
name
| Enter the product name (required only for new products).
|
fitmentType | Specifies vehicle compatibility.
|
Hereโs an example of how your CSV file should look like:
3. Naming a CSV File for Import
Save your file and rename it using the following format to help X-Caer recognized the file correctly upon import:
๐ products-xxxxxx.csv
The '-xxxxxx' part can be customized or left out, for example:
products.csv
products-01-02-03.csv
products-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!