Yes, now you can import product recipe through excel file. To use this feature please use the following steps…
Step1: Creating an excel file for product recipe
- Create an excel file with the following columns
|
ProductID |
Product ID of the product for which you are creating a recipe |
|
Product Name |
Name of the product for which you are creating a recipe |
|
Quantity |
Quantity of production of the product for which you are creating a recipe |
|
OverHead% |
Percentage overhead on food cost |
|
Method/Preparation |
Method of preparation |
|
RecipeProductId |
Product ID of the raw product, required to produce the menu item |
|
RecipeProductName |
Product Name of the raw product, required to produce the menu item |
|
RecipeQty |
Quantity of the raw product, required to produce the menu item |
Step2: Import the excel file in FusionRetail6 software
- Go to Main Menu > Settings > Import & Export > Import Data(T>I>I)
- Alt + L
- Select “Product Recipe” from the list
- Set other option
- Select the excel file in “File Name” field
- Map the headings of the excel file with FusionRetail6 fields
- Alt + I (or you may use “– I Import” button)
- It will import the recipe excel file in the database
Step3: Check the recipe in FusionRetail6
- Go to Main Menu > Master > F&B > Product Recipe (M> F> R)
- Alt + L
- Select the product from the list for which you imported a recipe, it will populate the details of data imported as recipe
For more detail please visit: