How to map into Shopify
- Generate codes on this page and download sku-plain.csv.
- Export or download Shopify's own product CSV from Shopify Admin → Products (use Shopify's current template).
- Copy the SKU column from sku-plain.csv into the Variant SKU column of Shopify's file (match rows by product / variant).
- Import that Shopify CSV with Shopify's product importer in one upload.
Worked example
sku-plain.csv from this page uses these columns: SKU, Product, one column per attribute, and Options. The row below is what this page writes for prefix Tee, attribute Size value S, and attribute Color value Black. SKU holds the code. Product holds the prefix. Each attribute name becomes a column. Options lists those attributes again.
Copy the SKU column into Shopify's Variant SKU column. Match rows by product / variant.
This file is not Shopify's product CSV.
| SKU | Product | Size | Color | Options |
|---|---|---|---|---|
| Tee-S-Black | Tee | S | Black | Size: S; Color: Black |
Related
FAQ
Is this free?
Yes. You can use this free SKU generator tool in your browser with no account.
Is sku-plain.csv Shopify's product CSV?
No. Map the SKU column into Shopify's Variant SKU column, then import Shopify's file.
Do you write SKUs into my Shopify store?
No. Generation runs in your browser. You import with Shopify's importer.