WooCommerce to Shopify CSV Export Formatting Guide

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

---

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.