Pack, FX, and reorder planning

Stocky-to-Shopify Purchase Order Planning Worksheet

Turn a Shopify stock export into a draft purchase order worksheet with pack-size rounding, foreign-currency cost conversion, vendor grouping, and reorder suggestions.

Local browser scanSafe fixes onlyShopify-focused checks

Browser-side scan

Drop a stock or supplier cost CSV

-

No CSV selected

No CSV selectedUpload a stock CSV with SKU, vendor, current stock, a reorder rule, pack size, and supplier cost to draft purchase orders.
Private by default. Your Shopify stock or supplier CSV data stays in this browser session. The export applies only safe deterministic changes and leaves manual-review items in the findings list.

Merchants leaving Stocky lose pack-size ordering, default tax handling, and foreign-currency supplier costs that native Shopify purchase orders do not fully replace. This worksheet reads a sanitized stock CSV with SKU, vendor, current stock, a reorder rule, pack size, supplier cost, and exchange rate, then drafts order quantities rounded up to supplier pack multiples, converts unit cost into your base currency, and flags low-stock SKUs by vendor. It exports a review worksheet for manual purchase order creation and never calls Shopify or Stocky APIs.

Import blockers

Common causes this scan checks

  • Stocky is sunsetting and native Shopify POs do not round order quantities to supplier pack sizes.
  • Supplier costs are quoted in a foreign currency that needs converting before a PO is approved.
  • Reorder quantities must be calculated from current stock against a min/max or target rule.
  • Merchants need a vendor-grouped purchase order draft to review before ordering manually.

Workflow

How to use the cleaned CSV

  1. Export a sanitized stock CSV with SKU, vendor, current stock, a target or reorder-point rule, pack size, supplier cost, and exchange rate.
  2. Upload the CSV and review the SKUs flagged below their reorder rule.
  3. Export the purchase order planning worksheet with pack-rounded quantities and converted costs.
  4. Group the worksheet by vendor and create each purchase order manually in Shopify or your supplier system.

Auto-fix policy

What the export can safely change

  • Detects SKU, vendor, current stock, reorder point, target, pack size, supplier cost, currency, exchange rate, and tax columns.
  • Calculates reorder quantities up to the target and rounds them up to the supplier pack multiple.
  • Converts supplier cost into a base-currency unit cost and line cost using the exchange rate.
  • Exports a vendor-grouped planning worksheet without calling Shopify or Stocky APIs.

CSV example

CSV example: Stocky-style PO planning worksheet

The worksheet rounds the 16-unit shortfall up to a pack multiple of 6 and converts the supplier cost with the exchange rate, so each vendor purchase order can be reviewed before ordering.

Before
SKU,Vendor,Current Stock,Target Stock,Pack Size,Supplier Cost,Exchange Rate
MUG-1,Acme,4,20,6,3.00,1.1
After
Vendor,SKU,Current stock,Target,Suggested order qty,Pack size,Supplier cost,Exchange rate,Converted unit cost,Line cost
Acme,MUG-1,4,20,18,6,3,1.1,3.3,59.4

FAQ

Shopify CSV questions

Does this create Shopify purchase orders automatically?

No. It exports a local planning worksheet for review. Merchants still create purchase orders manually in Shopify or their supplier system.

What columns does the worksheet need?

Use SKU, vendor, current stock, a target or reorder-point rule, and optionally pack size, supplier cost, currency, and exchange rate for cost conversion.

Does it replace every Stocky purchase order feature?

No. This MVP covers pack-size rounding, currency conversion, and reorder suggestions. Demand forecasting, supplier master files, and PO merging stay on the roadmap.

Is my supplier and cost data uploaded anywhere?

No. The CSV is read locally in your browser with the File API. The worksheet never uploads your data or calls an API.

Related tools

Stocky Purchase Order API JSON to Shopify CSV Exporter

Paste the Stocky purchase-orders API JSON you exported yourself and turn it into a Shopify-shaped purchase-order and transfer review CSV in your browser. Rescue PO data before the Stocky sunset. No API call, no login, no upload.

Shopify Supplier SKU Purchase Order Mapper

Map Shopify SKUs and supplier SKU values into a purchase order worksheet for manual supplier ordering review.

Shopify Purchase Order and Transfer CSV Import Preflight

Validate Shopify purchase order and inventory transfer CSV files locally, normalizing supplier SKU, cost, tax percentage, quantity, and location into a review worksheet before a manual import attempt.

Shopify CSV Validator

Check a Shopify product CSV before import so you can catch structure, encoding, image, price, and variant problems early.

Feedback

How is this tool working for you?

Found a bug, a false alarm, or a missing check? Tell me — a human reads every note.