How can we help you?

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

  2. Chicken Legs

    • Chicken Legs 2pcs

    • Chicken Legs 4pcs

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

  • Item Name: Unique name for the item.

    • Lay’s BBQ

    • Chicken Legs 

    • Oranges        

  • Category Name: Category name to which the item belongs.

    • Chips for Lay’s BBQ

    • Meat for Chicken Legs

    • Fruits for Oranges

  • 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     

  • 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         

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

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

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

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

  • BarcodeBarcode of the item variation.

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

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

  • Selling PriceSelling price of the item variation.

  • Buying PriceBuying price of the item variation.      

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

  • StockInventory stock of the item variation in numbers / pieces / litres / kilograms.

  • 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%
    NavigationMain 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.

  • LocationsInventory location of the item variationif the item has to be added in multiple locations, separate locations with comma. For example Marina,Eldams Road. 

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

  • Device: KOT device name applicable only for restaurant and qsr. Leave it empty if there is no KOT device. 
    NavigationMain 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.

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

  • Food TypeFood type of the item variation.

    • veg - Vegetarian food

    • nveg - Non Vegetarian food

    • egg - Eggeterian food

  • Alternate CodeKeyboard shortcut of the item variation. Type the corresponding numbers and press enter in the POS to add the item in the cart. For example 

    • 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 

  • HSNHarmonized System Nomenclature (HSN) of the item variation.

  • MRPMaximum retail price of the item variation (MRP applicable only in India).  

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

Give us thumbs up for this article, if it was useful?Yes NoThank you so much for your kind feedback. 👍Something went wrong. Please try after some time.