Skip to content
fileshape

Convert a Shopify product CSV to WooCommerce

Export your products from Shopify as a CSV, drop the file below and choose WooCommerce. Fileshape renames every column to WooCommerce's importer names and converts the values that don't line up: compare-at prices become regular prices, grams become kilograms, TRUE/FALSE becomes 1/0. The result imports with WooCommerce's built-in product importer.

01

Your file

Stays on your device. Nothing is uploaded.

Drop a file here

CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.

No file handy? Try a sample:

Step by step

Export, convert, import

1 · Export from Shopify products

  1. 01In Shopify admin, go to Products and click Export.
  2. 02Choose All products and Plain CSV file, then click Export products and download the file.

2 · Import into WooCommerce products

  1. 01In WordPress, open Products → All Products and click Import (next to Add new product).
  2. 02Upload the Fileshape CSV. On the column mapping screen the columns already carry WooCommerce's names, so they map automatically.
  3. 03Run the importer. Images are downloaded from their URLs during the import, so leave the Shopify store online until it finishes.

Prices: compare-at vs regular and sale

The two platforms describe discounts differently. In Shopify, Price is what the customer pays and Compare-at price is the crossed-out original. In WooCommerce, Regular price is the normal price and Sale price is the discounted one. A straight column rename would put your discounted price in Regular price and lose the discount.

The recipe handles both cases. If a product has a compare-at price higher than its price, Regular price gets the compare-at price and Sale price gets the price. Otherwise Regular price is simply the price and Sale price is left empty. So a ₹1,999 shirt on sale for ₹1,499 arrives in WooCommerce exactly as it looked in Shopify.

Stock, weight and visibility

Inventory quantity goes to Stock, and In stock? is set to 1 when the quantity is above zero. Shopify stores weight in grams; WooCommerce's default importer column is kilograms, so 220 g becomes 0.22. Shopify's “Published on online store” TRUE/FALSE turns into WooCommerce's Published 1/0, so products that aren't on your online store arrive as drafts (WooCommerce's -1), not as private products.

Product category (Shopify's standard taxonomy, written with “>” between levels) goes into Categories. WooCommerce uses the same “Parent > Child” notation, so the hierarchy is created on import. Tags carry over as a comma-separated list, and the SEO description becomes WooCommerce's short description.

Products with variants

This is the one area to plan for. Shopify's CSV uses one row per variant: the first row holds the product details and later rows for the same URL handle only hold the variant's option value, SKU, price and stock. WooCommerce models this as a variable product with separate variation rows linked by a Parent column. Today Fileshape exports every row as a simple product, so a shirt with three sizes arrives as three products, two of them without a title.

If most of your catalogue is single-variant, convert as-is and fix the few variable products in WooCommerce. If you have many variants, filter the Shopify CSV to first rows only, import those, and add variations in WooCommerce. Grouping variants automatically is on our roadmap.

Column mapping

How each WooCommerce products column is filled

These are the exact rules the converter applies to your Shopify products file. You can change any of them in step 3 before downloading.

WooCommerce products columnValue
TypeAlways “simple”
SKUCopied from SKU
NameCopied from Title
PublishedCopied from Published on online store; values mapped (true → 1, false → -1, active → 1, …, anything else → 1)
Short descriptionCopied from SEO description
DescriptionCopied from Description
Tax statusCopied from Status
In stock?If Inventory quantity is greater than 0, then 1, otherwise 0
StockCopied from Inventory quantity
Weight (kg)If Weight value (grams) is empty, then empty, otherwise Weight value (grams) divided by 1000, rounded to 3 decimals
Sale priceIf Compare-at price is greater than Price, then Price, otherwise empty
Regular priceIf Compare-at price is greater than Price, then Compare-at price, otherwise Price
CategoriesCopied from Product category; “” if empty
TagsCopied from Tags
ImagesCopied from Product image URL
Attribute 1 nameCopied from Option1 name
Attribute 1 value(s)Copied from Option1 value

FAQ

Questions

Do I need a plugin to import into WooCommerce?

No. WooCommerce's built-in product CSV importer reads the converted file.

Are my products uploaded to Fileshape?

No. The conversion runs in your browser; the file stays on your computer.

Can I import customers and orders too?

This guide covers products. Customers and orders use different CSV layouts that aren't supported yet.

Related

Updated 2026-11-20