Order item reports are documents you can go through in your own time. They are automatically generated and contain more details than we can show in the various statistics sections. Particularly, we have two types of statistics reports: Itemized report – prepared for every ordered item, and a high-level order items summary that is prepared for every product present in your store during the selected statistics period.
What you should know:
- Order items summary is a high-level report based on the items sold from your store during the selected statistics period.
- Order items details report has fine details about the items ordered during a certain statistics period.
On This Page
- View Order Items Summary
- Download Order Items Reports
- Difference Between the Order Items Summary and Itemized Order Items Report
View Order Items Summary
Under GonnaOrder’s statistics section, you can view the order items summary. As the name suggests, it is a high-level summary of store sales generated in real-time. Therefore, you are free to change the dates for which you want to see the summary and sort the items based on the quantity sold or the total revenue generated from item sales.
The summary serves as a quick visual guide to store sales over a given period. It complements the downloadable reports. You may click on any store item from the summary to edit the details.
Download Order Items Reports
The order items tab of the statistics section provides options to download a summary of all orders in your store. You can then use the summary to learn what products have been performing well and those others that performed dismally during any given period. You also can download an itemized list of all items you sold during a certain period.
The difference between the summary and the itemized list is that a summary is generally an overview of how different products performed, while an itemized list is more detailed and links items to the associated order token (order number). The itemized order details list also contains the order date and status, among other details.
If you would like to request more statistics about your store, please contact us through the contact form. After receiving your request, we will provide the desired statistics.
Difference Between the Order Items Summary and Itemized Order Items Report
You can download the order items summary, and the itemized order items report from your store, as illustrated in the previous sections. But what is the difference between these two reports?
The order items summary provides an overview of what has been happening in your store over time. It shows the total sales for all products listed in your store during a particular period. The summary Excel file has a total of five columns.
- Product ID: This field has numeric values that identify your products in the store. These numbers are automatically assigned when you create an item through the GonnaOrder interface or by adding a catalog via Excel or from a photo.
- Product Name:The product name field will show the names of products you have in your store. Notice that category and option group names will not appear anywhere in the summary. Further, note that order numbers and dates when particular items were sold will also not appear on the list.
- Total Quantity: This field shows the total number of items of a particular product that were sold within the reference period. The summary does not break down how the total quantity was ordered nor provide any order information.
- Total Discount Price: This refers to the total amount of money paid to your store after deducting any discounts you may have offered your customers. It is shown for every item listed in your store.
- Total Non-Discount Price: The numeric values in this field represent the total value of all the items of a particular product sold from your store without accounting for any discounts given to customers. It, therefore, represents the total amount of money you could have received after selling the Total Quantity of items for the marked price.
The itemized order items report, on the other hand, is more detailed. It is a product-level report that shows fine details about orders placed in your store. Every entry in this report represents a single product instance listed in your store during the reference period. The report file has fifteen columns, as explained below.
- Item ID: Every item added to an order is assigned a unique Item Id in your store. That is to say, if a customer chooses to have two items (quantity) of the same product in their order, then each of the two items would have a unique identifier.
- Parent ID: Every item added to an order is assigned a unique parent Id. Normally, the parent Id is identical to the Item Id. However, when there are option groups or price variants in the catalog, the item Id may differ. For instance, for a main course, the parent Id and item Id are the same. But if the main course includes sides or extras, the parent Id for sides or extras will be set as the main course ID.
- Order Token: The order token is similar to the order number, and it links every item purchased from your store to the corresponding order. This column can have repeated values since an order can have several items.
- Product ID: This field carries a unique number designed to identify store products. The product Id is different from Item ID in that the latter is associated with individual items ordered from your store, while the former is associated with a specific product type.
- Order Item Comment: This field will show any comment left by the customer while they were placing the order. It might as well be empty.
- Product Name: The product name carries the name of products to which items ordered from your store belong. The product names appearing in the order items summary report we discussed earlier will be the same as in the order details report, but now repeated times.
- Category Name: This is the category/group to which the product in question belongs. If an item Coke is listed under the soft drinks category, then this field’s value will be Soft drinks and so forth.
- Product Price: The marked price of a single item of a product.
- Quantity: Quantity refers to the count of the items that were requested in the same order. For instance, the quantity value will be 2 if a customer orders two Coke bottles.
- Discount Type: GonnaOrder allows you to discount products for your customers. Discount type can either be monetary or percentile. Items without discounts will have this field empty.
- Discount Value: This shows the value of the discount set for a particular product with respect to the discount type field. See help on how to set up prices and discounts.
- Total Discount Price: The actual value the customer paid for the item. It can also be described as the marked price of an item minus the product discount.
- Total Non-Discount Price: This represents the value a customer should have paid if the store didn’t have discounts for the product items in the same order. It is essentially the marked price for the product multiplied by the number of items ordered.
- Order Status: The value here can be Submitted, Received, or Closed. See help on order status & changes to learn more.
- Order Date: This shows the date when the item was ordered from the store.
- Wish Date: Represents the day that the customer chose to receive their order containing this item. Not all orders have dates; therefore, it is okay if some rows have this field empty.
- Location: The location field of the itemized order report refers to the table to which the order was served. This is the same table number that appears on the order overview page. As you might be guessing, not all orders will be associated with tables, which is okay.
- Location comment: This is a comment related to the table to which the order to which the item is associated was served.
- Object: The object field identifies the entity type that can be associated with the listed product. An entity type can be a category, a product, an option, or a price variant.
- Store: The Store field shows the unique store Id from where the order is placed.
- Order ID: The Order ID field shows the unique order Id generated for each order placed