Contents

Item Import

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

Action

Display

1. Navigate to the SpotOn Restaurant Back of House.

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

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.

(Optional) Creating Menu Item Spreadsheet for Import

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

The only REQUIRED portion of each item row is the item name and item price. All other information can be added later from the Point of Sale.

Enter the item price, with or without dollar sign

If the item price has more than two numbers after the decimal point, it will display on the first two numbers (e.g. an item priced "$1.55555" will be displayed in the POS as "$1.55").

If you're using cash discount, the price entered will be the standard, non-cash discount pricing for the item.

Enter the Menu group

If the item exists in multiple menu item groups, you can add them separated by commas

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

Multiple items can share the same barcode.

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

The Tax Name for each item must be unique, otherwise it will cause an error when uploading

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.

Menu Item Import | SpotOn Restaurant BOH

Item Import

(Optional) Creating Menu Item Spreadsheet for Import