Import Item Ingredient Update

Update ingredients for an item variation. For example, the item is Chicken Noodles and the ingredients used to prepare are chicken(50g), noodles(200g), sauce(20ml), onion(50g), cabbage(100g), masala(10g). Chicken noodles served with a disposable plate(1 Nos) and spoon(1 Nos). You can also add a plate and spoon under ingredients.

Item Variation SKU: SKU of the item variation (Chicken Noodles).
Location : Ingredients location of the item variation, if the ingredients update has to be done at multiple locations, separate the locations with comma. For example Location1,Location2,Location3
Item Ingredient SKU: SKU of the ingredients (chicken, noodles, onion, tomato, cabbage, masala, plate and spoon).
Quantity: Quantity of ingredients required.
Unit Of Measurement: Unit of measurement of the ingredients.
count - Ingredients consumed in count/numbers.
volume_teaspoon - Liquid ingredients consumed in Teaspoon.
volume_tablespoon - Liquid ingredients consumed in Tablespoon.
cup - Liquid ingredients consumed in Cup
ml - Liquid ingredients consumed in Millilitres.
l - Liquid ingredients consumed in Litres..
weight_teaspoon - Solid ingredients consumed in Teaspoon.
weight_tablespoon - Solid ingredients consumed in Tablespoon.
kg - Solid ingredients consumed in Kilograms.
g- Solid Ingredients consumed in Grams.
mg- Solid Ingredients consumed in Milligrams.

Note: Columns names marked with RED colour in Download Sample XL sheet are mandatory fields. Available only for Restaurants and QSR. Based on ingredients cost and selling price, the profit is projected.

Updated on: 06/10/2021