All Collections
Importing product filter values
Importing product filter values
Niels van Vlerken avatar
Written by Niels van Vlerken
Updated over a week ago

The Import tool provides a faster method of assigning filter values to products, compared to assigning them manually.

For more information about product filters and how to set them up manually, click here.


A successful import depends on the quality of your data. That's why most of the steps you need to follow when importing to eCom revolve around your worksheet. For more information about the importance of a worksheet, click here.

Follow these steps to import the product's filter values:

  1. Preparing your worksheet

  2. Import your worksheet

  3. Verification of your import

Prepare your worksheet

Follow these steps to create your worksheet that associates the filter values with products by associating the product IDs with the titles of the filter values.

Import your data file

Now that you have prepared your data file and saved it to your computer, you can now upload the file to eCom via the Import tool.

Log in to your eCom store's back office and click Tools.
Click on New Import.
Click Browse computer.
Find your worksheet and click Open.
Click CWhat do you want to import? and select Product Filter values.
The page will continue automatically.
The internal ID value in the SELECT FIELDS section will automatically map to the correct field as long as the column headings have not been changed in your worksheet. You need to select the filter that contains the filter values ​​you added to the worksheet. For more information click here to find the right matches.
Click Start the import. The Import tool will start processing the import. You don't have to stay on the page and can come back to it later.

Verify your changes

It is necessary to check if your edits were successful after starting an import. After checking the Import tool for errors, it is important to randomly test a number of clients from your worksheet and confirm whether your edits have taken place.

Confirm that no errors occurred during the import:

  1. Log in to your eCom store's back office and click Tools.

  2. Find your import by date or file name and click on View report next to the status.

  3. If errors are visible, correct your worksheet and re-import your edits. To see frequently asked questions and ask your own questions about errors, visit the Lightspeed Community article here.

Confirm if the edits have taken place

  1. In Google Sheets, open the sheet you uploaded on Lightspeed eCom. Copy the Internal_ID of each product.

  2. Open the eCom Back Office and click Products.

  3. In the web address bar, add a slash after/products and paste the internal ID.

  4. Press Enter on your keyboard.

  5. Scroll to filters and compare the filter values ​​assigned to the product.

Did this answer your question?