This article will help you edit your products using the Import tool. There are over 50 different types of product information that the Import tool can modify. To see all the product information you can edit via the Import tool, click here. Use this article to import one of these values.
This goes into details on how to edit products through the Import tool. A summary of the process is: downloading a data file, creating a spreadsheet, importing the spreadsheet, and checking the changes.
Manual product settings
The following product settings must be managed manually and cannot be imported. Click on each option for more information:
Specifications
Additional fields
Filters - (Filter values can be imported)
Volume discounts
related products
The option not to index products
Article navigation
This article is divided into two parts:
Instructions - Contains step-by-step instructions.
Reference - Contains reference material including specific information for importing
Instructions
To edit supported parts of the product information via import, follow these instructions.
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.
Use the following instructions to get started:
Create a data backup
Preparing your worksheet
Importing your data file
Verification of your changes
1. Creating a data backup
To start editing your product data and importing the changes, you will need to create a data backup using the current product data you have in your eCom store.
In the left menu of the back office, click on Tools.
Click on Exports.
In the top right corner of the page, click New Export.
Next to Choose what to export, make sure Products is selected.
Click on Export.
Look in the Status column if the status is PROCESSING . When the status changes to READY , processing is complete. Click Download on the right side of the screen.
Keep this product somewhere on your computer where it is easy to find. In this example, we'll name the file Product Data File Backup and save it to the desktop.
2. Prepare your worksheet
To edit products via import, these steps instruct you to create an empty table that will become your worksheet.
3. Enter your data file
Now that you have completed your product edits and saved your spreadsheet to your computer, you can now upload the file to eCom via the Import tool.
In the eCom store's back office, click Tools.
Click on New Import.
Click Browse computer.
Find your worksheet and click Open.
Click on Choose what to import and click on Products.
The page will continue automatically. In the section ADDITIONAL SETTINGS:
Click Make a choice: and select Update existing products only.
Click Choose a column and select Product/Variant ID.
The fields in the SELECT FIELDS section are automatically mapped to the correct fields as long as the column headings have not been changed in your worksheet. Find out which columns to map to the correct fields using the column name table in this article to find the correct matches.
Click Continue in the top right corner of the screen.
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.
4. Verify your changes
It is necessary to check if your edits were successful after starting an import. After checking that there are no errors in the Import tool, it is important to randomly test some products from your worksheet and confirm whether your edits have taken place.
Confirm that no errors occurred during the import:
Log in to your eCom store's back office and click Tools.
Find your import by date or file name and click on View report next to the status.
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 that the edits have been made
In Google Sheets, open the sheet you uploaded on Lightspeed eCom.
Select any row and copy the internal ID of the product.
Log in to your eCom store's back office and select Products.
Select a product.
In the web address bar, replace the number na /admin/products/ with the copied internal ID and press Enter on your keyboard.
Compare the product with your worksheet to make sure the changes you made are reflected correctly.
Repeat steps 1-6 for a few products until you are sure all your changes have been imported correctly.
REMARKS
The recommended software to manage your data is Google Sheets. The recommended file format is the .CSV format. For more information about this software and its format, click here.
Some system column names have a space reserved for a language abbreviation, which is shown here as XX. When preparing your worksheet, use the Language table to add the correct abbreviation for your translated columns. For example, the title column appears with the name of the system column next to it, followed by a summary description of the requirements for this column:
Title - XX_Title_Short- Description.
Requirement 1
Required 2
Reference
Identify columns
Every worksheet needs columns that help determine what kind of content is in each cell.
The Import tool uses the Internal_ID and the Internal_Variant_ID to identify the content. To help you determine which product is in each row, the column XX_Title_Short is has been added. You can also add another identifier column to help you identify the product, such as the product category or item code.
NOTE: While the internal_ID and Internal_Variant_ID columns cannot be edited with the Import tool, any other changes to the identifier columns will update the products in eCom. To avoid accidental updates in Lightspeed eCom, make sure you don't accidentally make changes to any of your identification columns.