Bulk changes to your menu in Excel
Prerequisites
You have your menu exported into a spreadsheet.
Attach it here:
Once the menu has been setup, you can easily make bulk changes by editing this menu in the following way:
Toppings
Columns AC - AL
Give the Option a Name - column AC Options e.g. Toppings 9"
Add your Toppings in - column AD Option Values e.g. Red Onions
Note
Ensure you complete all the prices in columns AF-AI
Once you have added all the toppings you require simply copy the Option Name in column AC Options and paste it into column AA Product Options for the applicable Product.
This will assign this Option to this Product
Default Toppings
Column AB
Add your default toppings to the column Default Options Value for each product.
These should be added in the format :
[BBQ Sauce, Cajun Chicken, Fresh Chillies, Sun Blush Tomatoes, Mozzarella, Red Onion];[]
Note the
Brackets at the start and end of the items, and the , separating each of the Default Toppings.
Tip - Copy (Ctrl + C) the toppings from column AD Option Values to ensure that the toppings match in spelling exactly otherwise the system will not know these are the same toppings.
If you have multiple Options for a Product then place the Default Toppings in the right position e.g. []; [] where the first bracket is for the first option and second for the second Option in column AA
Kitchen Categories
Columns AM - AN and V
Give the Kitchen Category a Name - column AM Kitchen Category Name
Add these Kitchen Categories in column V Printer Category
Note that
You can add positions for these Kitchen categories in column AN Kitchen Category Position
Once you have made all your changes feel free to reply to this ticket and ask us to check the spreadsheet before importing it in for you.
You have your menu exported into a spreadsheet.
Attach it here:
Once the menu has been setup, you can easily make bulk changes by editing this menu in the following way:
Toppings
Columns AC - AL
Give the Option a Name - column AC Options e.g. Toppings 9"
Add your Toppings in - column AD Option Values e.g. Red Onions
Note
Ensure you complete all the prices in columns AF-AI
Once you have added all the toppings you require simply copy the Option Name in column AC Options and paste it into column AA Product Options for the applicable Product.
This will assign this Option to this Product
Default Toppings
Column AB
Add your default toppings to the column Default Options Value for each product.
These should be added in the format :
[BBQ Sauce, Cajun Chicken, Fresh Chillies, Sun Blush Tomatoes, Mozzarella, Red Onion];[]
Note the
Brackets at the start and end of the items, and the , separating each of the Default Toppings.
Tip - Copy (Ctrl + C) the toppings from column AD Option Values to ensure that the toppings match in spelling exactly otherwise the system will not know these are the same toppings.
If you have multiple Options for a Product then place the Default Toppings in the right position e.g. []; [] where the first bracket is for the first option and second for the second Option in column AA
Kitchen Categories
Columns AM - AN and V
Give the Kitchen Category a Name - column AM Kitchen Category Name
Add these Kitchen Categories in column V Printer Category
Note that
You can add positions for these Kitchen categories in column AN Kitchen Category Position
Once you have made all your changes feel free to reply to this ticket and ask us to check the spreadsheet before importing it in for you.
Updated on: 27/11/2024
Thank you!