Import purchase order history from CSV files

Moving to Stockroom from Stocky, Horse, or another purchase order app? Bring your purchase order history with you: upload the CSV files your old app exported, and Stockroom recreates your past purchase orders - statuses, dates, costs, suppliers, and receiving history included. Imported history never changes your Shopify inventory. Those orders were received long ago, so this is a paper trail, not a stock movement.

In Stockroom, go to Settings → Data & sync and find Import from another app. Drop your exported files straight onto Add CSV files or ZIP archives - or click it to browse.

You can add up to 200 files per upload, and a ZIP archive counts as one file but can carry a whole export folder. Each CSV can hold up to 5,000 rows, so split anything bigger before uploading. Stockroom reads the files right away and opens the preview. Missed some? Click Back in the dialog to add more files to the same batch, then Analyze files.

For purchase orders, use the export that lists the products on each order - its columns include things like Product, SKU and Qty Ordered. Stocky also has a purchase order list export (one row per order: No., Vendor/Supplier, totals and a Received count, with no products in it) - that file cannot rebuild your orders, so Stockroom recognizes it and skips it with an explanation rather than importing empty purchase orders. The same protection applies to any app's summary file: if no product or quantity column is mapped, the preview warns you that the orders would import with nothing inside them.

Stockroom reads your files and groups the ones that share the same columns, so you map each format once - even across hundreds of files. Stocky and Horse exports are recognized automatically (you'll see Detected format: Stocky export), and every column gets a proposed field under Maps to. Check the proposals, change anything that looks wrong, and set columns you don't need to Ignore. The preview also shows how many purchase orders were found and which new suppliers will be created.

If your files contain dates that could be read two ways - like 06/05/2025 - Stockroom asks How should dates be read? Pick MM/DD/YYYY (US) or DD/MM/YYYY to match how your old app wrote them.

Click the Import button - it counts what it will create, so it reads Import 40 purchase orders, Import 12 documents or Import 3 suppliers depending on what you uploaded. The import runs in the background, file by file - the Settings card shows progress like "Importing... 12 of 40 files", and you can keep working while it runs. When it finishes, you'll see "Import complete!" with a summary of what was created, along with notes about anything worth a look.

Then spot-check the result: visit Purchase orders and use the status tabs and search to confirm your history looks right, and open your new suppliers to fill in details like Email and Lead time (days).

Stocky's stock adjustments export (a stock_adjustments CSV) can go in the same upload - alongside your purchase order files or on its own. Stockroom recognizes it automatically (Detected format: Stocky adjustments export) and recreates each adjustment as an applied document under Inventory, Adjustments: reasons, dates, employee and notes are kept, per-item costs come along, and since Stocky completes stocktakes as stock adjustments, your count history arrives in the same file. Like everything else here, imported adjustments never change your Shopify inventory, and they never sync to accounting.

One caution: if you already brought adjustment history in with the direct Import from Stocky, don't upload the adjustments CSV as well - the two imports cannot recognize each other's documents, so running both can create duplicates. The preview shows a warning if that applies to you.

Stocky's per-stocktake export (the file you get from Export on a single stocktake) is the one Stocky file Stockroom does not import: it carries no date or status, and every completed stocktake is already in the stock adjustments export above. If one is in your upload, the preview labels it Stocky stocktake export, explains, and skips it - the rest of the upload is unaffected.

A supplier export goes in the same upload too. Stocky's Suppliers export - and any other list with a name column plus contact or address columns - is recognized as Detected format: Supplier list, and the preview maps its columns onto the supplier fields you know from the supplier page: name, contact name, email, phone, address, currency, payment terms, account number, notes and the rest. Suppliers are matched by name: a name you already have is updated with whatever the file fills in (blank cells never erase anything), a new name is created. So it does not matter whether the supplier list or the purchase order files import first - they land on the same supplier either way.

Two Stocky details: a currency of base means the supplier is billed in your store currency, so it is left blank rather than set; and Stocky's Website, Payment method and Fax number columns have no field in Stockroom, so they are listed as ignored in the preview. Prefer to import suppliers on their own? The same file works from the Suppliers page with Import CSV.