ID #1442

Is it possible to import product recipe through excel file?

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

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

  1. Go to Main Menu > Settings >  Import & Export > Import Data(T>I>I) 
  2. Alt + L
  3. Select “Product Recipe” from the list
  4. Set other option
  5. Select the excel file in “File Name” field
  6. Map the headings of the excel file with FusionRetail6 fields
  7. Alt + I (or you may use “– I Import” button)
  8. It will import the recipe excel file in the database

Step3: Check the recipe in FusionRetail6

  1. Go to Main Menu > Master > F&B > Product Recipe (M> F> R)
  2. Alt + L
  3. 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:

Tags: Excel, Import Data, Product Recipe

Related entries:

You cannot comment on this entry