Column A : product_handle (compulsory)
Product code, usually can be the same as SKU.
💡 Must not have duplicates.
💡 Product Handle field supports special characters – . _ ~ : / ? # [] @ ! $ & ‘ () * + =”
Column B : sku (compulsory)
Known as Stock Keeping Unit.
💡 Must not have duplicates.
💡 SKU field supports special characters – . _ ~ : / ? # [] @ ! $ & ‘ () * + =”
Column C : product_category
Product category, just enter the sub category name if available.
Column D : product_name (compulsory)
Enter the product name as concisely as possible, multiple languages are accepted.
Column E : product_open_price
Only “TRUE” or it can be left blank.
- “TRUE” to allow cashiers to enter prices manually at the POS.
- “FALSE” or left blank to disable open price setting at POS.
Column F : variant_base_price (compulsory)
Price for sale
Column G : barcode_raw
Enter product barcode manually or scan item barcode with a barcode scanner.
Column H : variant_supplier
Enter supplier name. (if any)
Column I : variant_cost_price
Enter price purchased from supplier.
💡 User may leave this column blank as needed.
Column J : tax
Enter the tax type which was configured, if any.
For more information, see Tax Rules.
💡 Tax Type must be created in backend portal before bulk importing products (if applicable).
Column K : product_class
Enter one of the following. (as relevant)
- “COMPOSITE” for composite products. (e.g. a carton of coke = 12 cans.)
- “MODIFIER” for modifier products (Add-on & Option). (e.g. additional toppings/servings which are chargeable)
- “SETMENU” for products associated with a set menu.
- “SERIAL” for products with serial number
- “PACKAGE” for products to be setup as package
💡 To be left blank if not applicable, = normal product
