Bulk Import Products with CSV
Before you begin
- You’ll need Google Sheets to read CSV files.
- Make sure you are using a desktop or laptop to access this feature as it is not accessible on the iOS or Android App, and let's be honest - it's much easier using a spreadsheet app with a keyboard and mouse
- Make sure your Tax Settings are correct.
- Head over to Company settings
- Under the Details tab, look for Tax Settings
- Choose between Use Tax Inclusive Prices or Use Tax Exclusive Prices
Note - Make sure to choose the correct option, because this will affect the CSV that you will download.
Add new products: download the Import Template
2. Select Get the Import Template
Now that you have the CSV downloaded, it is time to fill in the details.
When adding new products: The CSV will be blank. Mind that some columns must NOT be filled.
When editing your products: The CSV will have all your existing products. Edit the columns that correspond to the changes you want. Note that there are columns that you should NOT edit
In this section, you will see the significance of each field. If required fields are left blank, you will receive an error message once you upload the CSV.
|
CSV Field |
Description |
Is this required? |
How to use |
|
Product ID |
A unique number assigned by Lightspeed to each Product in a Company |
Yes |
Do not edit If uploading new products leave blank |
|
Product No |
Often used for custom integrations, not used by Lightspeed |
No |
Numbers and letters can be used |
|
Product Name |
This is the name of your Product or Modifier that will show on: POS, production dockets, tax receipts and purchase orders |
Yes |
Use a unique name for each Product or Modifier |
|
Barcode |
Used in conjunction with a barcode scanner for search functionality |
No |
A unique number is recommended but not required |
|
SKU |
Use the SKU field to map this product with other apps such as eCommerce |
No |
Numbers and letters can be used. Does not need to be unique |
|
Unit |
Define the measure of this product by unit, weight or volume |
Yes |
“unit” is used for a single item by default Defined measures can also be used ”g” or “kg” for weight |
|
Default Size |
Used with the unit selected This is the size of the purchased or created product
|
Yes |
Only numbers can be used and will apply to the Unit eg. 700ml |
|
Sell Price Inc Tax or Sell Price Ex Tax |
A company-wide selling price to be used as a starting price for a product We recommend using one format consistently across a Company
|
Yes |
Use numbers and do not include a currency symbol |
|
Sell Tax Code |
The CODE of the tax that is applicable when being sold |
Yes |
You will need to add your tax types before performing the import |
|
Cost Price Inc Tax or Cost Price Ex Tax |
A company-wide cost price used for Purchasing and COGS reporting |
Yes |
Use numbers and do not include a currency symbol |
|
Cost Tax Code |
The specific tax type you are purchasing this product with |
Yes |
You will need to add your tax types before performing the import |
|
Is Modifier |
This indicates if an item is a |
Yes |
1 = Modifier 0 = Product |
|
Print Docket |
This indicates if an item should be printed on a production docket |
Yes |
1 = Print on docket
|
|
Tags |
Used for filtering products when searching in Back Office and POS. You can assign multiple tags to a product. |
No |
Letters and numbers can be used Separate them with a “,” when multiple are being used |
|
Category Names |
Categories group products together on the POS screen |
No |
Letters and numbers can be used Separate them with a “,” when multiple are being used |
|
Sell Account |
This defines if a product or modifier can be sold via POS |
Yes |
1= Sold from POS
|
|
Buy Account |
This defines if a product or modifier can be ordered via Purchase |
Yes |
1= Ordered from Purchase 0 = Not ordered from Purchase |
|
Inventory Account |
This defines if a product or modifier can be counted as stock |
Yes |
1= Counted stock item
|
|
Image URL |
This is used for adding images to the product tile on the POS screen |
No |
Put the URL of an image here to link an image from a website
Avoid using images on websites that require a login or password to access |
|
Reporting Group |
This defines how this items is recorded for Insights reports You will start with 2 default Reporting groups, Drink and Food These can be changed and will impact the reports run after the change. |
No |
Only one Reporting Group can be given too a Product or Modifier
|
|
Friendly Name |
This is the name shown for integrations that use Online Products |
No |
Numbers and letters can be used |
|
Show Online |
This toggles product off and on integrations that sync with Online Products |
No |
0 = Off |
|
Online Description |
The description shown shown for integrations that use Online Products |
No |
Numbers and letters can be used |
|
Inventory Type |
This defines whether a Product is Purchased or Made |
Yes |
1 = Purchased 2 = Made |
|
Purchase Format |
Defines the format for how products are purchased |
No |
Individual (Default) Boxes Crates Packs Cartons |
|
Purchase Qty |
Defines how many are purchased in the purchase format |
No |
Only numbers can be used |
|
Variable Qty Prompt |
Toggles off and on the variable quantity prompt setting |
Yes |
0 = Off 1 = On |
Upload the CSV to Kounta
Awesome! Now you are ready to upload your template to your Kounta.
1. Before uploading, check if all the fields are filled out properly
2. After that, make sure it is saved in the correct file type. The file extension should say “.csv” - If not, select Download As and choose Comma-separated values (.csv) as the file type.
3. Ready to upload! Under Products from the Kounta Back Office, select the cloud icon with the arrow pointing up
4. You will be taken here to upload your file. You can drag the file to the box or click on the box and then upload your file
5. If the upload fails, you will be notified of it. Make sure you have all the required fields filled and that the file type is correct.
6. If the upload fails again, please send it in an email to support@kounta.com outlining the errors you encountered.
Edit existing products: download the Product Export
2. In the Export Products page, make sure CSV (Comma Separated Values) file is ticked (see image below)
5. Open the CSV file using Google Sheets. If you have any products manually added to Kounta, they will be included in the file
6. Fill in this CSV, save, then upload to Kounta (as discussed above)
Related Articles
Create Your Products in Kounta
Create your products 1. Under Products from the Kounta Back Office, select Add Products 2. Fill in the basic product information Name Category (Categorise your products to make them visible on the POS screen) Sales Price Sales Tax Type 3. ...Adding your inventory items to Kounta
Before you begin Make sure that you have enabled any Produce plan first to be able to see and edit your products inventory settings. Add stock items You add stock items the same way as adding normal products into Lightspeed Kounta. But here’s ...Price List Add On - Enable, Create & Activate
Enable Price Lists Add-on 1. From the Add-ons Page in Kounta Back Office, find the Price Lists Add-on 2. Enable this Add-on by clicking on the orange Enable Price Lists button Create Price List 1. Under Sites from the Kounta Back Office, select ...How to create product variants
Setup Product Variants 1. Under Products from the Kounta Back Office, select the product for which you'd want to set up variants. If this is for a new product, add the product first. 2. Next, open the product settings page by selecting the cogwheel. ...Adding Products to Your Printer (Kounta)
Please follow this link for a video on how to add products to your printer. https://www.useloom.com/share/533cc0f652c148adbfd7a81b739dbccf