The Order Report is TrueProfit's per-order breakdown, each order's revenue, costs (COGS, shipping, handling, transaction fees), and gross profit. This glossary defines every column with its formula and data source.
Common Q&A
What is the Order Report in TrueProfit?
A per-order report showing each order's revenue, its costs (COGS, shipping, handling, transaction fees), and the resulting gross profit, so you can see the profitability of every individual order.
2. Why are the numbers in my Order Report different from my Dashboard and P&L report?
Because they don't count the same set of orders.
Your Order Report lists every order that syncs from Shopify — including orders that were later refunded or cancelled. Since those extra orders are still in the list, the totals add up higher, and the other metrics look bigger too.
Your Dashboard and P&L report leave refunded and cancelled orders out of the totals, so their numbers are usually lower.
So for the same date range, the Order Report total can be larger than what you see on your Dashboard or P&L report. They're simply not counting the same orders.
Tip: Your Dashboard revenue matches the "Total sales" figure in Shopify. If you want to reconcile your numbers, compare your Dashboard revenue against Shopify's Total sales, not the Order Report total."different from my Dashboard and P&L report
>>> Learn more: Understanding your TrueProfit numbers vs Shopify · P&L Report Metric Glossary
3. How does TrueProfit calculate profit per order?
Gross Profit (per order) = Revenue − (Total COGS + Shipping Costs + Handling Fees + Transaction Fees).
Revenue per order = Gross Sales − Discounts + Taxes Collected + Shipping Charged. (Order-level profit doesn't include ad spend. Ad spend isn't tied to a single order; see net profit on the Dashboard.). See how TrueProfit calculates your Net Profit
4. Where do the numbers come from?
Order, items, and sales data sync from your Shopify orders; COGS, shipping, handling, and transaction-fee costs come from your TrueProfit cost settings (transaction fees are estimated from your payment providers' rates).
>>> Related: Dashboard Metrics Glossary · Product Analytics Metric Glossary
Order ID
Order ID is an unique ID for each order, synced from Shopify.
Helps you:
Identify and track specific orders.
Date
Date is the date when the order was processed and used for filtering and reporting.
Helps you:
Analyze performance over time.
Items
Items are products included in the order, synced from Shopify
Helps you:
See what customers purchased in each order.
Revenue
Revenue is the sales amount from orders
Per order: Revenue = Gross Sales − Discounts + Taxes Collected + Shipping Charged
All orders: Revenue = Sum of revenue from each order
Helps you:
Track top-line sales performance and compare it against costs and profit.
Shipping Costs
Shipping Costs are the costs you pay to deliver orders to customers
Helps you:
Understand how shipping impacts your profit.
Total COGS
Total COGS is the total cost of goods sold for orders.
Helps you:
See how product costs affect your margins.
Transaction Fees
Transaction Fees are the fees charged by payment providers (such as PayPal or Stripe) and Shopify fees for third-party payments for each order.
Helps you:
Understand how gateway and Shopify third-party fees affect profit.
>> Learn more: Set up Transaction Fees
Handling Fees
Handling Fees are the costs to prepare orders for shipping, including boxing and packaging.
Helps you:
Track additional fulfillment costs beyond shipping.
Gross Profit
Gross Profit is profit remaining after subtracting shipping costs, COGS, transaction fees, and handling fees from revenue.
Gross Profit = Revenue - (Transaction Fees + Total COGS + Handling Fees + Shipping Costs)
Helps you:
See how much profit each order generates before ads or overhead.
Gross Profit Margin (%)
Gross Profit Margin is the percentage of your revenue that remains after subtracting product costs and direct order costs.
Gross Profit Margin (%) = (Gross Profit / Revenue) × 100
Helps you:
Evaluate margin efficiency and compare performance across orders or time.