Pick the platform you are moving from
- EtsyEtsy to WooCommerce CSV converter
- WixWix to WooCommerce CSV converter
- SquarespaceSquarespace to WooCommerce CSV converter
- ShopifyShopify to WooCommerce CSV converter
- BigCommerceBigCommerce to WooCommerce CSV converter
- SquareSquare to WooCommerce CSV converter
- MagentoMagento to WooCommerce CSV converter
- PrestaShopPrestaShop to WooCommerce CSV converter
- EcwidEcwid to WooCommerce CSV converter
- eBayeBay to WooCommerce CSV converter
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
- In WordPress, go to Products, then All Products, and click Import.
- Choose woocommerce-products.csv and click Continue.
- On the column mapping screen, check that each column is matched. If the weight column is not matched, pick Weight for it.
- 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:
- Sorry, you are not allowed to upload this file type.
- Invalid file type. The importer supports CSV and TXT file formats.
- The file is empty or using a different encoding than UTF-8, please try again with a new file.
- The uploaded file exceeds the upload_max_filesize directive in php.ini.
- A product with this SKU already exists.
- A product with this ID already exists.
- Invalid product type.
- Variation cannot be imported: Missing parent ID or parent does not exist yet.
- Variation cannot be imported: Parent product cannot be a product variation
- Invalid catalog visibility option.
- Invalid product tax status.
- Unable to use image
- Accents and special characters garbled after a WooCommerce CSV import
- WooCommerce CSV import: variations or attribute options not showing
- WooCommerce CSV import: wrong prices, or products out of stock
- WooCommerce CSV import: columns show "Do not import" on the mapping screen
- File is empty. Please upload something more substantial.
- A new variation cannot be created because the parent product has no "%s" attribute.
- A new variation cannot be created because "%1$s" is not an option of the parent product's "%2$s" attribute.
- A new variation can only be created for a variable parent product.