How to Convert a Shopify CSV to WooCommerce (and Back)

Shopify and WooCommerce structure a product export completely differently — different column names, different ways of representing variants, different image-linking conventions — so a raw CSV from one platform is not something you can just upload into the other. If you're migrating stores, switching platforms, or running a WooCommerce site as a staging/backup for a Shopify store, you need an actual format conversion, not a find-and-replace on column headers.

The Shopify ↔ WooCommerce CSV Converter handles that conversion in your browser, in both directions.

Step 1 — Export your product catalog

From Shopify: Products → Export → Export all products. From WooCommerce: Products → All Products → Export, including variations. Either export works as the converter's input — it detects which platform the file came from automatically.

Step 2 — Drop the file in

Open the CSV Converter and drop your export. The tool reads the column structure and tells you which direction it detected (Shopify → WooCommerce or WooCommerce → Shopify) before converting anything, so you can catch a wrong file before you download the result.

Step 3 — Review the conversion

Products, variants and image references are mapped to the target platform's format: Shopify's option1/option2/option3 variant columns become WooCommerce attribute columns (and back), and each product's variant rows are restructured to match how the target platform expects grouped variants to look in a CSV.

Step 4 — Download and import

Download the converted CSV and import it through the target platform's own product importer (Shopify's Import products, or WooCommerce's Import under Products). Both platforms will show you a mapping/preview screen during import — it's worth a quick look before confirming, especially the first time you migrate a given catalog.

What doesn't carry over automatically

Be upfront with yourself about a few platform-specific things the conversion can't invent data for:

• Images hosted on the platform you're leaving. If your Shopify product images live on Shopify's CDN, those URLs won't resolve once the product is gone from Shopify. Re-host images on your own domain or re-upload them during the WooCommerce import.
• Platform-specific fields. Shopify's SEO title/description overrides and WooCommerce's tax classes and shipping classes don't have a direct equivalent on the other platform. Check your default settings after import rather than expecting these to travel with the CSV.
• Apps and metafields. Anything stored by a third-party app (reviews, subscriptions, custom metafields) lives outside the standard product export and needs its own migration path.

For a full walkthrough of a WooCommerce-to-Shopify migration specifically, including the order to do things in, see migrating WooCommerce to Shopify.

Clean up variants first if you're migrating a mature catalog

If your catalog has accumulated the kind of inconsistent variant values covered in our variant cleaning guide — "Red" vs "red," "S" vs "Small" — it's much easier to fix that before converting formats than after. You'll be reviewing the new platform's import preview either way; better to be reviewing clean data.

Try it now

Open the CSV Converter and drop your export to see the detected direction and converted structure, or load a sample file first if you want to see the mapping before committing your real catalog.