This guide will be removed on April 29, 2022. Please use our new, easier-to-use Toast technical documentation site. All updated content is on the new site.

All items data export

The all items data export includes information about all of the items in the menu for your restaurant. The file name of the all items data export is AllItemsReport.csv.

The following table shows details on what the all items data export contains.

Field

Description

Data Type

Master ID

Item Master ID

Long

Item ID

Item ID

Long

Parent ID

Parent Item ID

Integer

Menu Name

Menu Name

String

Menu Group

Menu Group Name

String

Subgroup

Menu Subgroup Name

String

Menu Item

Menu Item Name

String

Avg Price

Average Net Price of item

Number (5 decimals)

Item Qty (incl voids)

Item Quantity including voids

Number (5 decimals)

% of Ttl Qty (incl voids)

Percent of Total Quantity including voids

Number (5 decimals)

Gross Amount (incl voids)

Gross amount of Item sold including voids

Number (2 digits)

% of Ttl Amt (incl voids)

Percent of Total Gross Amount including voids

Number (5 decimals)

Item Qty

Item Quantity

Number (5 decimals)

Gross Amount

Gross Amount excluding voids

Number (5 decimals)

Void Qty

Void quantity of Item

Number (5 decimals)

Void Amount

Void Amount Value of Item

Currency (2 digits)

Discount Amount

Discount Value of Item

Currency (2 digits)

Net Amount

Net Amount of Item (Gross less discount)

Currency (2 digits)

# Orders

Number of Orders Item appears upon

Integer

% of Ttl # Orders

Orders as a percent of Menu Group total orders

Number (5 decimals)

% Qty (Group)

Items as a percent of Menu Group total items

Number (5 decimals)

% Qty (Menu)

Items as a percent of Menu total items

Number (5 decimals)

% Qty (All)

Items as a percent of All total items

Number (5 decimals)

% Net Amt (Group)

Net amount as a percent of Total Menu Group Net Amount

Number (5 decimals)

% Net Amt (Menu)

Net amount as a percent of Total Menu Net Amount

Number (5 decimals)

% Net Amt (All)

Net amount as a percent of Total Net Amount

Number (5 decimals)