Importing purchase orders
Bring purchase order history across from Stocky's CSV exports, what the import preview tells you, and how imported orders behave.
If you have used Stocky, Shopify's inventory app, you can bring your purchase order history into StockWay from its CSV exports. Shopify itself keeps no purchase orders, so there is nothing to sync; the import page is how past orders come across. It reads either of Stocky's two purchase order exports and shows you a preview before anything is saved.
Before you import
- Run a sync, so the app knows your locations and products.
- Import or create your suppliers (see Suppliers and vendors). Every order must belong to a supplier or vendor that exists here.
- Check each supplier's Currency. Imported orders take their supplier's currency, and a supplier imported without one starts at USD.
Which file to use
| Stocky export | What it contains | What you get |
|---|---|---|
| Purchase items report | One row per line: SKU, Shopify ID, quantity, cost and receive date | Orders with real line items |
| PO reports → CSV | One row per order: totals, dates and payment | Orders with totals and dates but no line items |
Importing both is fine. They are matched on the order number, so the items report fills in lines on orders the other file created. The page recognises the file from its header row, and the preview heading says which kind it read. In an items report, the order belongs to the Supplier column where it is filled in, and to the Vendor column otherwise.
Import a file
- Go to Purchases > More actions > Import CSV.
- Choose the CSV file, or paste the rows into …or paste the rows.
- For an items report, tick Create a vendor for any supplier this app does not have yet if you want missing suppliers created as vendors instead of skipped. The tick has no effect on a PO reports file.
- Click Check file and read the preview.
- If rows have problems, fix the file and start again, or tick the box to skip those rows and import the rest.
- Click the Import button, which shows how many orders will be written. Start over returns to the upload.
Nothing is saved until you confirm. A PO reports file can have up to 20,000 rows and an items report up to 50,000; split larger files.
What the preview tells you
- Suppliers and vendors not found: orders for these are skipped until the supplier exists, unless you ticked the create box for an items report.
- Products this app does not have: lines that match no product. Run a sync and import again; skipping them leaves those orders short.
- Repeated products combined: a product listed more than once on an order becomes one line, with the quantities added and the cost averaged, so the order is worth what the file says.
- Re-importing replaces an order's lines: for orders already here, their lines and receipts are deleted and rewritten from the file.
- These numbers already belong to a different supplier: importing will overwrite the stored order with that number.
- Repeated numbers, kept as separate orders: in a PO reports file, a later order with the same number gets a suffix, such as
1115-2. - Locations not found or Ship-to companies with no matching location: those orders are filed against the location the message names.
How imported orders behave
- The import moves no stock and changes nothing in Shopify. Receive dates from the items report are kept as receipt history.
- Status comes from the file. An order with no ordered (confirmed) date is a Draft; otherwise it is Ordered, Partially received or Received, depending on what was delivered.
- Orders keep their numbers, dates and invoice numbers. A PO reports file also brings the supplier's order number, shipping, adjustments, payment details and whether the order was archived.
- The currency is the supplier's, or your shop's when the order is with a vendor.
- Orders from a PO reports file show their total and received count over an empty line table, so there is nothing on them to receive or clone.
- An imported order that is still open has no Shopify delivery, so nothing shows as Incoming for it. Receiving it in the app adds the stock to Shopify as with any order.
Add lines to an existing order
There is no CSV import for adding lines to an order you already have. Open the order's editor and use Add to purchase order, where you can type or scan into Variant, or + Add out-of-stock items. See Purchase orders.
An items report that contains an order number already in the app replaces that order's lines and receipts, whichever way the order was created. It does not add to them.
Still have a question? Email us and we will help you get set up.
ilyasstaibi1992@gmail.com