Articles on: Back Office

Bulk changes to your menu in Excel

Prerequisites

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

Was this article helpful?

Thank you!