Exporting Variable Products to Shopify Correctly

How to Export Variable Products to Shopify

Exporting variable products to Shopify requires structuring product data into a strict hierarchical matrix where a single parent product row defines general details (title, description, vendor) followed by sequential child rows defining specific variant combinations (Size, Color, Material, individual SKU, and custom pricing).

Using WooScraper, complex variable products with multiple option axes are converted into Shopify-ready CSVs automatically.

---

Anatomy of a Perfect Shopify Variation CSV

Shopify accommodates up to 3 option axes per product (e.g., Option 1 = Size, Option 2 = Color, Option 3 = Material) with a maximum of 100 total variants per item.

---

3 Essential Rules for Variation Success

• Blank Secondary Titles: Only the first row of a product should contain the Title and Body (HTML). Child variant rows must leave these fields empty.
• Identical Handle Key: Every variation row must repeat the exact same Handle string (e.g., classic-tee).
• Unique Variant SKUs: Assign unique SKU numbers to each variation row to ensure inventory sync applications function properly.

---

Frequently Asked Questions

What happens if a WooCommerce product has more than 3 attributes?

Shopify natively supports a maximum of 3 option dimensions per product. If a WooCommerce item has 4+ attributes, combine secondary options into a single descriptor (e.g., "Cotton / Regular Fit") or manage additional attributes via Shopify Metafields.

Does WooScraper link specific images to specific variant colors?

Yes. WooScraper associates each variant's specific featured image with its corresponding CSV row.

How many products can I test for free?

WooScraper offers 100 products free on every extraction job with no credit card required.