How to Import Ingredients Using Excel

Before you can manage and monitor the ingredient inventory and create a recipe, it is necessary to create the ingredient first. If you want to create for more than 50 ingredients, we advise you to import the list of your ingredients on Excel: 

Here are the steps to import ingredients using Excel: 

  1. Login backoffice Moka.

  2. Select menu INGREDIENT.

    how_to_import_ingredients_using_excel_mokapos.png

  3. Choose Ingredient Library.

    how_to_import_ingredients_moka_pos.png

  4. Click Import/Export. 

    how_to_import_ingredient_mokapos.png

  5. Select Import Ingredients.

    how_to_import_ingredients_to_backoffice_mokapos.png

  6. Select Modify Ingredient Library to add new ingredients and update existing ingredients.

    Select 
    Replace Ingredient Library to delete all existing ingredients and replace them with your uploaded ingredients.

    how_to_import_ingredients_from_excel_mokapos.png

  7. Click Next.

    how_to_import_ingredients_from_excel_mokapos_copy.png

    Notes:
     If you do not have the template to import the ingredients, click Download Our Template.

    how_to_import_ingredients_from_excel_moka_pos.png

  8. Open the file saved to your computer using Excel.

  9. Fill in the template columns according to these columns:
    • Column A: Internal ID that will generate automatically. Do not need to edit or fill in this column.

      cara_impor_ingredients_dari_excel_.png

    • Column B: Insert the ingredients name.

      cara_impor_ingredients_dari_excel_moka_pos.png

    • Column C: Insert the ingredients category name.

      cara_impor_ingredients_dari_excel_moka.png

    • Column D: Do not edit this column. You can only adjust this column on the Inventory section (Purchase Order and Adjustment). 

      cara_impor_ingredients_dari_excel.png

    • Column E: Insert the ingredients units in shorten format (for example: If the ingredients unit is in grams, type g only on the column). 

      cara_mengimpor_ingredients_dari_excel_moka_pos.png

      Here is the list of ingredients units in shorten format:
      • Pieces (pcs) 
      • Millilitre (ml)
      • Milligram (mg)
      • Meter (m) 
      • Inch (in) 
      • Centimeter (cm)
      • Gram (g) 
      • Litre (l) 
      • Kilogram (kg) 
      • Tablespoon (tbsp) 
      • Teaspoon (tsp)
      • fluid ounce (fl oz) 
      • Cup (c) 
      • quart (q) 
      • Pound (p) 
      • Pint (pt)
      • Ounce (oz) 
      • Gallon (gal)

    • Column F: Type Y if you want to track the number of ingredients stock. Type N if you do not want to track ingredient stock instead. 

      cara_mengimpor_ingredients_dari_excel_moka.png

    • Column G: Insert the nominal for minimum ingredient stock alert. You will receive a notification once your stock reach the inserted nominal. Type the number 0 if you do not want to receive this notification. 

      cara_mengimpor_ingredients_dari_excel.png

    • Column H: Type Y if you want to track the Cost of Goods Sold (COGS) of those ingredients. Type N if you do not want to track the COGS. 

      cara_mengimpor_ingredinets_mokapos.png

    • Column I: Insert the cost of ingredients per unit

      impor_ingredients_dari_excel_.png

    • Save the file under .csv format.

  10. Drag and drop the CSV file into the upload area or click on the upload area.

    how_to_import_ingredients_to_excel_moka_pos.png

  11. Click Upload.

    importing_list_of_ingredients_moka_pos.png

Congratulations! You have successfully import ingredients using Excel. 

Was this article helpful?
6 out of 9 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Still Have Questions?

Our customer care team is here for you!

Contact Us