CSV variant builder for bulk uploads
Generate every SKU combination for a product with multiple options and export a Shopify or WooCommerce-ready import CSV — in the browser, without uploading anything.
Enter your product name, SKU prefix, base price, and up to three option groups (e.g. Size, Colour, Material) with comma-separated values. The tool builds every combination, assigns SKUs, and lets you download the full variant table as a Shopify or WooCommerce CSV.
CSV variant builder inputs and preview
Product details
Uppercase, no spaces.
Option groups
Variant preview
How this tool works
The tool takes a cartesian product of all active option groups — every combination of Size × Colour × Material — to produce the complete variant list. Each variant gets a SKU built from your prefix and the option values, cleaned to uppercase with spaces replaced by hyphens.
The Shopify CSV follows the standard product import format where the first row of each product includes the title and all option metadata, and subsequent rows for the same product share the Handle but leave the title blank. Import it via Products → Import in your Shopify admin.
The WooCommerce CSV generates a parent "variable" product row with all attribute values pipe-separated, followed by individual "variation" rows. Import it using WooCommerce → Products → Import in your WordPress admin.
About this tool
Enter a product name, SKU prefix, base price, and up to three option groups (e.g. Size: Small, Medium, Large; Colour: Red, Blue). The tool computes every combination using a cartesian product, assigns each a SKU, and exports the full variant list as a Shopify-compatible or generic CSV — ready to paste into a bulk import without building the table manually. Everything runs in the browser; nothing is uploaded.
Frequently asked questions
How are variant SKUs generated?
Each SKU is built from your SKU prefix followed by the option values, separated by hyphens. Values are converted to uppercase and spaces replaced with hyphens. For example, a prefix of "TSHIRT" with Size "Small" and Colour "Red" produces "TSHIRT-SMALL-RED". You can edit individual SKUs in the preview before downloading.
What format is the Shopify CSV in?
The Shopify export follows the standard variant import format: Handle (URL slug), Title (first row only), Option1 Name / Value, Option2 Name / Value, Option3 Name / Value, Variant SKU, and Variant Price. The first row of each product includes the title; subsequent rows for the same product leave the title blank and repeat the handle. This matches what Shopify's bulk product import expects.
What format is the WooCommerce CSV in?
The WooCommerce export generates a parent row with Type = "variable" and all attribute values pipe-separated, followed by one "variation" row per combination with individual attribute values. This matches the WooCommerce Product CSV Import Suite format.
Can I have more than three option groups?
No — Shopify and WooCommerce both cap products at three option dimensions. If you need more variation axes (e.g. Size × Colour × Material × Finish), consider splitting into separate products or using custom product metafields.
What happens if I have a lot of combinations?
The tool generates up to 1,000 combinations (10 × 10 × 10). Above that, most platforms require a different approach — either splitting into multiple products or using a programmatic import. The preview shows the first 20 rows; the full count is displayed.