Articles on: Upload/Import Files

Import Item

An item has to be always associated with a category and tax components. For example, if we want to import the following items


  1. Lay’s BBQ
  • Lays BBQ 100g
  • Lays BBQ 200g


  1. Chicken Legs
  • Chicken Legs 2pcs
  • Chicken Legs 4pcs


  1. Oranges


Lays BBQ and Chicken Legs has 2 variations each.


Items display in POS




On clicking Lays BBQ, the following popup with the 2 item variations will open.




If Lays BBQ 100g, Lays BBQ 220g, Chicken Legs 2pcs and Chicken Legs 4pcs are to be displayed as 4 items in POS, create them as 4 separate items.


  1. Item Name: Unique name for the item.
  • Lay’s BBQ
  • Chicken Legs
  • Oranges


  1. Category Name: Category name to which the item belongs.
  • Chips for Lay’s BBQ
  • Meat for Chicken Legs
  • Fruits for Oranges


  1. Item Description: Description of the item.
  • Lay's BBQ Flavored Potato Chips for Lay’s BBQ
  • Chicken Legs Finest Quality for Chicken Legs
  • Australian Oranges for Oranges


  1. Variation Name: Variation name of the item.
  • Lay's BBQ 100g for Lay’s BBQ
  • Chicken Legs Finest Quality for Chicken Legs
  • Australian Oranges for Oranges


  1. Alternate Language: Variation name can be given in required languages and can be printed on the bill. Example Arabic, Tamil, Hindi, etc.


  1. Variation Type:
  • sale - To indicate the item is for sale.
  • combo - To indicate the item is a combo. A combo item is the parent item under which you can associate multiple items of type sale.
  • ingredient - To indicate the item is an ingredient. (Available only for Restaurant and QSR)
  • modifier - To indicate the item is an Add-On or extra. For example extra cheese, vegetables, etc. (Available only for Restaurant and QSR)


  1. Unit Measure Type:
  • count - To indicate the item is sold in numbers / pieces.
  • **weight **- To indicate the item is sold in kilograms.
  • volume - To indicate the item is sold in litres.
  • length - To indicate the item is sold in units of length. Example meter, centimeter, etc.
  • time - To indicate the item is sold in units of time. Example hour, minute, second, etc.
  • capacity - To indicate the item is sold in units of capacity.
  • area - To indicate the item is sold in units of area. Example square-meter, square-kilometer, square-mile, etc.
  • other - If your option is not found, choose other.


  1. SKU: Stock Keeping Unit (SKU) of the item variation and is unique. No two items should have the same sku.


  1. Barcode: Barcode of the item variation.


  1. Max Price: Maximum price beyond which the item variation cannot be sold.


  1. Min Price: Minimum price under which the item variation cannot be sold.


  1. Selling Price: Selling price of the item variation.


  1. Buying Price: Buying price of the item variation.


  1. Pricing Type: Item can have only one pricing type. Either fixed or variable or multi.
  • fixed : Fixed pricing, selling price cannot be changed during sale in POS.
  • variable : Variable pricing, selling price can be altered during sale in POS.
  • **multi **: Item has multiple prices categories and can be sold in different prices.


  1. Stock: Inventory stock of the item variation in numbers / pieces / litres / kilograms.


  1. Tax: Tax component of the item variation, if the item has multiple tax components, separate multiple tax components with comma. For example VAT 5%,GST 5%
    Navigation: Main Menu --> Items --> Taxes
    Tax name is case sensitive and copy the tax name given in the Tax sheet. If the tax is already created, copy from "Main Menu --> Items --> Taxes" and paste in the XL.




  1. Locations: Inventory location of the item variation, if the item has to be added in multiple locations, separate locations with comma. For example Marina,Eldams Road.


Navigation: Main Menu --> Account & Settings --> Locations
Location name is case sensitive and available under "Name" column. Copy and paste in the XL.


  1. Device: KOT device name applicable only for restaurant and qsr. Leave it empty if there is no KOT device.
    Navigation: Main Menu --> Account & Settings --> Devices
    Device name is case sensitive, copy from "Main Menu --> Account & Settings --> Devices" and paste in XL. If there are multiple KOT’s, paste the corresponding kot name against the items.


  1. Track Inventory: 1 - To track the inventory of the items when sold, returned, transferred and purchased. If no tracking needed leave it empty.


  1. Food Type : Food type of the item variation.
  • **veg **- Vegetarian food
  • nveg - Non Vegetarian food
  • egg - Eggeterian food


  1. Alternate Code : Keyboard shortcut of the item variation. Type the corresponding numbers and press enter in the POS to add the item in the cart. For example
  • 1 for Australian Oranges
  • 11 for Lay’s BBQ 100g
  • 12 for Lay’s BBQ 200g
  • 211 for Chicken Legs 2pcs
  • 212 for Chicken Legs 2pcs


  1. HSN: Harmonized System Nomenclature (HSN) of the item variation.


  1. MRP: Maximum retail price of the item variation (MRP applicable only in India).


  1. Stock Alert Quantity: Quantity below which the system will display a warning.




Note: Columns names marked with RED colour in View Sample XL sheet are mandatory fields.


Updated on: 23/03/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!