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
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.
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