PO and transfer CSV preflight

Shopify Purchase Order and Transfer CSV Import Preflight

Validate and normalize purchase order and inventory transfer CSV files in your browser before a manual Shopify import attempt, so rows with missing cost, tax, quantity, or location are caught first.

Local browser scanSafe fixes onlyShopify-focused checks

Browser-side scan

Drop a PO or transfer CSV

-

No CSV selected

No CSV selectedUpload a CSV with Shopify SKU, supplier SKU, supplier cost, tax percent, and quantity columns. Files are read locally and nothing is uploaded.
Private by default. Your Shopify purchase order or transfer CSV data stays in this browser session. The export applies only safe deterministic changes and leaves manual-review items in the findings list.

This preflight prepares purchase order and inventory transfer CSV files for a manual Shopify import review. Everything runs locally in your browser with the File API, and no data is uploaded to a server. Upload a CSV that pairs Shopify SKU or Handle with supplier SKU, supplier cost, tax percentage, quantity, and location columns. The tool normalizes those columns, flags missing or invalid required fields per row, and exports an import-ready worksheet plus a reconciliation review sheet for manual checking. It does not call Shopify APIs or write data to any platform.

Import blockers

Common causes this scan checks

  • Manual purchase order and transfer spreadsheets silently lose rows when supplier cost, tax percentage, quantity, or location columns are missing or malformed.
  • Supplier master data uses different SKU values and cost formatting than the Shopify product export.
  • Tax percentages are stored as decimals from 0.0 to 1.0 in some systems and as whole numbers from 0 to 100 in others.
  • Merchants need a local worksheet that maps supplier data onto Shopify SKU rows without uploading catalog data anywhere.

Workflow

How to use the cleaned CSV

  1. Prepare a CSV with Shopify SKU or Handle, Supplier SKU, Supplier Cost, Tax Percent, Quantity, and Location columns.
  2. Upload the CSV and review missing or invalid column warnings, especially for cost, tax percentage, quantity, and location.
  3. Spot-check rows flagged with missing cost, tax percent, or quantity before exporting the worksheet.
  4. Export the import-ready worksheet and confirm every cost, tax percentage, and quantity value is numeric before any manual import attempt.

Auto-fix policy

What the export can safely change

  • Detects Shopify SKU, Handle, Supplier SKU, Supplier Cost, Tax Percent, Quantity, and Location columns from common naming patterns.
  • Normalizes supplier cost from currency-formatted or decimal text into a numeric purchase price.
  • Notes when tax percentage may need converting between a 0 to 100 scale and a 0.0 to 1.0 decimal scale for consistency.
  • Marks rows that have valid cost, tax percent, quantity, and identity as ready for the review worksheet without calling Shopify APIs.

CSV example

CSV example: PO and transfer import preflight worksheet

The preflight normalizes the Shopify SKU and supplier SKU, converts the currency-formatted cost to a numeric value, keeps the tax percentage on a consistent scale, and confirms quantity and location before marking the row ready for a manual import review.

Before
Handle,Variant SKU,Supplier SKU,Supplier Cost,Tax %,Qty to Order,Location
mug,MUG-001,ACME-M,$19.99,8.5%,50,Warehouse A
After
Type,SKU,Supplier SKU,Vendor,Supplier cost,Tax percent,Quantity,Location,Review note,Source row
PO,MUG-001,ACME-M,,19.99,8.5,50,Warehouse A,Ready for PO/transfer import,2

FAQ

Shopify CSV questions

Does this tool submit data to Shopify or my ERP?

No. It validates and normalizes your CSV locally in the browser and exports a worksheet. Any purchase order or transfer import still happens manually in your own approved workflow afterward.

What if supplier cost is in one column and tax is in another?

Keep both on the same row so the worksheet can carry supplier SKU, cost, tax, and quantity together. The tool reads each as a separate detected column and validates them per row.

How do I know if my tax percentage is correct?

The validator flags values outside 0 to 100 and notes when a decimal value between 0.0 and 1.0 may need converting to a whole-number percent. Always confirm the final figure against your supplier agreement before importing.

Can this convert my supplier master file into a finished import?

It normalizes and validates supplier data against Shopify SKU rows, but mapping judgment (which supplier row belongs to which product) stays a manual review decision in the exported worksheet.

Related tools

Shopify Supplier SKU Purchase Order Mapper

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

Shopify PO Received Items Barcode CSV Exporter

Build a received purchase order barcode CSV worksheet from SKU, barcode, location, and received quantity columns.

Shopify Inventory Transfer CSV Planner

Plan Shopify inventory transfers from SKU stock levels and min/max rules, then export a manual-review transfer worksheet.

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.