Skip to content

Bulk-import purchase orders

Goal: create several purchase orders in one pass from a spreadsheet. Where: Purchase Orders → Bulk Import.

Steps

The wizard runs in six steps:

  1. Store & Warehouse — choose the destination for every PO in this import. (Optional notes are added to each PO created.)
  2. Upload CSV — drop or pick your file. Detected columns are shown back to you.
  3. Map Columns — confirm the mapping (auto-detected where possible):
    • supplier (required) · sku (required) · quantity (required) · unit_type (unit/pack, optional) · unit_price (optional).
    • See Bulk-import CSV format for accepted header aliases and the validation rules.
  4. Validate — review the summary cards (valid / errors / warnings). Suppliers and SKUs are resolved; pack quantities are converted to base units; tax and retail are filled in.
  5. Import — rows are created, with a progress indicator.
  6. Complete — a report of created PO numbers and any failed rows.
The Bulk Import Purchase Orders wizard: a six-step stepper (Store & Warehouse, Upload CSV, Map Columns, Validate, Import, Complete) above a drag-and-drop CSV dropzone with the required-columns reference and a Download Template CSV link.
The bulk-import wizard — a six-step flow; the Upload CSV step takes a drag-and-drop file and lists the required columns.

Notes

  • Rows are grouped by supplier — you get one PO per supplier, each containing that supplier’s lines.
  • Each created PO starts in Draft, the same as a hand-made one.