How to Import Recipes Using Excel

You are now able to import your recipes using Import Recipes feature. This feature will help you to save time in inputting your recipes on backoffice.

Note: You need to complete both items reference and ingredients reference first to import recipes. 

 

Here are the steps to import your recipes: 

  1. Login to your backoffice at https://backoffice.mokapos.com/.

  2. Select menu INGREDIENT.
  3. Select Recipes

    how_to_import_recipes_using_excel_mokapos.jpg

  4. Click Import/Export.

    import_recipes_using_excel_mokapos.jpg

  5. Choose Import Recipes.

    importing_recipes_using_excel_mokapos.jpg

  6. Continue to import recipes by clicking Download Template.

    importing_recipes_via_excel_mokapos.jpg

    Note: To download the tutorial and reference on how to fill the recipe excel sheet, press the click here link. The reference file consists of list of items and ingredients that are already available on the selected outlet.

    create_recipes_via_import_excel_mokapos.jpg

  7. Fill in the template according to the instruction provided:

  • Please do not change any columns that have (do not edit) text. 

  • Fill in the Item_Name column only with items that are already registered in the backoffice. Filling this column with items that have not been registered will cause errors. 

  • Fill in the Variant_Name column only with variant names that are already registered in the backoffice. Filling this column with variant names that have not been registered will cause errors. 

  • Fill in the Ingredient_Name column only with ingredient names that are already registered in the backoffice. Filling this column with ingredient names that have not been registered will cause errors. 

  • Fill in the Ingredient_Unit column only with ingredient measurements that are already registered in the backoffice. Filling this column with ingredient measurements that have not been registered will cause errors. 

  • Insert the Ingredient_Quantity column with amount needed to create recipe (Max 6 digits and decimals to two decimals) 

  • Avoid inserting the ingredient amount less than or equals to 0 on the Ingredient_Quantity column. 

  • Do not exceed the maximum rows capacity of 2500 on Excel sheet when creating the recipe

    import_recipes_template_mokapos.png

 

    8. Save the .csv file to your computer. Click Next.

create_recipes_via_excel_mokapos.jpg

    9. Select New Recipes. Then, click Import to continue the importing process. 

creating_recipes_via_import_excel_mokapos.jpg

   10. Drag and drop the .csv file to the box.

create_recipes_with_excel_mokapos.jpg

   11. Click Import.

impor_recipe_di_mokapos.jpg

   12. Wait until the importing process is finished.

easier_way_to_create_recipes_mokapos.jpg

   13. Congratulations! You have created recipes via Excel import.

recipes_via_impor_excel_mokapos.jpg

 

 

 

 

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