Skip to main content

In short

Each order is a row: its date, how many, its stage, the product, what it cost, and what it should make. Say you buy 20 toy trucks at $8.00 each. Qty is 20, Cost is $160.00 with “$8.00/unit” under it, and Actions shows Edit.
One grouped row: 2 orders, Oct 30, 2026, Qty 20, 20/20 in, all in, Value Worsted Yarn B0B4HVFJ27, Cost $20.00 and $1.00/unit, Expected Profit $20.00 and $1.00/unit, Current Profit $5.84 and $0.29/unit.

Value worsted yarn: two orders of 10, grouped into one row. Notice it says 2 orders, Qty 20, and Cost $20.00.

The profit columns are on Cost and profit.

More details

After the ASIN sit small badges. CR is Capital Recovery: point at it to see how the product is doing there, with its Invested, Recovered, and P&L. Click it to open the product on Capital Recovery, in a new tab. Sales opens the product on Sales, also in a new tab. A plan without Capital Recovery or Sales doesn’t show that badge.
Click Group by ASIN to get one row per product. Say you later buy 10 more trucks at $9.00.The group row shows 2 orders and Qty 30. Cost is $250.00, and under it is “avg $8.33”. Point at it, and the hover says Average landed cost per unit over these orders, meaning product plus shipping plus tax. Just a summary. Each sale uses its own batch’s cost, oldest first.The big Expected Profit adds the orders up. Units with no cost are left out of the cost line.A cancelled order the store refunded in full stays out of the group. Any other cancelled order stays in it, with its cost, at the stage it was at.A combo saved as one order puts the order’s cashback on the first product. The sheet now saves one row per product, and shares cashback by each line’s cost. Shipping and tax stay on the first row as notes.
Click … at the end of an order’s row. From top to bottom:
  • Write off: opens the write-off box for this product. On an older combo saved as one order, there is one per product, like “Write off B0EXAMPLE1”. A cancelled order has none.
  • Update received count: on a Partially Received, Partially Sent to FBA, Sent to FBA, or Selling FBM order. It fixes how many came in, and the status stays.
  • Order details: change the order, then Save Changes.
  • View whole order: on a combo order. It shows every product from that checkout.
  • Cancel this order: on a Never arrived order where nothing came in.
  • Uncancel: on a cancelled order.
  • Delete
A Group by ASIN row with more than one order has one choice, like “Show its 2 orders”. When they are open, it says Hide its orders.
Delete asks Delete this purchase? The order and its lines go away. Click Delete purchase to go on, or Go back.Say it’s the only purchase for its product. Then that product’s Amazon sales stop counting in Capital Recovery, until you add a purchase for it. Nothing from Amazon is lost.If Amazon already has sales on the purchase, you can’t delete it. The box says This purchase can’t be deleted. Under Merge into, pick another purchase of this product, then click Merge. Its units, cost and sales move there.