To Buy & Bought

Purchase records, unit tracking, totals and goals.

Questions about To Buy & Bought

Why are my orders yellow?

Some units are not in a final status yet: Listed, Shipped to FBA, Damaged or Canceled. Move them and the row turns green.

The Create order button is missing.

ASIN, quantity and cost are all required. Fill those in and it appears.

Should I delete canceled orders?

Mark them Canceled instead. You keep a record of which suppliers cancel, and canceled amounts are already left out of net spend.

Where is cashback counted?

Totals shows cashback as its own number. It is not subtracted from spend.

How do I see orders that never arrived?

Set the Status filter to Stale >30d.

Why wasn't a row imported?

Open the Sheets gear → Recent runs, or Settings → Import/Export. Open the import run to see rows that were not imported and their reasons. Download them, fix the cells, and import that file.

Why did a purchase I deleted come back?

It was still in your sheet. A row without an ID, or with the ID of a deleted purchase, imports as new. Delete the row in the sheet too.

Is it safe to sort my sheet?

Yes. Rows are matched by ASIN.so ID, not by their position.

I typed into my Mirror and it changed back.

A Mirror always matches ASIN.so. Make the change in ASIN.so instead. Your own extra columns are kept when the Mirror has the ASIN.so ID column.

How do I cancel units with an import?

Put the number of cancelled units in the Cancelled column. Lowering the quantity doesn't cancel.

Why are rows skipped as "already in ASIN.so"?

A row without an ID that matches a purchase on ASIN, date, supplier and cost is a duplicate. Order # is checked only when the row has one. If your file has two identical purchases and ASIN.so has one, one is added.