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

    • Unleashed | Adding products in bulk via import

      Managing a large inventory can be a daunting task, but with Unleashed, we aim to simplify it for you. Importing products in bulk is not just a time-saver, but it ensures accuracy and consistency in your inventory data. Make sure your product data is ...
    • DEAR Systems | Adding products in bulk via CSV import

      In this video, we will walk you through the step-by-step process of bulk importing products into DEAR systems using a CSV file. This efficient method can save your valuable time when you have a large number of products to add or update in your DEAR ...
    • Bulk importing 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: https://www.youtube.com/watch?v=keHVJ8sp_oQ 
    • 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 ...