When you are migrating your WooCommerce website to another, the easiest way to do is to export all of your products into a CSV file and then import them to the other site. Product Import Export plugin for WooCommerce helps you do just that.
But when migrating your e-commerce website from another platform to WooCommerce, exporting and importing of a CSV is not quite straightforward. The format of the exported CSV might be unique to that platform which can generate errors while importing to the WooCommerce Website.
Say, for example, if you are using Shopify for your e-commerce website and you want to migrate to WooCommerce, the format of the CSV exported is unique to Shopify and can generate errors when importing. The fields or the field values of the exported CSV can vary from that which is expected in a WooCommerce website.
For example, when using the WebToffee Import Export plugin for Woocommerce, variations of a product are mapped to the parent product by its SKU. However, in Shopify, the URL of the parent product is used to map the variables to the parent product. Also, the fields that accept binary values can have TRUE/FALSE as their field values instead of YES/NO
However, this can be overcome with a slight modification to the exported CSV. In the CSV, for the variable products, you need to change the URL of the parent product to the parent SKU to map the variations to the parent product.
In case there are any fields that are missing from the exported CSV file in correspondence with the WooCommerce CSV format, the plugin will automatically populate the fields with its default value.
For the rest of the Shopify fields, you can use the mapping section to map the Shopify fields to the corresponding WooCommerce field which will enable you to import all your products from the Shopify website to a WooCommerce website. You can save the mapping of your first import and use them again for when there is another CSV with the same format.
For more information on importing and exporting of products, read our beginner’s guide for setting up the Product Import Export plugin for WooCommerce.