Skip to main content

What it says

One product’s row

Sam bought twenty Shredder figures, in two purchase orders. Did that money come back yet? Paste its ASIN in the search box. The table narrows to one row. Each row is one product, with every purchase order added together. Hover over PO to see both purchase orders. Ten on July twenty-seventh, and ten on September twenty-fifth. Sent is twenty: the units Sam’s shipments told Amazon were coming. Invested is what Sam paid for all twenty: three hundred dollars. Recovered is what Amazon paid Sam for them, after its fees: two hundred six eighty. P&L is what Sam made or lost so far: minus ninety-three twenty. Red is normal while units are still unsold. ROI is sixty-two percent. Hover over it to see the math. It only counts the eight units that sold. They cost Sam a hundred twenty-eight dollars. They made seventy-eight eighty on top, after Amazon’s fees. So each dollar made sixty-two cents. So what sold made money. P&L is red because twelve are still unsold.

The break-even line

The bar is the road to break-even. It fills as units sell: eight of twenty so far. The thin line is the break-even line. Hover over it. Sam gets the money back at unit twelve. Click the arrow to open the row. The top line says it plainly: sell four more at forty dollars to break even. Hover over its question mark to see why. Each sale brings back twenty-eight dollars, after Amazon’s fees. Four sales cover the ninety-three twenty still out. Under the bar: eight sold, and break-even at unit twelve of twenty. Still out is minus ninety-three twenty. It’s the same money as P&L in the row above. Twelve are left to sell. Every sale past unit twelve is profit.

Past the line

Now a product that went past the line, the Uno card game. Paste its ASIN. Its bar went past the line. The part past it is green. Open its row. Hover over its bar. Sam’s money came back at unit seven. Every sale after that was profit. So Still out became Profit: eighteen fifty-four.

Batches

Sometimes Sam sells out, then buys again. Paste the New Ray truck’s ASIN. Open its row. This product has batches. Sam sold out of the first one, then bought again. Batch 1 was bought in June. All five sold, and it closed in August. It broke even at unit three, and made seventy-five fifty. Batch 2 is September’s purchase order. Three of its eight sold so far. Click it to see Batch 2 on its own. Batch 2 needs one more sale, at forty-six dollars, to break even. It’s still out nine twenty. Batch 1’s profit doesn’t cover it. Batches stay apart. An old batch’s profit never hides a new one that hasn’t paid back. All adds every batch together. Click it to go back.

What the dates do

Back to the Shredder. Paste its ASIN again. Open its row. Which purchase order sells first? Hover over the question mark after left to sell. The oldest sells first. Two are left from July twenty-seventh, at sixteen dollars each. Then September’s, at fourteen. Now the dates at the top. Click ninety days. Now only purchase orders bought in the last ninety days count. For the Shredder, that’s September’s ten, at a hundred forty dollars. None of them sold yet. The July ones sell first. Recovered is minus eight twenty-four. Fees for shipping to Amazon and storage come off, even before a sale. Click All time to count every purchase order again. That’s one product, read from start to finish. Next: investigate a product, every unit and every event.