Shopify Order Items Report

Why Order Items Report is Important

The summary shows the breakdown of sales and revenue in terms of particular items. The default output displays the product name and its variant.

It is a useful way to look at sales in addition to the direct Orders Detail summary.

A store manager can add columns such as the number of orders, net quantity, gross sales, discounts, refunds, taxes, and net sales if necessary. The default configuration of this report offers general data on item sales.

The information is offered by displaying such columns as the total quantity sold and the total amount of revenue.

If necessary, a store manager can add columns such as the number of orders, net quantity, gross sales, discounts, refunds, taxes, net sales.

By using filters, the data can be more representative of the store manager’s needs. For example, you can sort the output by the number of orders. Such information can be useful for inventory planning and marketing purposes.

What Questions Summary on Order Items Can Answer

This type of summary groups every item sold in a store into a single output table. Along with the product name and product variant name, it presents a store manager with the shopper’s name, purchased quantity, and total amount. Use it to get a detailed breakdown of sold items.

The data displayed in this document can be used to answer such questions as:

• What product variants have the most/least sales over the specified time period?
• What are the top-selling products in your store? Get information on the worst-selling items within the specified period.
• What customers purchase specific products with the highest total amount?
• What products are most often requested for return?
• How much refund is made for particular products?
• What is the gross profit for particular product variants?
• What are the COGS per product?
• How to get a gross margin in percent per product variant?

Expand this list of answers you may get on your sales by using additional data columns and data filters.

Key Sales Indicators in a Report

Get the sales data for each catalog product using the Advanced Reports app. Utilize it to be informed on key sales metrics of the product variants. Expand this summary with additional columns to get a detailed view.

For example, you can see each item's available inventory and sales velocity to avoid the out-of-stock situation. Additionally, get info on the date of the last order.

Track the number of orders, gross profit and margin, total amount, returns, and refunds within the specified time range. When configured by default for each product, this summary output displays such data as:

• Order ID number
• Order processing date
• Name of the customer who made a purchase
• Purchased product and product variant name
• Sales data on quantity and amount

Use these columns to glance at the current financial and fulfillment statuses for each order within the selected dates and compare them with other periods.

Reports Similar to Order Items

The sales data can be tracked from other scopes to bring the clearest representation of the financial and inventory flows in the store.

Store managers are not limited by the app’s default configuration; they can modify the summary more than by the date. The executive staff can generate the summary using data factors they consider most relevant for a particular moment. The app will pull from the store database all the required data to present it in a way that is easy to understand.

In conjunction with the order items, a store manager can often use such summaries as:

• Orders Detail. Orders detail is one of the most frequently used reports to get a picture of what is going on with orders in a store.
• Product orders and returns. Simplifies highlighting of best-selling products and products with the highest return rate.
• Orders with Amount > 1000. Contains orders with an amount over 1000 in the store currency. The report can display output for any other amount.
• Fulfillment over time. It makes it easy to track orders by their fulfilled, shipped, and delivered status over a specific time range.
• Paid Orders. Contains orders with paid status for a certain period.

Key Columns for Order Items

Typically, this summary consists of such columns as:

• ORDERS Name
• ORDERS Processed At
• CUSTOMERS Name
• ORDER ITEMS Product Name
• ORDER ITEMS Variant Name
• ORDER ITEMS Total Quantity
• ORDER ITEMS Total Amount

A store manager has full control over the summary they generate. They are totally free to exclude any existing columns or add more. Simply choose available columns from the list.

Variations of Order Items Report

Using filters and sorting options, you can get answers to several specific questions regarding orders. Here are some examples of the report variations.

How to See the Total Gross Profit for Orders

You can easily know the gross profit each ordered item has brought. This value depicts a sum of money made after subtracting the sales costs.

The value for ORDERS Total Gross Profit column is calculated through the Net amount and COGS columns.

[ORDERS Total Gross Profit] = [ORDERS Net amount] – [ORDERS COGS]

[ORDERS Shopify Payout] = [ORDERS Net amount] - [ORDERS Shopify Fees] 

[ORDER ITEMS Total Cost] = [ORDER ITEMS Quantity] × [INVENTORY ITEMS Cost] 

[ORDER ITEMS Total Shipping Price] = [ORDERS Shipping Price] ÷ [ORDER FACTS Quantity] × [ORDER ITEMS Quantity]

[ORDERS Total Sales] = [ORDERS Net Sales] + [ORDERS Shipping] + [ORDERS Tax]

[ORDERS Net Sales] = [ORDERS Gross Amount] - [ORDERS Discounts] - [REFUNDS Returns]

[ORDERS Shipping] = [ORDERS Shipping amount] - [ORDER ADJUSTMENTS Total Shipping Amount]

[ORDERS Tax] = [ORDERS Taxes] – [REFUND ITEMS Total Tax Amount]