You do not need a new system to list stock on Sparehawk. A CSV or XLSX export from whatever you already run is enough, and the import maps your column names to ours rather than the other way round.
The minimum
Four columns get a line published:
| Field | Example | Notes |
|---|---|---|
| Part number | 6ES7315-2EH14-0AB0 |
As printed on the part. Spaces and hyphens do not matter. |
| Brand | Siemens |
Omit it only if your whole file is one brand. |
| Condition | New surplus |
Your own wording is fine; you map it once. |
| Quantity | 3 |
Integer. Use the hidden-quantity option rather than a fake number. |
Everything else is optional and every optional field raises the number of requests a line receives.
The fields that make a line sell
Price and currency. Lines with a visible price receive substantially more requests than lines without. If you cannot publish a price for commercial reasons, you can hide it per line — but publish where you can, because a buyer comparing six offers clicks the ones with numbers.
Lead time in days. The number of working days from order to dispatch. Leave it blank for in-stock items rather than entering 0; the import understands "in stock" from the quantity.
Ships from (ISO-2 country). Only when it differs from your company's country — a remote warehouse. Buyers filter on this heavily.
Warranty months. An integer. A line with 12 next to a refurbished part sells against a line without.
Minimum order quantity. Saves a request you would have declined.
Notes. One short sentence: what was tested, what is included, what revision. Free text, and it appears on the offer.
Datasheet. A URL or an uploaded PDF per line.
Condition mapping
Our four grades are new_oem, new_surplus, refurbished and used. Your file will say something else — "N", "NEU", "Gebraucht", "REF", "A-Ware". During import you map your words to ours once, and the mapping is remembered for every later upload of the same shape.
Be accurate rather than generous. A line described as new surplus that arrives visibly used generates a dispute, a poor review and a refund, and all three cost more than the price difference.
File shape
- CSV or XLSX, first row is the header.
- One row per (part, condition). If you hold the same part as both new surplus and refurbished, that is two rows, not one row with two quantities.
- UTF-8 for CSV. Excel's default Latin-1 export mangles German and Polish company names; save as "CSV UTF-8".
- No merged cells, no totals row, no colour-coded meaning. Colour does not survive an export.
- Decimal separator: either
.or,is accepted, consistently within a file. - Size: files up to tens of thousands of rows import comfortably. Split anything larger by brand.
What happens after upload
- Parse. We read the file and show you the first rows as we understood them.
- Map. You confirm which of your columns is which of our fields, and how your condition words translate. This is the step that takes five minutes the first time and zero minutes afterwards.
- Validate. We report rows that cannot be published and why: no quantity, an unrecognisable part number, a condition that did not map. Nothing is published until you have seen this.
- Publish. Matched lines go live against catalogue parts. Lines whose part number we do not yet have are queued for identification rather than discarded — most resolve within a day or two.
Keeping it current
Freshness is visible to buyers: every offer shows the date its data was last published, and a stale offer is marked as such. Suppliers who re-publish weekly get materially more requests than those who upload once a quarter, for the simple reason that a buyer with a line down will not gamble on a three-month-old stock figure.
Three ways to stay current, in ascending order of effort and descending order of ongoing work: upload the same file on a weekly reminder; put the file somewhere we can fetch on a schedule; or use the supplier API to push changes as they happen. All three produce the same result on the page — the difference is only how much of your week it takes.
Common first-upload problems
- Part numbers with the brand prefixed into the same cell. Split them; the import can also do it if the pattern is consistent.
- A quantity column containing text like "auf Anfrage". Use the hidden-quantity option instead.
- Prices including VAT in one file and excluding it in another. State which; buyers compare on net.
- Duplicate rows for the same part and condition. The last one wins, which is rarely what you meant.