Import the Converter's files into WooCommerce

The files written for WooCommerce

At the Export step, the Converter writes one CSV file per conversion, on your computer: comma separator, CRLF line endings, UTF-8 with BOM by default (Encoding setting in Settings). The suggested name is your file's name followed by _woocommerce.

• Products: the columns of WooCommerce's import tool (Type, SKU, Name, Regular price, Images, Parent…). A product with variants takes a variable row, then one variation row per variant, attached through the parent's SKU in Parent. A product's image addresses are in a single cell. There is no ID column: WooCommerce assigns its own IDs.
• Customers: one row per customer, with the fields of a WordPress user (user_login, user_email, roles…) and the billing_… and shipping_… addresses. The login is the email address.
• Orders: one row per order; the items are listed in item_name, item_qty and item_line_total, separated by commas. ORDERID is empty; the original number is in meta:_source_order_number.

For a large catalogue, tick the split into files of at most 500 rows at the Export step: you get products-atelier_woocommerce_01.csv, _02.csv… Each file repeats the header row, and a product stays whole, its variable row before its variations. According to WooCommerce's documentation, the maximum upload size depends on your hosting.

Import the products

1. In the WordPress admin, open Products > All Products, then click Import.
2. Click Choose File, choose products-atelier_woocommerce_01.csv, then click Continue.
3. On the Column mapping screen, check the proposed mapping: an unrecognised column is not imported.
4. Click Run the importer and stay on the page until it ends.
5. Repeat with _02.csv, then with the next files.

Without Update existing products, a row whose SKU already exists in the store is skipped. Tick it to update products already created.

Customers and orders

According to WooCommerce's documentation, customers and orders are imported with an extension: free extensions from the WordPress directory, or a paid WooCommerce extension. Each extension expects its own columns: compare those of the file written with its sample file, and use its column mapping screen if it has one. Import products and customers before orders.

Passwords never migrate. According to WooCommerce's documentation, your customers will need to reset their passwords.

WooCommerce error messages

Check the result

• Read the report at the end of the import: it lists skipped or failed rows, with their reason.
• In Products, check the number of products, then open a product with variants: the Variations tab must list each colour.
• Compare prices, SKUs, stock, categories and images with the original store.
• The What will not transfer (WooCommerce limits) section of the Review step lists what the file does not contain.

If WooCommerce refuses a row

1. Note the row and reason given by the import report: the number is the line in the imported file, not in your original file. Find the product by its SKU.
2. In History, click Start again, then Continue, and drop your original file again.
3. At the Review step, correct the value with Fix if the Converter flags this product; otherwise, correct it in your original file.
4. Export, then import the file concerned again: rows whose SKU already exists are skipped, unless you tick Update existing products.

If the Converter itself blocks the export, see Error blocking the export.