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

  1. Export your purchase orders as CSV from the app or spreadsheet you used before.
  2. In Backroom, open Import purchase orders and choose the file.
  3. Press Preview. You'll see the orders, suppliers, statuses and quantities found in the file before anything is saved.
  4. Choose the location the orders were received at and press Import.

Columns the importer reads

ColumnAccepted headersNeeded?
Product codeSKU, Variant SKU, Barcode, UPC, EAN, GTINYes
Quantity orderedQuantity Ordered, Qty Ordered, Ordered, Quantity, QtyYes
Purchase order numberPO Number, PO #, Purchase Order, Order NumberOptional
SupplierSupplier, Supplier Name, VendorOptional
StatusStatus, PO Status, Order StatusOptional
Quantity receivedQuantity Received, Qty Received, ReceivedOptional
Unit costUnit Cost, Cost, Cost Price, Supplier PriceOptional

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.

All guides