Skip to main content

Orders

Understand profit, attribution, and actions for every order. Open any order for its full P&L waterfall and how it was acquired.

Written by Amar Sujith

The Orders page lets you understand the profit, attribution, and story of any single order in under ten seconds. Where the Profit & Loss page aggregates, Orders lets you open one order and see exactly how it made or lost money, and which campaign brought it in.

[Screenshot placeholder] The Orders table with columns for order name, date, sales channel, and order economics, plus the search box and Filters button

The order table

Every order is listed with its name, date, sales channel, and economics. Use the search box to find an order by ID, product name, or SKU, set rows per page, and page through results. You can Export the table to CSV.

Filtering to the orders that matter

Click Filters to build a precise view. Each filter is a "Where [field] [operator] [value]" row, and you can stack several.

[Screenshot placeholder] The "Filter your orders" modal open, showing the field dropdown with Order Name, Order Tag, Discount Code, COGS Source, Shipping Cost Source, Payment Status, Payment Gateway, Fulfillment Status, Acquisition Type, Marketing Source

Available fields include Order Name, Order Tag, Discount Code, COGS Source, Shipping Cost Source, Payment Status, Payment Gateway, Fulfillment Status, Acquisition Type, and Marketing Source. Add a filter, enter values to apply, and use Reset filter to clear. Filters answer questions like "which orders used a specific discount code" or "which orders fell back to a country-level shipping cost."

The order drawer

Click any order to open its drawer. At the top, status badges tell you whether the order is Profitable, and its Shopify state such as Pending or Unfulfilled. Below that: a green Net Profit figure with Total Sales, Net Sales, Total Costs, and Net Margin; the Order Items with SKU, quantity, COGS and its source, and shipping; the Financial Breakdown; and the Attributions.

[Screenshot placeholder] An open order drawer, e.g. #1067, showing the green Net Profit block and the Order Items table

The financial breakdown, checkpoint by checkpoint

This is the four-checkpoint waterfall, the same line-by-line math your accountant would do. Costs are shown in a cost color so subtractions are obvious.

Checkpoint

The math

Result

1

Gross sales, minus discount, plus original shipping charges, plus taxes collected

Order total

2

Minus refund to customer

Total sales (reconciles to Shopify)

3

Minus taxes, minus shipping charges

Net sales

4

Minus COGS, shipping cost, payment fees, fulfillment

Gross profit, then minus Marketing / CAC to reach Net profit

[Screenshot placeholder] The Financial Breakdown section of the drawer, from Gross sales down to Net profit

Marketing / CAC sits below Gross profit and is marked as attributed acquisition cost that is sunk, because ad spend does not come back if the order is refunded.

Attributions

The Attributions block shows how the order was acquired: the acquisition type (for example Paid), the source (for example Meta), and the campaign. New-customer orders carry a CAC; returning customers carry none. See Attribution and acquisition cost (CAC).

[Screenshot placeholder] The Attributions block showing Acquisition type, Source, and Campaign

Common questions

Why does a returning customer's order show no CAC? You already paid to acquire that customer, so charging it again would double-count.

Why is this order less profitable than its cart value suggests? Open the waterfall. One checkpoint, often shipping or discount, is where the margin went.

What do the COGS Source and Shipping Cost Source fields mean? They show which of your configured cost sources Shopshot used for that order. You can filter the table by either to audit coverage.

An order shows Pending or Unfulfilled. Does that change its profit? The badges reflect the Shopify state. Profit is calculated from the order's real economics regardless of fulfillment status.

Next step

Filtering is where Orders becomes a workflow. Learn the highest-value filters, like isolating discount-code orders or orders that fell through the shipping waterfall. → Global Filters recipes

Related

Did this answer your question?