How to import purchase orders into Shopify from a CSV
If you're changing apps, or kept purchase orders in a spreadsheet, you can keep that history. Export it as CSV and import it into Backroom; nothing in your Shopify inventory changes.
Steps
- Export your purchase orders as CSV from the app or spreadsheet you used before.
- In Backroom, open Import purchase orders and choose the file.
- Press Preview. You'll see the orders, suppliers, statuses and quantities found in the file before anything is saved.
- Choose the location the orders were received at and press Import.
Columns the importer reads
| Column | Accepted headers | Needed? |
|---|---|---|
| Product code | SKU, Variant SKU, Barcode, UPC, EAN, GTIN | Yes |
| Quantity ordered | Quantity Ordered, Qty Ordered, Ordered, Quantity, Qty | Yes |
| Purchase order number | PO Number, PO #, Purchase Order, Order Number | Optional |
| Supplier | Supplier, Supplier Name, Vendor | Optional |
| Status | Status, PO Status, Order Status | Optional |
| Quantity received | Quantity Received, Qty Received, Received | Optional |
| Unit cost | Unit Cost, Cost, Cost Price, Supplier Price | Optional |
Without a purchase order number column, the rows are grouped under the file name. Rows without a code or a quantity are skipped, and the preview tells you how many.
What importing does and doesn't do
- Imported orders are history: received quantities in the file never change your Shopify inventory.
- Lines are matched to your products by barcode or SKU. Lines that don't match are kept as history.
- Importing the same file again skips the orders that are already there.
- Supplier contacts usually aren't in these exports, so add them under Suppliers.
In Backroom: CSV import is included in the free plan.