All Articles
WooCommerce to Shopify CSV Export Formatting Guide
Key Takeaways & Executive Summary

Learn how to format WooCommerce CSV exports for Shopify import. Master column mapping, handle rules, and parent-child variant rows.

  • ✓Complete step-by-step tutorial with verified live examples.
  • ✓Compatible with WooCommerce 9.x and Shopify CSV schemas.

Why Formatting Matters for WooCommerce to Shopify CSVs

WooCommerce to Shopify CSV formatting is the systematic restructuring of raw product data columns—such as product identifiers, variant attributes, price numbers, and image paths—to conform strictly with Shopify's mandatory 50-column CSV import schema.

Improper CSV formatting leads to common import failures, including missing variant dropdowns, disconnected image galleries, and broken product handles. Using WooScraper's Shopify Exporter, this mapping is applied automatically.


Core Column Mappings: WooCommerce vs Shopify

Data FieldWooCommerce CSV HeaderShopify CSV Mandatory Header
Product IdentifierID / SlugHandle
Product TitleNameTitle
Full DescriptionDescriptionBody (HTML)
CategoryCategoriesType or Custom Collections
Variant Option NameAttribute 1 nameOption1 Name
Variant Option ValueAttribute 1 value(s)Option1 Value
SKU IdentifierSKUVariant SKU
PriceRegular priceVariant Price
Discounted PriceSale priceVariant Compare At Price
Main Image URLImagesImage Src

The Golden Rules of Shopify CSV Structure

  • Uniform Product Handle: Every row representing a variation of the same product must share the exact same Handle value.
  • Parent Row Exclusivity: The Title, Body (HTML), and Vendor fields should only be populated on the first row of a product; variation child rows should leave these columns blank to avoid duplication.
  • Direct Image URLs: All image links in the Image Src column must be publicly accessible direct HTTP/HTTPS URLs ending in .jpg, .png, or .webp.

Frequently Asked Questions

What happens if my images are hosted on a staging server?

Shopify downloads images at the moment of import. As long as your image URLs are publicly reachable without a login barrier, Shopify will cache them permanently on its CDN.

How does WooScraper format sale prices?

WooScraper maps the WooCommerce regular price to Shopify's Variant Compare At Price and the WooCommerce sale price to Variant Price, automatically displaying the proper strikethrough discount badge on Shopify.

Can I test CSV formatting for free?

Yes. WooScraper provides 100 products free on every scrape session so you can verify CSV structure directly in your Shopify test store.
Related Topics:#woocommerce csv#shopify csv format#store migration#product import#csv formatting
Azeem Greater

Azeem Greater

Lead Developer & Creator

Lead Developer & Creator of WooScraper

Full-stack software architect and creator of WooScraper. Specializing in high-performance web scrapers, reverse engineering unauthenticated e-commerce APIs, distributed proxy networks, and building reliable e-commerce catalog migration pipelines.

Related Tutorials & Articles

Continue exploring technical guides and e-commerce scraping strategies.

View All