Skip to main content

In short

The Products tab has one row per product. A row adds up every purchase order of that product. Say you want to find the Uno card game. Type “Uno” in Search titles, ASINs, orders… Its row shows how far it has sold, what you put in, and what came back.
The Uno row: Road to break-even 10/12 sold, Sent 12, Invested $24.00, Recovered $42.54, P&L +$18.54, ROI 113%.

Uno card game: its row on Advanced. Notice 10/12 sold on the bar, Invested $24.00, Recovered $42.54, P&L +$18.54 and ROI 113%.

To narrow the list, use the chips. Watch it: Filter Capital Recovery.

More details

A match can be the product title, the ASIN, the order number, or an extra order number on that purchase. A store name matches too. With no store name, the website on the purchase link matches.
Default starts with Product, Sold, Invested, and Recovered. Advanced starts with Road to break-even, Sent to Amazon, Invested, Recovered, P&L, and ROI. Sold and Road to break-even are the same bar. Each column’s math is on One product, every number.Amazon Received, Amazon holds, and Profit margin % stay hidden until you show them. On Advanced, the heads read short: Sent, Received, Holds, and Margin %. Point at a head for its full name.To change the columns, click the button at the end of the header row: ⋯ on Default, ☰ on Advanced. Tick a column to show it. Drag it to move it. Type in its name box to rename it. Click Save. Restore defaults puts the first set back.In Advanced, click a column name to sort by it. Click again to flip the order, and a third time to stop sorting. Pick how many rows a page shows at the bottom, then use Next › and ‹ Prev.
  • PO opens the product on Purchases. Sales opens it on the Sales page. Both open in a new tab.
  • Closed (Advanced) means the product has no units left to sell.
  • Price (Advanced) means a Price & Buy Box alert is open for it. A filled tag means you lost the Buy Box. An outlined one means your price has been the highest for hours.
  • A line like “4 sent back to you” (Advanced) counts units Amazon sent back to you.
The bar’s words can add what happened to units that didn’t sell, like “1 lost or damaged” or “2 found at Amazon, no cost”. Found at Amazon means Amazon had units no purchase names, so they have no cost yet. When every unit is gone, a striped part at the right of the bar is the units lost or damaged, not sales.A link from Reconcile opens the list with two more columns. Reconcile has a colored dot for each problem. Point at a dot to read it, like “Missing from shipment”. Actions has Write off, for units you have given up on, or See details, to open the product’s claims.
  • With no purchases yet, it says No recovery data.
  • If a chip or search finds nothing, it says “No batches match this filter. Clear it to see every product.”
  • If your dates hold no purchase orders, it says “Nothing was bought on these days. Pick other days or All time.”
Open Filters on Advanced. The button can show how many filters are on.The Bought box has All time, Last 3 days, Last 30 days, Last 90 days, and This year. Its start and end dates sit beside them. One date alone stays All time until you set both ends. It sets the same range as the date buttons at the top.The month bars sit in this box. The first click says “Click a bar to start a custom range.” The next says “Now click the end month.” Point at a month, and it grows. Its expenses show under the bars. The key’s ? says what each color means.
The Filters panel: Bought with All time, Last 3 days, Last 30 days, Last 90 days, This year, start and end dates, month bars from Dec to Nov and Click a bar to start a custom range. Then Table with Compact, Full, Sticky columns, Comfortable and Condensed.

The demo store: Filters open. Notice the Bought box with its month bars, and the Table box beside it.

The Table box is on Advanced.
  • Compact is the starting tile.
  • Full puts Sent to Amazon and Amazon Received on the table.
  • Sticky columns keeps the first two columns in place while you scroll sideways. The header row also stays put while you scroll down.
  • Comfortable is the starting choice. Condensed puts the rows closer together, with the same text size. The choice is for every table at once, and it’s saved with your login.