Every sales order in Settle has an Order profitability section that shows what each item cost you and the margin you made on it. That cost is your cost of goods sold (COGS). Settle works it out with weighted average cost (WAC).
See the cost and margin of a sales order
In the left menu, under Sales, click Sales Orders.
Open a sales order.
Scroll to Order profitability. Each row shows an item, its WAC per unit, Margin (%), Margin ($), Qty and Total margin.
The order's Total margin and Margin (%) are also at the top of the order's General tab.
How weighted average cost works
WAC is the average cost of one unit across the purchase orders and work orders you issued in the last 365 days. Draft, canceled and rejected orders don't count. Each unit's cost includes its share of the order's additional expenses, such as freight and duties. See Managing landed costs.
Jan 1: you order 100 units at $1.00.
Jan 5: you order 100 units at $2.00.
Jan 10: you sell 100 units.
The WAC is $1.50, so the 100 units that you sell cost $150.00.
Settle recalculates WAC every day at 3:00 PM Pacific Time. A sales order always shows each item's latest WAC, so the cost on an older sales order can change after you add new purchase orders. The Product cost report lists your WAC by item and date.
If you connect A2X or turn on Sync landed costs to Shopify, Settle sends WAC to those apps.
If you see "There is not enough data to calculate your costs"
Settle shows this message in Order profitability when it can't find a cost for any item on the sales order. An item gets its cost from its purchase orders and work orders or, when there are none, from its baseline cost. To fix it, do one of these for each item:
Add the item to a purchase order or work order. It counts after the next daily recalculation at 3:00 PM Pacific Time.
Add a baseline cost: go to Catalog, open the item, click the Purchase tab, and in Baseline costs click Add baseline costs. See Adding baseline costs to your catalog items.
An item without a Unit Price on the sales order is also left out of Order profitability, so check that every line has one.

