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.