Importing and exporting menus

Import menus from a CSV file to save time by adding main screens and existing items at the same time.
To save a copy of the menu data outside the Back Office, export existing menus into CSV files. The file contains the SKU of each item on the menu, and the name of the screen each item is on.

Importing menus

Set up which existing items are added to which screens within a menu. If the main screen doesn't exist yet, it will be created. If the main screen already exists, it will be updated. The maximum import of rows per menu is 10,000. The file format for the import is CSV or XLS. Use the export file of a menu as an import template.

Formatting the import menus file

• The import file must be a CSV or XLS formatted spreadsheet.
• The first row must contain the following headers: SKU and Screens.
• The import file is limited to 10,000 rows total. If you have more than 9,999 items to import, create separate imports.

SKU	Screens
Mandatory. List all SKUs you want to add to the menu.	Mandatory.  Add the top level screen name of each SKU.  (Optional) If the SKU is added to a sub-screen, add the top level screen name and the sub-screen name where the SKU is placed with two hashtags between.
Example:  The SKU 250 (sparkling water) is added to the top level screen Drinks. The SKU 131 (cappuccino) is added to the sub-screen Coffee within the top level screenDrinks.
250	Drinks
131	Drinks##Coffee

 

To import the file to the Back Office: 

1. Log in to your Back Office with your Lightspeed Restaurant credentials.
2. From the main navigation menu, select Menu management > Menu.
3. Click Import to open the import items and menus page in the items section.
4. Click Browse and choose the import file. The upload process might take a few minutes.
5. (Optional) If some columns are not necessary for the import, turn them off in Columns selection.
6. Make sure the titles of your file data are correct and click Map columns with identical names.
7. If the file should replace the existing menu in the Back Office, toggle on the slide control Replace the menu with the content of the file in the Additional parameters section.
   
   1. Toggle off the slide control to additionally add items and screens to the menu.
8. (Optional) Toggle on Dry-run to only test but not import the items and screens.
9. Click Continue.
10. Click the Confirm submission button. The upload may take some time.
    
    1. Successful import: The confirmation The import process completed successfully appears.
    2. Unsuccessful import: Please upload the file again.

Exporting menus

To save and use menu data beyond the Back Office, export existing menus into CSV files. The file contains the SKU of each item on the menu and the name of the screen each item is on.

1. Log in to your Back Office with your Lightspeed Restaurant credentials.
2. From the main navigation menu, select Menu management > Menu.
3. Click the name of the menu to export.
4. Click More actions and select Export from the drop-down menu. The CSV file will be automatically saved to your computer.