Menu Item Import | SpotOn Restaurant BOH

Owned by Will Castleberry
Last updated: Aug 16, 2024 by Jaclyn DiPiazza
4 min read

Contents

Item Import

Importing Menu Items from the template below is a quick way to add Menu Items to the system.

 

 

Action

Display

Action

Display

1. Navigate to the SpotOn Restaurant Back of House.

2. Select Menu Import from the Menu section of the screen

 

image-20240206-000022.png

3. Drag your Item spreadsheet (*.CSV file) onto the menu import screen, or navigate to the file by selecting on Click to browse files and locating your spreadsheet through the file browser

4. When prompted, select Menu Items

5. Select OK

6. If successful, a confirmation window will appear

7. Navigate to the Menu Item Group screen. At this point, you can assign colors and sorting to the items

8. Select Edit Menu Items and confirm that all items were imported successfully. Additional information about the items can now be changed.

If the Menu Group, Printer Group, or Report Group for an item did not exist before import, it will have been created for you during the import process. If the Groups already existed, the item will automatically be placed into those existing groups.

Menu Item names exist at the organization level, meaning you can’t import data for specific locations.

Uploading a file with existing items will not duplicate the item. It will update the existing item with the new values entered.


Example:

Item “Can of Soda” already exists in the menu with a price of $1. If a spreadsheet is uploaded with an item named “Can of Soda” and a price of $2, there will only be a single item on the menu named “Can of Soda” with a price of $2.

 

image-20240206-000056.png
Menu Import Screen

 

(Optional) Creating Menu Item Spreadsheet for Import

Action

Display

Action

Display

Download the Menu Item template for guidance, which provides the necessary structure for the CSV file you will import. 

 

  • Click on the Menu Item Template button (image)
    b. This downloads a *.CSV file, which can be opened in Microsoft Excel, Google Sheets, or other programs that can read *.CSV files

  • Open the file in your preferred program

  • Add the item's name in the Name column

  • Enter the item price, with or without dollar sign

  • Enter the Menu group

  • Enter Report Group

  • Enter Printer Group. If the item is assigned to multiple printers, you can add them separated by commas

  • Enter the Item Display Name as it will appear for the Printer, the Receipt, and Online Ordering (three separate columns)

  • Enter Item Description for Online Ordering

  • Enter a Barcode (UPC) number if the item uses a barcode

  • Enter Modifier Group. If the item is assigned to multiple modifier groups, you can add them separated by commas

  • Enter Item Tax Name

  • Enter Item Tax Percentage (number or number with percentage sign %)

Following the above instructions, enter all items into the spreadsheet and save it as a *.CSV file.