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.)

● “ADDON” for addon products. (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

 

to EPOS WhatsApp Chat