Product Basic Import Template Columns

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