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