Every purchase order you're editing can take a CSV file, or rows pasted straight from a spreadsheet. It reads the same columns and matches rows the same way as Creating a purchase order from a CSV file.
Import into the order
You don't have to start from the list - every purchase order you're editing can take the same file. In the Items header, press the import icon (beside the browse and custom-line icons) to open Import lines from CSV. The same columns and matching rules apply, with a few editor extras:
Paste instead of uploading - copy rows in your spreadsheet, then just paste with the dialog open. No need to save a file first.
Nothing lands until you confirm - the dialog resolves the rows first, and the button tells you exactly what you'll get ("Add 12 lines"), with skipped rows listed by line number.
Re-importing updates, never doubles - rows for items already on the order are set to the file's quantity, so importing a corrected file converges.
Costs come from the file when present, otherwise from your catalog - in the purchase order's currency. Supplier SKUs resolve against the order's supplier, and a Supplier SKU column is saved on each line - matched products included - and remembered for this supplier's next order.
Shipping, fees and discounts come in here too - charge rows from the file (see Creating a purchase order from a CSV file) land in the open order's Cost summary, ready to edit, and pack recipe codes expand into their component lines - the same complete file works on either import.
If we don't recognise a column
Suppliers head their columns however they like, and not every spelling is one we know. When you import into an order you are editing, Stockroom shows you the file's columns before anything is added: each header, what we made of it, and a few real values from underneath it - because a column headed "Ref" could be your SKU, their part number or their own order id, and the cells are the only way to tell.
📸 SCREENSHOT: The Match your columns step of Import lines from CSV, with one unmapped column open and sample values showing underneath
Set What this column holds for anything we could not name, or change one we read wrongly - your answer always beats our guess. Ignore this column is a real answer too, and the right one when a supplier's header collides with ours but means something else. Fill in the rest for me reads the headers and the sample values and proposes the rest, marked Suggested so you can see what was worked out rather than told. Then press Continue and the import runs as usual.
Tick Remember this for the next file like it and your answers come back the next time a file with those columns arrives, so a supplier's order sheet is only ever taught once. It is matched on the set of headers rather than their order, so a supplier moving a column does not start the questions again.
A file we already read cleanly never sees any of this - it still imports in one step.
Good to know
A Destination column works here too: on an order split across stores, each row lands at the store it names.