Migrating from WooCommerce to Shopify

To start importing orders from WooCommerce, click the Data Mappings Template menu option on the navigation bar in EZ Importer. This will bring you to our data mappings template page. From here click the Use Template button next to the WooCommerce Mapping template.

After clicking the button you'll be redirected to the home page where you can start your testing. You should run a set of tests before doing your full import to ensure there are no surprises during your full import.

Order Numbers

The WooCommerce template will import the order numbers in your CSV file with your order. This means the order numbers should be the same as in your CSV file. If you want Shopify to generate your order numbers you can edit the data mapping we created and click the "Shopify will generate order number during import" checkbox. Read more about this feature here.

Fulfillment Status

The WooCommerce template does not map the fulfillment status. The status types from WooCommerce do not map the status types for Shopify so the fields can not be mapped. By default, your orders will be imported as unfulfilled.

If you want to mark your orders as fulfilled, the first thing you'll have to do is add a column to your CSV file. Any line item that is fulfilled should have a value of fulfilled and any line item that is not fulfilled should have a value of unfulfilled.

The next step is to map the fulfillment status on the Line Item level. To do this go to the Data Mapping we just created and click the Edit button. From here you'll be brought to the data mapping edit screen. Click the Line Items tab. Here you'll want to map the new column you just added by the name of the column in the Header Name column of the line_items.fulfillment status field. Once you've done this click the checkbox to the left of the column name.

WooCommerce Data Mapping

After you've made these changes, click the Update button on the bottom of the page. You're now ready to run your first test with your orders fulfillment status.

Discount Codes

The WooCommerce template does not map the discount codes. This is because WooCommerce exports your orders cost fields with the discounts applied. If we map the discount codes to the order, the discount will be applied twice and your totals will be off. There is no way to display the discount codes without adding them to the order total. If you are able to export your data without the discounts applied, you can read how to map the discount codes here.

Tax Lines

The WooCommerce template does not map tax lines. We haven't seen the tax lines in any of the WooCommerce CSV exports we've come across. We are by no means experts in WooCommerce and if you are able to export your orders with tax lines you can read about how to map them here.

However, the total taxes are being mapped as they are exported in the WooCommerce CSV file. This field is mapped on the Order Details tab. For more information about mapping taxes click here.

If we've missed anything or you think this data mapping can be improved, please don't hesitate to let us know!


App: EZ Importer

Tags: ez importer, csv, woocommerce, migrations