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 backoffice Moka.
   
   
2. Select menu INGREDIENT.
   
   
3. Select Recipes. 
   
   
   
   
4. Click Import/Export.
   
   
   
   
5. Choose Import Recipes.
   
   
   
   
6. Continue to import recipes by clicking Download Template.
   
   
   
   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.
   
   
   
   
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
     
     
     
     
8. Save the .csv file to your computer. Click Next.
   
   
   
   
9. Select New Recipes. Then, click Import to continue the importing process. 
   
   
   
   
10. Drag and drop the .csv file to the box.
    
     
11. Click Import.
    
    
    
    
12. Wait until the importing process is finished. 
    
    
    
    
13. Your recipes have been successfully created in your backoffice.