Ontray’s import process allows you to bulk upload your restaurant’s menu from a simple csv file. While everything you’re doing can be done using your dashboard, this process will allow you to quickly build a complete menu with attributes using only a few spreadsheets.

To connect your spreadsheet to Ontray you can either directly upload a csv file or use a Google Spreadsheet. The former is easier but the latter allows for easy collaboration between team members.

Upload your spreadsheets using the Import section of your dashboard.

Sample Spreadsheets

The results of the sample spreadsheets below can are visible on our demo site.

Items

Each item row represents a top level menu item ie. Spaghetti & Meatballs.

ItemID

This is any unique ID for the item which should not change once initially imported. It is used to identify the item when importing as well as connect attributes and modifiers.

Name

The name of the item which appears on the main menu.

SKU

An optional field for tracking SKUs along side the name. It needs to be unique.

Description

Description of the item which appears in the add to cart menu.

Price

The price you’d like to charge before any additional fees from item attributes.

Categories

Commas separated list of the categories the item will be assigned to. If the category does not already exist one will be created. Ex: Calzones

Status

  • Draft
  • Published

Published items will be visible on the site and users are able to buy them. Draft items will be visible on your site’s dashboard but are not available for purchase.

Type

  • Simple
  • Variable

Simple products do not have any attributes connected. For instance a piece of pie that can’t be modified. Variable products however, can have item attributes. For instance a ‘Pizza’ product would be variable if you choose to add toppings or size options. You can create these attributes using the Attributes section below.

Taxable

  • True
  • False

If true, tax is charged for the item on checkout at a rate specified on your admin Account page.

StoreID

The ID number of your Ontray store. Contact Ontray if you do not know this number already.

Attributes

Attributes give the user the ability to modify the item before it enters their cart. For example a ‘Size’ attribute could have values ‘Small’, ‘Medium’ and ‘Large’ with matching prices.

ItemID (Required)

This specifies which item the attribute should belong to. It should be the same value as specified in the Item import.

Name (Required)

The name of the base attribute ie. ‘Size’. Use the same name on multiple rows to provide multiple options.

Value (Required)

The value of the attribute option. If the base attribute is ‘Size’ the value might be ‘Small’.

Price

The amount of money to charge for the option above the base price.

DoublePrice

(PizzaToppings Only) The price for double toppings on a whole pizza.

HalfPrice

(PizzaToppings Only) The price for normal toppings on half of the pizza.

HalfDoublePrice

(PizzaToppings Only) The price for double toppings on half of a pizza. Required

  • True
  • False

If the user need to provide an option.

Type (Required)

  • Select
  • MultiSelect
  • PizzaTopping

Select attributes only allow the user to select one of the options provided ie. Size can be either Small, Medium or Large. MultiSelect attributes allow the user to select 1 or more options from the list provided. Finally, Pizza Toppings are a special type of attribute that give the user the ability to select the left side, right side and whole pizza. To use this you must provide the DoublePrice, HalfPrice and HalfDoublePrice fields.

Maximum

Sets the maximum number of MultiSelect or PizzaTopping attributes the user can set. A ‘Toppings’ attribute might have 10 values but if the maximum is 3 the user can only select up to 3.

Priority

The order in which this attribute will display relative to the other attributes for the same item. 0 is the top priority and if no value is provided an order will be assigned by the system.

StoreID

The ID number of your Ontray store. Contact Ontray if you do not know this number already.

Modifiers

Modifiers allow the selection of one attribute to change the price of another attribute. For instance toppings could be $2.00 on a small pizza but $3.00 on a large. Using that example the topping would be your Primary Attribute (see below) and the size would be the Secondary Attribute. If the secondary value is selected by the users, user select Large, the primary attribute will have the modifier prices added to it’s price.

ItemID (Required)

This specifies which item the connected attributes belong to. It should be the same value as specified in the Item and Attribute imports.

PrimaryName (Required)

The name of the primary attribute ie. ‘Toppings’. This attribute will have its price modified by the prices specified.

PrimaryValue (Required)

The value of the primary attribute ie. ‘Sausage’.

SecondaryName (Required)

The name of the secondary attribute ie. ‘Size’. If this attribute is selected by the user, the primary attribute price will be modified.

SecondaryValue (Required)

The value of the secondary attribute ie. ‘Large’.

Price

The amount of money to charge for the attribute above its base price.

DoublePrice

(PizzaToppings Only) Amount charged above the DoublePrice.

HalfPrice

(PizzaToppings Only) Amount charged above the HalfPrice.

HalfDoublePrice

(PizzaToppings Only) Amount charged above the HalfDoublePrice.

StoreID

The ID number of your Ontray store. Contact Ontray if you do not know this number already.