Product CSV converter for WooCommerce

WooCommerce's built-in product importer reads its own column labels, one row per product and one per variation, with every variation pointing at its parent. The converter below builds that file from another platform's product export, on your device.

Convert a product file to WooCommerce

To WooCommerce

A product export from Etsy, Wix, Squarespace, BigCommerce, Square, Magento, PrestaShop, Ecwid, eBay, WooCommerce or Shopify. The platform is detected from the file.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The products in the sample are invented. It is converted on this device, the same way your own file would be.

Loading the converter...

Pick the platform you are moving from

What the WooCommerce file gets

  • The column labels of WooCommerce's built-in importer (checked against WooCommerce 11.2.2), so columns map automatically.
  • Variable products with their variations, each variation linked to the parent by SKU. A parent SKU is made from the URL handle when the source has none.
  • Weights converted to your WooCommerce weight unit, with the matching column label such as Weight (kg).
  • Repeated SKUs left blank on the later rows, because WooCommerce rejects duplicate SKUs.
  • Products hidden from the online store written with catalog visibility hidden, and products that need no shipping written as virtual.
  • Attributes as product-level (not global) attributes.

How to import it

  1. In WordPress, go to Products, then All Products, and click Import.
  2. Choose woocommerce-products.csv and click Continue.
  3. On the column mapping screen, check that each column is matched. If the weight column is not matched, pick Weight for it.
  4. Click Run the importer. WooCommerce shows a count of imported, skipped and failed products at the end.

Before you import everything

  • Vendor and barcodes are not written: core WooCommerce has no vendor column, and the barcode (GTIN) column does not map automatically in 11.2.
  • Weight column labels other than Weight (lbs) are taken from WooCommerce's source code rather than a sample file. If yours is not matched on the mapping screen, match it by hand.
  • Images are imported by WooCommerce downloading each link, so the links must be public.

Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.

Questions

How do I import products into WooCommerce from another platform?
Export your products from the old platform, convert the file on this page, then in WordPress go to Products, All Products and click Import, and choose woocommerce-products.csv. Check the column mapping screen, then run the importer.
Which platforms can I convert to WooCommerce from?
Etsy, Wix, Squarespace, Shopify, BigCommerce, Square, Magento, PrestaShop, Ecwid or eBay. Each one has its own converter page with export steps and a before and after sample.
Will the import definitely work?
Nobody can promise that from a file alone. The converter follows each importer's documented rules, leaves out products that would be rejected and tells you about them, and does not check the WooCommerce file before download, so run it through the WooCommerce CSV checker on this site. Import a few products first, look at them in your store, then import the rest.
Was this tested by importing into a live WooCommerce store?
No. The column labels and rules come from WooCommerce 11.2.2's import code, not from a live store. Check the file with the WooCommerce CSV checker, then import a few products first.
Does it move customers, orders or reviews?
No. Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.

Have a WooCommerce CSV already? Check it before importing. Common WooCommerce import errors: