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 or 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

    • Open the file saved to your computer using Excel.

    • Fill in the template columns with your ingredient information:
      • Leaving the category field blank will leave the ingredient as Uncategorized.
      • New categories will be created for any new categories identified in the category column.
      • Leaving the “Ingredient - Track Stock” blank in Alert column will default the "Track Stock" to off. Place a "Y" if you would like to track stock for this ingredient.
      • Leaving the COGS - Track Cost column blank will default the Track COGS to off. Place a Y if you would like to track cost for this ingredient.
      • Fill in the Cost Amount column if you track COGS.

        2.png

      • Save the edited CSV file to your computer.

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

  9. Click Upload.

    importing_list_of_ingredients_moka_pos.png

Congratulations! You have successfully import ingredients using Excel. 

Was this article helpful?
4 out of 5 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