Skip to main content

Importing Fitment Type via CSV

Learn how to add fitment type to multiple products in bulk using import/export feature.

Alex avatar
Written by Alex
Updated over 3 weeks ago

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

  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

Enter the unique product identifier, that corresponds with the product.

📋 10000000002

name

Enter the product name (required only for new products).

📋 ALF 1000 Air Spring Kits

fitmentType

Specifies vehicle compatibility.

📋 Regular , 📋 Universal , 📋 Specific

Here’s an example of how your CSV file should look like:

Importing fitment type for each product

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:

  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?