Supplier SKU PO worksheet
Shopify Supplier SKU Purchase Order Mapper
Turn Shopify SKU, supplier SKU, vendor, and reorder quantity columns into a purchase order worksheet without copying rows by hand.
Browser-side scan
Drop a supplier SKU purchase order CSV
No CSV selected
This mapper is for merchants who receive supplier SKU or vendor SKU data beside Shopify product identifiers. Upload a CSV with Handle or SKU, supplier SKU, vendor, title, and reorder quantity columns. The tool flags missing supplier SKU values, missing order quantities, duplicate mappings, and rows that are ready for a purchase order worksheet.
Import blockers
Common causes this scan checks
- Supplier SKUs do not match Shopify Variant SKU values one-to-one.
- Reorder quantities need to travel with supplier SKU and vendor context.
- Manual purchase order spreadsheets miss variants when copied from product exports.
- Merchants need a local worksheet before sending order rows to a supplier.
Workflow
How to use the cleaned CSV
- Prepare a CSV with Shopify Handle or Variant SKU, Supplier SKU, Vendor, Title, and Reorder Qty columns.
- Upload the mapping CSV and review missing supplier SKU, missing quantity, and duplicate mapping warnings.
- Export the purchase order worksheet and spot-check vendor and quantity columns.
- Send the reviewed worksheet to the supplier or copy it into an approved purchasing workflow.
Auto-fix policy
What the export can safely change
- Detects Shopify product identity, supplier SKU, vendor, title, and reorder quantity columns.
- Flags rows that cannot be safely mapped to a supplier item.
- Marks rows that are ready for purchase order worksheet review.
- Exports a local worksheet without creating purchase orders automatically or calling Shopify APIs.
CSV example
CSV example: supplier SKU purchase order worksheet
The mapper keeps Shopify SKU and supplier SKU values together so merchants can review purchase order rows before sending quantities to a supplier.
Handle,Title,Variant SKU,Vendor,Supplier SKU,Reorder Qty mug,Coffee Mug,MUG-1,Acme,ACME-MUG,12
Handle,Variant SKU,Supplier SKU,Vendor,Title,Reorder quantity,Review note mug,MUG-1,ACME-MUG,Acme,Coffee Mug,12,Ready for purchase order mapping
FAQ
Shopify CSV questions
Does this create purchase orders automatically?
No. It creates a local worksheet for review. Merchants still place purchase orders manually or through their own approved purchasing system.
What if supplier SKU is different from Shopify SKU?
That is the main use case. The worksheet keeps both identifiers together so the supplier-facing SKU does not overwrite the Shopify SKU.
Can this work from an inventory reorder CSV?
Yes, if the file also includes supplier SKU and reorder quantity columns. Otherwise use the SKU reorder helper first.