Operation

A drop-down menu where you can choose the type of operation to be performed. For the basic template, the Operation is always CREATE.

Entity type

A drop-down menu where you can choose the type of menu entity to create. Options are:

Operation ID

A unique ID for the import operation associated with this row in the import spreadsheet. Must follow these rules:

Toast support recommends entering an operation ID of 1 for the first import operation in the spreadsheet and then incrementing by 1 for each additional operation, so that the operation ID of the second import operation is 2, the operation ID of the third import operation is 3, and so on.

For more information, see Understanding the operation ID.

Name

The name of the menu entity to create. Must follow these rules:

Parent entity type

Use this column to attach the entity created in this row to its parent.

The type of menu entity that will be the parent for the entity created in this row. For specifying a:

Parent version ID or operation ID

Use this column to attach the entity created in this row to its parent.

An identifier that specifies the parent entity for the entity being created in this row. For example, the identifier of a parent menu group that the menu item created by this row will belong to.

The value of this field depends on whether the parent entity already exists or is being created in this same import spreadsheet.

Pricing strategy or method

The pricing strategy or method for the menu entity being created. Case insensitive.

Acceptable values for the Pricing strategy or method column depend on the type of entity being created in the row.

Price

A string representing the menu entity's price. This is the only optional column in the basic template.

Price strings must follow these rules:

Examples of valid price strings:

null
""
".12"
"1"
"10"
"100"
"100.00"
".1"
"100.0"
"100."
"-.1"
"(100.0)"

Examples of invalid price strings:

"$100"
"$a" 
"." 
"€1" 
"10.." 
"..100" 
"10.0." 
"abc" 
"100.0$0" 
"$10a.00"
"$"

Operation

A drop-down menu where you can choose the type of operation to be performed. For the item update template, the Operation is always UPDATE.

Entity type

The type of menu entity to update. For the item update template, the Entity type is always MENU_ITEM.

Operation ID

A unique ID for the import operation associated with this row in the import spreadsheet. Must follow these rules:

Toast support recommends entering an operation ID of 1 for the first import operation in the spreadsheet and then incrementing by 1 for each additional operation, so that the operation ID of the second import operation is 2, the operation ID of the third import operation is 3, and so on.

For more information, see Understanding the operation ID.

Version ID or operation ID

A valid Toast GUID for the menu item to be updated.

For more information, see Specifying Toast identifiers.

Name

The name of the menu item. Must follow these rules:

POS name

The name of the menu item as displayed on a Toast POS device. Must follow these rules:

Kitchen name

The name of the menu item as displayed on kitchen tickets or on a kitchen display system device. Must follow these rules:

Item description

A description of the menu item. Must follow these rules:

Price

A string representing the menu item's base price. Optional.

Price strings must follow these rules:

Examples of valid price strings:

null
""
".12"
"1"
"10"
"100"
"100.00"
".1"
"100.0"
"100."
"-.1"
"(100.0)"

Examples of invalid price strings:

"$100"
"$a" 
"." 
"€1" 
"10.." 
"..100" 
"10.0." 
"abc" 
"100.0$0" 
"$10a.00"
"$"

PLU

The price look-up (PLU) code for the menu item. Must follow these rules:

SKU

The stock-keeping unit (SKU) code for the menu item. Must follow these rules:

Sales category multiLocation ID

The multilocation ID for the sales category that applies to this menu item.

If you update the sales category ID for a menu item, and the item had previously been set to inherit its sales category ID from a parent menu group, the item is reconfigured so that it no longer inherits its sales category from a parent menu group. The menu item now has its own sales category.

Example of a sales category ID:

500000000032822323

For more information, see Specifying Toast identifiers.

Prep station multiLocation IDs

The multilocation IDs for the prep stations that this menu item should be sent to when it is ordered. If you need to specify a single prep station, you can just provide the ID.

If you need to specify multiple prep stations, separate their multilocation IDs with commas and encapsulate the entire string in double quotes.

Example of a single prep station ID:

500000000032885671

Example of multiple prep stations IDs:

"500000000032885671,500000000094945671"

For more information, see Specifying Toast identifiers.

Tax rate multiLocation IDs

The multilocation IDs for the tax rates that apply to this menu item. If you specify a single tax rate, you can just provide the ID.

If you need to specify multiple tax rates, separate their multilocation IDs with commas and encapsulate the entire string in double quotes.

Example of a single tax rate ID:

500000000139746504

Example of multiple tax rates IDs:

"500000000139746504,500000000959646504"

For more information, see Specifying Toast identifiers.

Guest count

Specifies the guest count associated with the menu item. For example, a small pizza could have a guest count of 1 while a large pizza has a guest count of 2.

You can enter decimal values for Guest count but the Toast platform rounds any decimal values to two places.

Operation

A drop-down menu where you can choose the type of operation to be performed. Values include:

Required for all operations

For CREATE operations, use CREATE

For UPDATE operations, use UPDATE

