All Collections
Lightspeed
Import from suppliers
Import from suppliers
Niels van Vlerken avatar
Written by Niels van Vlerken
Updated over a week ago

Having all your suppliers in Lightspeed eCom is a small help when manually editing your products, as you can select their names from a list instead of typing them manually.

Unlike most data that you can import into Lightspeed eCom, you can only use the Import tool to import new suppliers. Vendor edits must be done manually in your eCom Back Office > Products > Suppliers. For more information about editing suppliers click here.

A superior way to import suppliers is when importing new products or editing products via import, because with one import you can import new suppliers and assign them to your products. Just add a "Supplier" column to your product's worksheet and enter the names of the suppliers in that column. For more information on importing:

  • New products, click here.

  • Click here.

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:

  1. Preparing your worksheet

  2. Import your worksheet

  3. Verification of your worksheet

1. Preparing the worksheet

To create new suppliers, these steps guide you to create a new table that will become your worksheet.

  1. Click here to sign in to your Google account and open Google Sheets.

  2. Create a blank page by clicking +. This will be used as your worksheet.

  3. In column A, row 1: copy the following required column titles and paste them into your worksheet:
    Supplier

  4. Access your supplier data, if applicable. Enter your supplier names from column A, row 2.

  5. When you have added all your suppliers, save your worksheet on your computer in CSV format. This can be done by clicking File > Download as > Comma separated values ​​(.CSV).

2. Importing 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.

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

  2. Click on New Import.

  3. Click Browse computer.

  4. Find your worksheet and click Open.

  5. Click What do you want to import? and select Suppliers.

  6. The page will continue automatically. Click on Select a field and select Vendor title. For more information about the other field types click here.

  7. Click Continue in the top right corner of the screen.

  8. 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.

3. 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 some suppliers 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 that the edits have been made

  1. In Google Sheets, open the sheet you uploaded on Lightspeed eCom.

  2. Select any row and copy the supplier's name.

  3. Log in to your eCom store's back office and click on Products.

  4. Click on Suppliers.

  5. Paste your supplier's name into the search bar.

  6. Find your customer's name by pressing Enter on your keyboard. If your supplier's name appears, it has been successfully imported.

  7. Repeat steps 1-6 for a few suppliers until you are sure that all your changes have been imported correctly.

Did this answer your question?