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