If your supplier sends an order sheet, or you build orders in a spreadsheet, you can create a purchase order straight from a CSV file - no retyping. Stockroom matches each row to your Shopify catalog and builds a draft purchase order, ready to review and send.
Import a CSV
Open the Purchase orders page and click Import CSV.
Choose the Supplier the order is for - the whole file imports into one purchase order for that supplier.
Upload your CSV file (or drag it in).
If every row imports cleanly, you land straight on the new draft. If any rows were skipped or any columns ignored, the dialog shows a summary first - review it, then click View purchase order to open the draft.
What the file needs
Two columns are enough:
An item identifier - a SKU, barcode, supplier SKU, or Shopify variant ID column (any one of them works).
Quantity - how many units to order.
Optional columns: Unit cost, Discount %, and Product / Variant names (used to title rows that don't match your catalog). Header spellings are flexible - "qty", "cost", "upc", and similar variations are all recognized - and Download a sample CSV in the dialog gives you a starting file.
Purchase order files exported from Stockroom re-import as-is: export a purchase order's lines, adjust quantities in your spreadsheet, and import the result as a new order.
How rows match your products
Each row is looked up in your Shopify catalog - by variant ID, then SKU, then barcode, then supplier SKU (the vendor product codes saved on your products; codes assigned to the chosen supplier take priority).
Matched rows become normal product lines. If the file has no cost for a row, the product's cost from your catalog is used - the same default as picking the product in the editor.
Unmatched rows import as custom lines, so items you don't stock in Shopify still make it onto the purchase order. The product name column (or the code itself) becomes the line's title.
Ambiguous rows - a SKU shared by more than one product - are skipped with a row error rather than guessed. Add those items from the product picker instead.
Repeated rows for the same item combine into one line - quantities add together, and the first cost in the file wins.
Good to know
The import always creates a draft - review it, edit lines, or delete it freely. Nothing touches your Shopify inventory until you mark the purchase order as ordered.
One file creates one purchase order, for the supplier you pick in the dialog - a supplier column inside the file is ignored.
Files can hold up to 5,000 rows (5 MB). Split larger orders and import them as separate purchase orders.
On a brand-new store the option also appears in the empty state - Import from CSV, right next to Create purchase order.