Product Basic Import Template Columns | EPOS POS System

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

 

Was this article helpful?
YesNo
to EPOS WhatsApp Chat