The Excelify App makes your store data migration from WordPress/WooCommerce to Shopify easier and more accurate!
The main difference between Excelify and other data migration methods is that Excelify takes the data directly from WooCommerce API which means that there is access to more data and less room for error when handling files in different templates.
Direct connection to the WooCommerce API also allows the Excelify to migrate over any custom WooCommerce fields to Shopify Metafields, so no information is lost in the migration and you can then use those Metafields in your Shopify theme later.
You can migrate any WooCommerce images that are contained in your Product or Collection descriptions, so that all images, including images in the descriptions, are hosted in Shopify, and not on your old WordPress/WooCommerce servers which you will switch off anyway.
The following tutorial explains how to migrate following data from WooCommerce to Shopify:
- Collections (Categories in WooCommerce)
Steps to migrate your Store from WooCommerce to Shopify:
- Generate WooCommerce API credentials.
- Construct the WooCommerce API URL with credentials in the following template:
https://<consumer key>:<consumer secret>@<server>
- Start a new import job from the WooCommerce API URL.
- Check the job details and select the “Dry Run” option.
- Download and unzip the generated zip file.
- Upload the images to Shopify Files.
- Review the “Import_Result” Excel file before importing.
- Import final Excel file into Excelify app.
- Enjoy your WooCommerce store data in Shopify.
Now let’s dive into how to do it exactly.
1. Generate WooCommerce API credentials
Excelify app uses WooCommerce API to get your shop data.
The first thing we will need is API credentials that Excelify can use to access WooCommerce data.
Go into your WordPress Admin -> WooCommerce -> Settings -> Advanced -> Rest API -> Add Key
This will open a page where you can generate new API credentials.
There are three following fields to set:
- Description: Here you can enter a name for the credentials. It does not need to be a specific name, it is just for your own reference.
- User: Select the user through which the app will be accessing the API.
- Permissions: The app only needs to read the data from your store, so select “Read” permissions.
After the fields have been selected, click on the “Generate API Key” button.
Now you can see two fields “Consumer Key” and “Consumer Secret” that we will need in the next step.
2. Construct the WooCommerce API URL with credentials
In the Excelify app, we will need to provide a URL with API credentials from which the app will take your WooCommerce shop data.
The URL is constructed in the following template:
https://<Consumer Key>:<Consumer Secret>@<server>
For example, if we have the following credentials:
- Consumer Key:
- Consumer Secret:
So the URL for the Excelify would be:
You would need to take your own credentials that we created in the first step.
If you do not wish to migrate everything, you can add “
?only=” at the end of the URL to specify what you wish to migrate.
For example, to migrate only Customers and Products add “
?only=customers,orders” at the end of your URL.
Available values are:
3. Start a new import job from the WooCommerce API URL
Now that we have the URL constructed, we can go into the Excelify app. In the Import section you can paste your URL and press the “Upload from URL” button.
This will open a new import page where you can inspect that everything looks correct.
4. Check the job details and select the “Dry Run” option
In the new import page, we can see details about the import job that we are about to run.
You can see what data the app will import and make sure that item counts look correct.
Notice the “Format” should say “WordPress / WooCommerce API” – that way you know that it recognized and connected to your WooCommerce API.
Then scroll down to the “Options” and select the “Dry Run” option. This will only convert the data from your WooCommerce shop to Excelify template, without importing it just yet. It will give you a chance to then take a look at the converted data – check that everything is as you need, clean up your data before importing, and make any needed adjustments.
Doing a Dry Run is an optional thing – technically you could just run the Import without the Dry Run, and then look at the imported data directly in your Shopify Admin.
You do not need to change any other options – the default ones should work fine.
Check out Excelify Import Options documentation to see what each option means.
Press the “Import” button at the top or bottom of the page to start the Dry Run import.
Dry Run import should be quick, but if you have a lot of data and it takes a while, then you should know that you don’t have to keep the Excelify app open – you can close the browser, as it will continue working on our servers. Once the conversion is finished you will get an e-mail about it. Or you can just come back later and look into the recent jobs to see how it goes and if it’s finished already.
5. Download and unzip the generated zip file
Once the Dry Run (or import) is finished, you can press the “Download Import Results” button to download Excelify generated zip file.
Unzip that downloaded file. Inside you will find the folder “Images” and Excel file “Import_Result.xlsx“.
6. Upload the images to Shopify Files
In the “Images” folder you can find all image files that are used in the Product and Collection (Category) descriptions.
Since you are most likely going to switch off your old WordPress / WooCommerce hosting, you are going to need to host those images elsewhere. Shopify can host your images on their servers, and we strongly suggest using that opportunity.
When converting data from WooCommerce with the Excelify app, the image links in your Product and Collection descriptions are changed to the locations where Shopify will host those images. So all you need to do is to upload those images to Shopify so that those new links start to work.
Since Shopify does not allow apps to access the Shopify Files section then these would need to be uploaded manually to Shopify (but don’t worry, you can “select all files” at once when doing the upload).
Head into your Shopify Admin Files section by going in Shopify Admin -> Settings -> Files and press the “Upload” button to upload your files.
Navigate to your unzipped images folder and select to upload all those images.
This can be done by pressing Ctrl+A (or Cmd+A on a Mac) buttons on your keyboard.
It is important not to change the names of the images as then the uploaded image link will not match the one in your migrated descriptions.
If the Excelify has guessed the new image links correctly, then they will show up in descriptions. If you have any broken image links after the migration, please, contact Excelify Support so that we can fix it for you.
7. Review the “Import_Result” Excel file before importing
Once your images are uploaded to the Shopify Files section, we can take a look at the Excelify generated Excel file with your WooCommerce store data.
This is a great moment to fix and clean up any data that you want to make better now that you are moving to Shopify. Quite often legacy systems have some degree of a mess in the data – partial phone numbers, misspelled words, uneven variant option names, and so on. Or maybe there is something you don’t need to migrate, then you can simply remove that data from the import file.
All fields that do not have a specific place in the Shopify will be set as Metafields in the generated file. You can look into Shopify manual on the Metafields and also make a note of our tutorial on how to bulk manage Metafields if you need to edit them later in bulk.
The “Import_Results” file will contain multiple sheets/tabs for each entity:
- Custom Collections
In the Products sheet, you can find all the product details that will be migrated.
You can find explanations of each column in the Excelify Products documentation.
In WooCommerce you can have many Options per Product that are creating the Variants, but in Shopify, you can only have 3 options. The Excelify app solves this by including all options above 3rd into option 3, joined with
| symbol. That way you will still be able to choose all the options for your products, even if you had more than 3 options for your product variants in WooCommerce.
Custom Collections in Shopify are manual collections where you can manually add products to them.
These would be generated from your WooCommerce Categories.
You can find explanations of each column in the Excelify Custom Collections sheet documentation.
WooCommerce Product and Category (Collection) URLs are constructed differently in the Shopify.
This is why the Excelify app automatically creates a redirect for each Product and Collection so that search engines know where those items are moved and can update their index. Also, customers who have bookmarked links to specific pages, or backlinks that point to them – all those will still continue working after the migration because visitors will get redirected to the correct pages in your new Shopify store.
You can find explanations of each column in the Excelify Redirects sheet documentation.
This contains all the Customer details that you will migrate to Shopify, including all their Addresses.
Excelify will migrate all Customers – the ones that have Orders, and the ones that do not.
In WooCommerce each Customer has a “Role” assigned. In Shopify, there is no such thing as a Customer role, so this information will be stored in the Customer Tags. You can also find the Customer Role and other fields that Shopify does not have, in the Metafield columns.
You can find explanations of each column in the Excelify Customers sheet documentation.
In this sheet, you could see all the order data in the Excelify template.
The app would take all Orders from your WooCommerce store including their Refunds, Fulfillments, Customer addresses, and other details that can be found in the sheet.
You can find explanations of each column in the Excelify Orders sheet documentation.
8. Import final Excel file into Excelify app
Once you have made sure that data in the Excel file looks correct, you can again go into the Excelify app, and upload that Excel file into the Import section.
When the file is uploaded and analyzed, make sure that the app recognizes each sheet from the file.
Since you are now uploading the Excelify template file then you will also see that format is “Excelify“.
This time you do not need to select the “Dry Run” option as now you need to actually import the store data from the file.
If all details look correct, you can just start the import by pressing the “Import” button.
9. Enjoy your WooCommerce Store Data in Shopify
While the import is running you will see how many items are created and other details about the import.
Same as with the Dry Run previously, you can close the app while the job is running and come back later to check the results.
Once the import finishes you will see that it has a green “Finished” label.
Then you can go into your Shopify Admin and check your migrated WooCommerce Data in Shopify.
Good to know
- This tutorial explains how WordPress WooCommerce migration can be done with the Excelify app.
- You can skip the Dry Run step and the whole reviewing of the converted Import Result file, and import the data without the Dry Run option – it will do the import straight away, and it will still generate the converted Import Result file with the images folder. Remember to upload images to the Shopify Files section.
- If you see that some items in the import are showing as Failed, don’t worry – you can download the “Import Results” file of that import, and at the “Import Comment” column in each sheet, you can see the reasons for those items that failed. Then you can resolve those issues, and re-import just the Failed rows.
- If the import speed is important to you, the higher plan you upgrade to, the quicker the import will be, as for example, Enterprise Plan essentially spins off 10 parallel import processes, achieving the effect as if 10 apps would import your data in parallel.
- You can also migrate your WordPress Blog Posts and Pages to Shopify by following this tutorial.
- Learn more about migrations to Shopify and what other types of data Excelify can migrate to Shopify in bulk.
- If you feel stuck with something, our Support is willing to help you – just reach out to us.