Import Purchase Orders via CSV

Last Updated: Nov 13, 2018 06:32AM PST
Use the Import Purchase Order CSV to create or import PO ship notices with line items, costs, arrival dates and warehouse information.

Note: This feature is available only on our latest version, Stitch X.

Export Template CSV

To export the template, go to the Purchase Orders page and click Import:

Add POs to CSV

Open the CSV in Excel, Numbers, Google Sheets, or your spreadsheet software of choice. You may leave optional fields blank, but keep all columns intact. 

When downloading the purchase order CSV template, Advanced POs only columns will appear only for plans that have Advanced Purchase Orders enabled.
CSV Column Availability Required? Validation and Notes
Expected Arrival Date Advanced POs only Optional MM/DD/YY or MM/DD/YYYY; rows with same expected by date and warehouse merge into the same ship notice
Warehouse Advanced POs only Optional case-sensitive; must match warehouse label exactly; if blank, default warehouse is used
SKU/Variant ID All Required bundles always ignored/skipped with no error message; multiple rows for same item won't merge; when multiple variants use identical SKU, most recent unarchived variant used
Qty All Optional  
Unit Cost All Optional number up to 8 decimals; no currency symbols
Supplier SKU All Optional  
Description All Optional  
Unit Discount All Optional negative number up to 8 decimals; no currency symbols
Unit Sales Tax All Optional number up to 8 decimals; no currency symbols
Additional Unit Cost 1 Type Advanced POs only Optional Keep Additional Unit Cost Types consistently named for better reporting aggregation.
Additional Unit Cost 1 Amount Advanced POs only Optional number up to 8 decimals; no currency symbols
Additional Unit Cost 2 Type Advanced POs only Optional Keep Additional Unit Cost Types consistently named for better reporting aggregation.
Additional Unit Cost 2 Amount Advanced POs only Optional number up to 8 decimals; no currency symbols
Additional Unit Cost 3 Type Advanced POs only Optional Keep Additional Unit Cost Types consistently named for better reporting aggregation.
Additional Unit Cost 3 Amount Advanced POs only Optional number up to 8 decimals; no currency symbols

‚ÄčImport CSV

Follow the instructions on the Import Purchase Orders CSV window to upload your CSV. Confirm import. The import takes place in the background and will take a few minutes.

If an upload is rejected, the error message will provide the specific row number and column name that is triggering the error.