Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Contents


Item Import

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

Iframe
scrollingno
allowfullscreentrue
srchttps://share.synthesia.io/embeds/videos/1fcd66f0-ed5b-4aa5-84e2-a1f15847b2f6
width786
frameborderhide
height440

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.pngImage Modified

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.

Info

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.

Note

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

Info

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.pngImage Modifiedimage-20240206-000833.pngImage Modifiedimage-20240206-001044.pngImage Modifiedimage-20240206-001145.pngImage Modifiedimage-20240206-001242.pngImage Modified

 

(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

Info

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

Info

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").

Info

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

  • Enter the Menu group

Info

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

Info

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

Info

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.

image-20240206-000450.pngImage Modified

 

image-20240206-000636.pngImage Modified