Duplicating a menu for use on the same business
The menu import and export feature is a powerful tool, and it can also be used to help duplicate an existing menu. It is very important to follow the steps provided to not disrupt any of the existing menus and menu items. If you need to duplicate multiple menus and their menu items, we suggest this is done menu by menu. For other usage scenarios, please see the Menu Importing and Export guide.
Menus
Menu Exporting
How to locate the Menu page: Redbox Management → Businesses → Select a Business → Menu
Once on the ‘Menu’ page:
Select ‘Export’.
Select ‘Menu’.
Select ‘Creating new items’.
Select Export. This will create and download a CSV file with all the menus currently available for this business without any ID’s.
Open the CSV file, and populate the fields with duplicate menu details, we suggest naming the duplicate menu slightly different to make it easier to identify on import. The duplicate menu name can be updated once the duplication is completed. Please leave any duplicated menu’s ‘id' field blank, the Redbox System will assign these menus with a unique ID upon importing them. DO NOT edit any of the headings on the CSV file, these are used for importing the file back into the Redbox system to identify the relevant import type.
Example of an export file for menus before menus are duplicated:
Example of an export file for collection menu being duplicated for delivery:
When you have finished editing the file, please select the system and program you are using to correctly save the CSV file ready for importing your updated file into Redbox Management:
Apple - Numbers - see the Saving the CSV using Apple's Numbers program guide.
Windows - Excel - see the Saving the CSV file using Windows Excel program guide.
Google Docs - see the Saving the CSV file using Google Docs guide.
Menu Importing:
Redbox Management will automatically detect which type of import you are submitting.
How to locate the Menu page: Redbox Management → Businesses → Select a Business → Menu
Once on the ‘Menu’ page:
Select ‘Import’.
Select ‘Browse’.
Locate the menu CSV file you would like to import.
Select ‘Start Import’. A view called ‘Import Data’ will appear with all the data from the CSV file.
From this view, you can:
make further changes to the menus if necessary.
select the menus you would like to be imported or deselect items which you do not want to be imported.
Once you are happy with the current selection, select ‘Import Selected’.
One by one the items will be imported. When the import is complete, you will get a success message.
Please refresh the screen after each import is successful to see the updates.
Menu Items
Menu Item Exporting
How to locate the Menu page: Redbox Management → Businesses → Select a Business → Menu
Once on the ‘Menu’ page:
Select ‘Export’.
Select ‘Menu Items’.
Select ‘Update existing items’.
Select Export. This will create and download a CSV file with all the menu items currently available for this business.
Open this CSV file, copy the menu items that need duplicating. Please leave any duplicated menu item’s ‘id’ and 'menuId' fields blank, the Redbox system will assign the duplicated menu items their own unique ID on import and you will be able to manually assign the menu items to the duplicated menu. DO NOT edit any of the headings on the CSV file, these are used for importing the file back into the Redbox system to identify the relevant import type.
Example of an export file for menu items before menu items are duplicated:
Example of an export file with the duplicated menu items added:
When you have finished editing the file, please select the system and program you are using to correctly save the CSV file ready for importing your updated file into the Redbox Management Portal:
Apple - Numbers - see the Saving the CSV using Apple's Numbers program guide.
Windows - Excel - see the Saving the CSV file using Windows Excel program guide.
Google Docs - see the Saving the CSV file using Google Docs guide.
Menu Item Importing
The Redbox system will automatically detect which type of import your are submitting (Menu or Menu Items).
How to locate the Menu page: Redbox Management → Businesses → Select a Business → Menu
Once on the ‘Menu’ page:
Select ‘Import’.
Select ‘Browse’.
Locate the menu or menu items CSV file you would like to import.
Select ‘Start Import’.
A view called ‘Import Data’ will appear with all the data from the CSV file.
From this view, you can:
make further changes to the menus if necessary.
select which items you would like to be import or deselect items which you do not want to be imported.
allocate the duplicate menu items the duplicated menu via a pre populated drop down box.
Once you are happy with the current selection, select ‘Import Selected’, one by one the items will be imported. When the import is complete, you will get a success message.
Please refresh the screen after each import is successful to see the updates.
Updating the Duplicate Menu Name
Now that you have successfully duplicated the menu and menu items, you will need to update the duplicated menu name to the name you would like the customers to see.
To do this:
Go to the Menu page (see instructions above).
Locate the required menu and select the three dots next to it.
Select ‘Edit/Schedule’.
Edit the Menu Name.
Select ‘Save’.
Repeat the above steps for each required menu duplication.
How to Save the CSV File
The Redbox systems import facility will only accept files in the .CSV format. Saving the file in the correct format is an important step in setting up the .CSV file.
Saving the CSV using Apple's Numbers Program
Once you have completed the edits to the file:
Select ‘File’.
Select ‘Export to’.
Select ' CSV.
On the Export Your Spreadsheet popover, select ‘Next…’
Set the name of the file and select where you would like the document to be saved.
Select ‘Export’.
Your file is now ready to be imported into Redbox Management.
Saving the CSV file using Windows Excel Program
Once you have completed the edits to the file
Select ‘File’
Select ‘Save’
Locate the .CSV file on your device (it was most likely saved in your downloads file)
Right click the file name, select ‘Open with’ and select ‘Notepad’
The file will be opened in Notepad, here you will need to delete any blank spaces trailing the last comma in the document.
Once you have deleted all the blank spaces trailing the last comma, select ‘File’
Select ‘Save’
Your file is now ready to be imported into the Redbox Management Portal
Saving the CSV file using Google’s Google Docs
Once you have completed the edits to the file
Select ‘File’
Select ‘Download’
Select ‘Comma Separated Values (.CSV)’
The file will now be downloaded to your device and is ready to be imported into the Redbox Management Portal.
Field Values for CSV files
Menus
Column Names: | What is it? | Input Values |
|---|---|---|
id | A unique ID generated by the Redbox system for each menu on creation | LEAVE BLANK |
name | The name of the menu | Enter the name of the menu |
description | A description of the menu | Enter the description of the menu, or leave this blank |
fulfillmentMethods | Which fulfilments the menu will be offered on | DELIVERY|TABLE|COLLECTION each fulfilment needs to be separated by a | and no spaces. This can be left blank and selected on import |
addOnItemsMenu | Sets the menu to be a Add-On-Sale Menu | TRUE or FALSE |
Menu Items
Column Names: | What is it? | Input Values |
|---|---|---|
id | A unique ID generated by the Redbox system for each menu item on creation | LEAVE BLANK |
name | The name of the menu item | Enter the name of the menu item |
price | The price the customer pays for the menu item | Enter a value as ££.pp eg 12.99 |
costPrice | The production or cost price of the menu item, used for managing discounts | Enter a value as ££.pp eg 12.99 or leave the field blank |
minPrice | This is the minimum price the menu item will be offered for ('add-on sale' menu items only) | Enter a value as ££.pp eg 12.99 or leave the field blank |
menuId | The unique ID of the menu which the menu item belongs to | If it is a new menu item, either enter the menu id of the menu (if known), or leave this field blank and select this information on import |
optionId | The unique ID of the option which is assigned to the menu item | If it is a new menu item, either enter the option id of the option (if known), or leave this field blank and select this information on import |
description | A description of the menu item | Enter the description of the menu item, or leave this blank |
isVegan | Allergy tag, enabled (TRUE) or disabled (FALSE) | TRUE or FALSE - if left blank, the field will default to FALSE |
isVegetarian | Allergy tag, enabled (TRUE) or disabled (FALSE) | TRUE or FALSE - if left blank, the field will default to FALSE |
isGlutenFree | Allergy tag, enabled (TRUE) or disabled (FALSE) | TRUE or FALSE - if left blank, the field will default to FALSE |
isDairyFree | Allergy tag, enabled (TRUE) or disabled (FALSE) | TRUE or FALSE - if left blank, the field will default to FALSE |
isAgeRestricted | Age restriction tag, enabled (TRUE) or disabled (FALSE) | TRUE or FALSE - if left blank, the field will default to FALSE |
SKU | A SKU (Stock Keeping Unit) identifier | Any number of digits or letters |
UPC | A UPC (Universal Product Code) number | 12 digits |