For ATTACH operations, use ATTACH

Entity type

A drop-down menu where you can choose the type of menu entity. Values include:

For a CREATE operation, choose the type of entity you want to create. For example, to create a menu item, enter MENU_ITEM as the Entity type.

For an UPDATE operation, MENU_ITEM is the only supported entity type.

For an ATTACH operation, choose the type of entity you want to attach. For example, to attach a modifier to a modifier group, enter MODIFIER as the Entity type. (The parent entity type is specified using the Parent entity type column.)

Required for all operations

For CREATE operations for menu items, use MENU_ITEM

For CREATE operations for modifier groups, use MODIFIER_GROUP

For CREATE operations for modifiers, use MODIFIER

For UPDATE operations, use MENU_ITEM

For ATTACH operations for menu items, use MENU_ITEM

For ATTACH operations for modifier groups, use MODIFIER_GROUP

For ATTACH operations for modifiers, use MODIFIER

Name

The name of the menu entity. Must follow these rules:

Required for CREATE operations

Used for UPDATE operations

Empty for ATTACH operations

Version ID or operation ID

An identifier for the menu entity to be attached. The value of this field depends on whether the menu entity you want to attach already exists or is being created in this same import spreadsheet.

For more information, see Specifying Toast identifiers.

Required for ATTACH and UPDATE operations

Empty for CREATE operations

Operation ID

A unique ID for the import operation associated with this row in the import spreadsheet. Must follow these rules:

Toast support recommends entering an operation ID of 1 for the first import operation in the spreadsheet and then incrementing by 1 for each additional operation, so that the operation ID of the second import operation is 2, the operation ID of the third import operation is 3, and so on.

For more information, see Understanding the operation ID.

Required for all operations

POS name

The name of the menu entity as displayed on a Toast POS device. Must follow these rules:

Used for CREATE and UPDATE operations

Empty for ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Kitchen name

The name of the menu entity as displayed on kitchen tickets or on a kitchen display system device. Must follow these rules:

Used for CREATE and UPDATE operations

Empty for ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Item description

Only used for menu items. Description of the menu item. Must follow these rules:

Used for the CREATE operations where Entity type is MENU_ITEM and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Button color

A drop-down menu where you can choose the button color for the menu entity on a Toast POS device. For a diagram that shows the possible button colors, see Button colors.

If you generate your import spreadsheet programmatically, the Button color column can contain either a color's name or its hex value. Color names must be in all capitals. Possible button color names and their corresponding hex values are shown below:

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Pricing strategy or method

A drop-down menu where you can choose the pricing strategy or method for the menu entity being created. Values include:

The value you choose for the Pricing strategy or method column depends on the type of entity you are creating.

For menu items:

For modifier groups:

For modifiers:

Required for CREATE operations

Empty for UPDATE and ATTACH operations

Price

A string representing the menu entity's price. Optional.

Price strings must follow these rules:

Examples of valid price strings:

null
""
".12"
"1"
"10"
"100"
"100.00"
".1"
"100.0"
"100."
"-.1"
"(100.0)"

Examples of invalid price strings:

"$100"
"$a" 
"." 
"€1" 
"10.." 
"..100" 
"10.0." 
"abc" 
"100.0$0" 
"$10a.00"
"$"

Used for:

CREATE operations where Entity type is MENU_ITEM.

CREATE operations where:

CREATE operations where:

UPDATE operations where the menu item's Pricing strategy or method is set to BASE.

Empty for ATTACH operations

Location-specific price target ID

The Toast GUID of the target location group or location that the location-specific price applies to. Used when the row creates a new menu item or modifier and the Pricing strategy or method is set to LOCATION_SPECIFIC. Note that the target for the location-specific price must be the same as or an ancestor of the target assigned to the menu item or modifier itself. The target for the menu item or modifier is defined in the Target ID field.

Must be empty for all other operations.

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER and Pricing strategy is LOCATION_SPECIFIC

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

PLU

The price look-up (PLU) code for the menu item or modifier option. Must follow these rules:

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

SKU

The stock-keeping unit (SKU) code for the menu item or modifier option. Must follow these rules:

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Prep station multiLocation IDs

The multilocation IDs for the prep stations that this menu item or modifier should be sent to when it is ordered. If you need to specify a single prep station, you can just provide the ID.

If you need to specify multiple prep stations, separate their multilocation IDs with commas and encapsulate the entire string in double quotes.

If you don't provide a prep station ID when you create a menu item or modifier, the menu item or modifier inherits the prep station assigned to its parent menu entity.

Example of a single prep station ID:

500000000032885671

Example of multiple prep stations IDs:

"500000000032885671,500000000094945671"

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Tax rate multiLocation IDs

The multilocation IDs for the tax rates that apply to this menu item or modifier. If you specify a single tax rate, you can just provide the ID.

If you need to specify multiple tax rates, separate their multilocation IDs with commas and encapsulate the entire string in double quotes.

