Adding products in Bulk via CSV import

Adding products in Bulk via CSV import

Adding product manually is ok if you have only a few items. In case, there are 100s of products, using CSV to import them will make task easy. The Retail POS product template is attached with this article. It is a pre-formatted templatethat includes all the relevant product information that can be captured in Retail POS. 
To fill this template, we will need:
  1. Name of the products
  2. Any variantions like size, colors, and models
  3. Retail prices of the product including tax if the store displays price inclusive of tax else exclusing tags
  4. Supply prices of the products
  5. Existing Barcode/SKU numbers
  6. The exact names of the taxes you have set up in Retail POS
Check this video to understand the product fields:

Update the file and import it by navigating to Catalog >> Products in the sidebar and click Import button. Here you can upload the file and after this Lightspeed will perform a check to make sure columns match. If there is any unmatched columns, you can fix them by selecting the correct column from the drop-down menu.
Once this is fixed, click Continue with import. Once the import is complete, you will get notifications from the bell icon at top right. If any of the products are ignored for some reasons, it will provide you with the ignored products CSV. Download the file and update the field as per the reason mentioned in it.

    • Related Articles

    • Bulk imporitng items via CSV

      Adding a single item is simple. But adding 100s of items manually will be time cosuming. To quickly add many items, Lightspeed retail provides with a template file. This video will show how to fill this template file and what all columns are ...
    • VIDEO | Importing Composite Products via CSV | Vend U

      A video on 'Importing Composite Products via CSV'. Link: 
    • Creating Purchase orders

      While adding the products, we didn't add the inventory to them. The right way of getting the store in is via Purchase/Stock order. To create an order, navigate to Inventory > Stock Control and click Order Stock. You can add the products manually and ...
    • Adding new and editing existing products in the CSV file

      Formatting item import files To import inventory items via our Retail Imports team, please refer to this article. How you format your import file is dependent on if you're: Creating new items Updating existing items  If you're also importing images, ...
    • Importing your Products into Vend using a CSV file

      What's New? CSVs are often used to bulk import and edit products in Vend. We've made some improvements to make this process even faster and easier to use. SKUs and Handles will now automatically populate if you do not include these as columns in your ...