Skip to content
fileshape

Move WooCommerce products to Shopify with a CSV

Export products with WooCommerce's built-in exporter, drop the CSV below and pick Shopify products. You get Shopify's current product CSV columns: a URL handle generated from the product name, Price and Compare-at price worked out from WooCommerce's regular and sale prices, weight in grams and a Status of active or draft.

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 WooCommerce products

  1. 01In WordPress, open Products → All Products and click Export (next to Add new product).
  2. 02Export all columns for all product types (or only simple products, see the variants note below) and download the CSV.

2 · Import into Shopify products

  1. 01In Shopify admin, go to Products → Import.
  2. 02Click Add file, choose the Fileshape CSV, then Upload and continue. Check the preview before clicking Import products.
  3. 03Shopify fetches product images from their URLs, so keep the WordPress site online until the import is done.

Handles and URLs

Shopify identifies a product by its URL handle, the last part of its URL. WooCommerce's export doesn't include one, so the recipe creates it from the product name: “Linen Shirt (Blue)” becomes linen-shirt-blue. If you rely on existing WooCommerce URLs for SEO, set up redirects in Shopify afterwards from /product/old-slug to /products/new-handle, because the path prefix changes between the two platforms.

Prices and sales

WooCommerce stores a Regular price and an optional Sale price. Shopify stores the selling Price and an optional Compare-at price. When a WooCommerce product has a sale price, Shopify's Price becomes the sale price and Compare-at price becomes the regular price; otherwise Price is the regular price and Compare-at is empty. Scheduled sale dates don't exist in Shopify's CSV, so a sale that's live in WooCommerce at export time will be permanent in Shopify until you change it.

Categories, status and stock

WooCommerce categories can be nested and multiple (“Clothing > Shirts, Summer”). Shopify's product Type is a single value, so the recipe takes the deepest level of the first category, “Shirts” in that example. Collections can then be rebuilt in Shopify using automated rules on product type or tags, which also carry over.

Published products become Status active and published on the online store; anything else becomes draft. Stock moves to Inventory quantity with Shopify as the inventory tracker, and weights are converted from kilograms to grams (0.5 kg becomes 500).

Column mapping

How each Shopify products column is filled

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

Shopify products columnValue
TitleCopied from Name
URL handleCopied from Name; turned into a URL slug
DescriptionCopied from Description
Product categoryCopied from Categories
TypeCopied from Categories; part 1 after splitting on “,”, last after splitting on “>”
TagsCopied from Tags
Published on online storeCopied from Published; values mapped (0 → FALSE, 1 → TRUE, -1 → FALSE, anything else → TRUE)
StatusCopied from Published; values mapped (1 → active, anything else → draft)
SKUCopied from SKU
Option1 nameCopied from Attribute 1 name
Option1 valueCopied from Attribute 1 value(s)
PriceIf Sale price is greater than 0, then Sale price, otherwise Regular price
Compare-at priceIf Sale price is greater than 0, then Regular price, otherwise empty
Inventory trackerIf Stock is empty, then empty, otherwise “shopify”
Inventory quantityCopied from Stock
Weight value (grams)If Weight (kg) is empty, then empty, otherwise Weight (kg) times 1000, rounded to a whole number
Weight unit for displayAlways “kg”
Requires shippingAlways “TRUE”
Fulfillment serviceAlways “manual”
Product image URLCopied from Images; part 1 after splitting on “,”
SEO descriptionCopied from Short description

FAQ

Questions

Does Fileshape need access to my WordPress site?

No. You export the CSV yourself and the conversion happens in your browser.

Can I re-run the import to update products?

Yes. Shopify matches rows by URL handle. Tick “Overwrite products with matching handles” when importing and existing products are updated; without it, rows whose handle already exists are skipped.

What happens to WooCommerce attributes?

Attribute 1 name and value move to Shopify's Option1 name and value. Further attributes can be mapped manually in the mapping step.

Related

Updated 2026-11-20