If you don't provide a tax rate ID when you create a menu item or modifier, the menu item or modifier inherits the tax rates assigned to its parent menu entity.

Example of a single tax rate ID:

500000000139746504

Example of multiple tax rates IDs:

"500000000139746504,500000000959646504"

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Sales category multiLocation ID

The multilocation ID for the sales category that applies to this menu item or modifier.

If you don't provide a sales category ID when you create a menu item or modifier, the menu item or modifier inherits the sales category assigned to its parent menu entity.

Example of a sales category ID:

500000000032822323

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MENU_ITEM or MODIFIER

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Target ID

The Toast GUID of the target location group or location for the menu entity.

Note that the target must be:

For more information, see Specifying Toast identifiers.

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Owner ID

The Toast GUID of the owner location group or location for the menu entity.

Note that the owner must be:

For more information, see Specifying Toast identifiers.

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Visible to POS

A drop-down menu where you can choose whether the menu entity is visible on Toast POS devices. Values include:

Defaults to TRUE.

If you set either the Visible to Kiosk, Toast Order and Pay field or the Visible to Toast Online Ordering, Toast Takeout App field to TRUE, you must also set this field to TRUE.

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Visible to Kiosk, Toast Order and Pay

A drop-down menu where you can choose whether the menu entity is visible on Toast Kiosk devices or in the Toast Order and Pay app. Values include:

Defaults to TRUE.

Important notes:

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Visible to Toast Online Ordering, Toast Takeout App

A drop-down menu where you can choose whether the menu entity is visible in the Toast Online Ordering website and the Toast Takeout (Local by Toast) app. Values include:

Defaults to TRUE.

Important notes:

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Visible to online ordering partners

A drop-down menu where you can choose whether the menu entity is visible on online ordering sites that integrate with the Toast platform using the orders API. Values include:

Defaults to TRUE.

Used for CREATE operations

Empty for UPDATE and ATTACH operations

Column can be omitted from spreadsheet if empty for all rows

Modifier name

If the menu item the row is specifying will be used as a modifier option's item reference, you can override the item reference's name with a name that is used for the modifier option only. Must follow these rules:

For more information, see Creating modifiers with the advanced template.

Used for CREATE operations where Entity type is MODIFIER and you want to override the item reference name

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Modifier target ID

If the menu item the row is specifying will be used as a modifier option's item reference, you can override the item reference's target location group GUID with one that is used for the modifier option only. For more information, see Creating modifiers with the advanced template.

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MODIFIER and you want to override the item reference target

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Modifier owner ID

If the menu item the row is specifying will be used as a modifier option's item reference, you can override the item reference's owner location group GUID with one that is used for the modifier option only. For more information, see Creating modifiers with the advanced template.

For more information, see Specifying Toast identifiers.

Used for CREATE operations where Entity type is MODIFIER and you want to override the item reference owner

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Default modifier

For rows that create a modifier, this field allows you to specify that the modifier is a default modifier. Set this field to TRUE if the modifier should be a default modifier. If the modifier should not be a default modifier, you can either leave the field blank or set it to FALSE.

Note that, when using the bulk import spreadsheet, you are limited to specifying one modifier as the default modifier in any given modifier group. If you need to specify more than one modifier as a default modifier for a modifier group, you must do so on the modifier group's details page in Toast Web.

Used for CREATE operations where Entity type is MODIFIER and you want the modifier to be a default modifier

Empty for all other operations

Parent entity type

Use this column to attach the entity created or modified in this row to its parent.

A drop-down menu where you can choose the type of menu entity that will be the parent for the entity created in this row of the import file. Values include:

Required for all operations

For specifying a menu group parent, use MENU_GROUP

For specifying a menu item parent, use MENU_ITEM

For specifying a modifier group parent, use MODIFIER_GROUP

Parent version ID or operation ID

Use this column to attach the entity created or modified in this row to its parent.

An identifier that specifies the parent menu entity for the entity being created or attached in this row. The value of this field depends on whether the parent menu entity you want to attach to already exists or is being created in this same import spreadsheet.

For more information, see Specifying Toast identifiers.

Required for all operations

Contains alcohol

Defines whether the menu item contains alcohol or not.

When creating a new menu item, this column can contain the values YES or NO, or it can be empty to indicate that the Contains alcohol configuration is not specified for the menu item.

When updating an existing menu item, this column must contain either YES or NO. It cannot be empty when updating an existing menu item.

For more information, see Menu item and modifier alcohol labeling.

Used for CREATE operations where Entity type is MENU_ITEM and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows

Guest count

Specifies the guest count associated with the menu item. For example, a small pizza could have a guest count of 1 while a large pizza has a guest count of 2.

You can enter decimal values for Guest count but the Toast platform rounds any decimal values to two places.

Used for CREATE operations where Entity type is MENU_ITEM and for UPDATE operations

Empty for all other operations

Column can be omitted from spreadsheet if empty for all rows