If you were tracking orders in a spreadsheet before Baiord, you do not have to retype any of it. Orders → Import costs from spreadsheet matches your sheet against your eBay order numbers and fills in the buying prices.
What the file needs
CSV only. In Google Sheets, File → Download → Comma-separated values. In Excel, File → Save As → CSV.
| Column | Needed? | Example |
|---|---|---|
| eBay order number | Required | 12-34567-89012 |
| Buying price | Required | 4.50 |
| Supplier order number | Optional | INV-123-456 |
| Anything else | Ignored | payout, profit, notes… |
Column names do not have to match. Baiord guesses from your header row and then shows you three dropdowns — eBay order number, Buying price, Supplier order no. — prefilled and correctable. A sheet with no header row works too; the columns are then just numbered.
The price is read as the order total, not the per-unit price. Baiord divides it by the order's quantity. If your sheet holds per-unit prices and your orders are mostly single units, these are the same number — but on multi-unit orders they are not, so check before you apply.
Your payout and profit columns are deliberately ignored. Those come from your real eBay data, and a figure you typed months ago is not evidence.
What the statuses mean
| Status | What it means |
|---|---|
| Ready | Matched, single product, no price yet. This one will be applied. |
| Already priced | Matched, but already has a price. Applied only if you tick the overwrite box. |
| Multi-item — enter by hand | The order has several products, so a single total cannot be split between them safely. |
| Order not found | No order with that number in this workspace. Usually it is outside your start date. |
| Cancelled — no buying price | Skipped, and nothing to fix. |
| Price unreadable | The cell is not money, is zero or below, or is implausibly large. Nearly always a mis-mapped column. |
Things it handles for you
- Currency symbols, spaces and thousands separators are stripped. A European decimal comma works. Brackets around a figure read as negative.
- Both old and new eBay order number formats are matched.
- Duplicate rows for the same order: the last one wins — the bottom of a spreadsheet is where the correction usually lives.
- An unreadable cell becomes a visible error, never a silent zero.
Nothing happens until you apply
The preview shows every row and its status with counts per status. Overwriting existing prices is off unless you tick it. The button then reads Apply {n} prices, and only then is anything written. Imported prices show as "imported" in each order's cost history.
Limits: 5 MB of CSV, up to 20,000 data rows per upload. If your file fails outright the toast reads "Import failed — nothing was changed", which is literal.