Migrate Blog Posts and Pages from WordPress to Shopify

Blog Posts - WordPress to Shopify

This video tutorial shows you step by step instructions on how to migrate your Blog Posts and Pages from WordPress to Shopify.

Steps to migrate Blog posts and Pages from WordPress to Shopify:

  1. Export your WordPress Blog Posts or Pages using the All Export” plugin to the CSV file.
  2. Rename the CSV file to contain words “WordPress” and “Posts” or “Pages” depending on what you are migrating, for example, “WordPress-Posts-Export-2019-September-23-1638.csv“.
  3. Upload file in the Excelify app.
  4. (optionally) Select “Dry-run” option to generate Excelify template file and ZIP with your images.
  5. Download Excelify generated files.
  6. Upload the image files to your Settings -> Files section in Admin.
  7. Double-check the generated Excel file and clean-up any information if needed (if you did a dry-run).
  8. Import your Excel file in the Excelify app to create your Blog Posts or Pages (if you did a dry-run).
  9. Check your Import Results file after the import.
  10. Enjoy your migrated data.

Now let us go thru each step in detail:

1. Export your WordPress Blog Posts or Pages using “All Export” plugin

Install the plugin and create new export

In your WordPress site, to export all necessary details about the posts, you first need to install the plugin “All Export“.

Once installed and activated – in the left side panel you can click on “All Export” -> “New Export“.

Select “Post Type” – “Posts” or “Pages” from the drop-down depending on which ones you wish to migrate and click on “Customize Export File

1 - export posts using All export to csv

Customize Export File

Now you need to select specific fields to export for your posts.

You can also try selecting “Add All” but in some cases, this can break the CSV file data leading to corrupt CSV file – we are suggesting to select specific following fields for your exports.

Blog Posts

Standard – ID, Title, Content, Excerpt, Date, Permalink
Media/Images – Alt Text, Featured
Taxonomies – Categories, Tags
Custom Fields – _yoast_wpseo_metadesc, _yoast_wpseo_title (Optional SEO fields from Yoast plugin)
Other – Status, Author First Name, Author Last Name, Slug, Post Modified Date

1.1 -Select fields to export in All Export CSV Excelify

Pages

Standard – ID, Title, Content, Date, Permalink
Custom Fields – _yoast_wpseo_metadesc, _yoast_wpseo_title (Optional SEO fields from Yoast plugin)
Other – Status, Author First Name, Author Last Name, Slug, Post Modified Date

1.2 -Select fields to export in All Export CSV Excelify Pages

 

Once fields are selected click on the “Continue” button.

If you wish you can select any options that you have on this page.

In this page, in the field “Friendly Name:” you can also already apply Excelify friendly name to your export file, for example – “WordPress Blog Posts“.

When you have selected Options you need, you can click on the “Confirm & Run Export” button to start the export.

1.3 apply options and file name WordPress Posts all export

Download exported file

Now you will have to wait a bit for the items to get exported. When it is finished new page will open where you can click on the “CSV” button, to download exported CSV file.

1.5 - download all exported exported wordpress blog posts csv

2. Rename the exported file

If you did not apply the “Friendly Name” option then this is the moment when you need to rename the file to contain words “WordPress” and “Posts” or “Pages“, for example, “wordpress-posts-for-excelify.csv

2 - reanme the file to wordpress posts excleify csv migrate shopify blog psots

3. Upload the file to Excelify

At this stage, you do not need to edit the file and can just upload it to the Excelify app.

Head into the Excelify in Shopify and in the Home page of the app you will see “Import” section.
Press “Add File” button or drag & drop the file in this section.

3 - Excelify import upload file section

First, the app will upload the file and analyze it.

Once analyzed, make sure that the app recognized the file as “WordPress” format and Blog Posts (or Pages).

Here you can also see that the app will generate Redirects as in Shopify Blog Posts will have different URL path in Shopify.

3 - upload WordPress posts to Shopify Excelify

4. Select “Dry-run” option (optional)

This step is optional – that is – if you don’t want to import this data just yet, but want to edit the converted file before importing.

Before pressing the “Import” button, go to the “Options” section of this import job and select option “Dry Run – convert the file and test as far as possible without actually importing anything“.

Once options are selected, press the “Import” button to convert the WordPress data to Excelify template file which is suitable for later import to Shopify using Excelify.

Note – you do not need to keep the app open while the job is running as the app is working on it on our servers. You are free to close the app and by default store owner will receive an email about a finished job (can be edited in Excelify app Settings). You can always find this job in the app by going into “All Jobs” page.

4 - upload wordpress posts to Shopify excelify csv

5. Download Excelify generated files

When the app will have finished generating the files you will see green “Finished” label for the job.

Now you can click on the “Download Exported File” button to download your file.

5 - download results file wordpress excelify csv excel xlsx

6. Upload generated images to Shopify Files

In the exported ZIP file you should have a directory “Images” with all images from these Blog Posts (or Pages).

Start by unzipping the file in your computer.

6 - unzip generated Excelify file WOrdpress

Now head into your Shopify Admin Files section by going in Shopify Admin -> Settings -> Files and press the “Upload” button to upload your files.

6.1 - Upload files to Shopify Admin WordPress

Navigate to where you had downloaded your file and locate the “images” folder.
Select to upload all images from this folder. This can be done by pressing Ctrl+A (or Cmd+A on a Mac) buttons on your keyboard.

Wait for your files to get uploaded. Do not close the browser window till all files are uploaded into the Files section.

Note – It is important not to change names of the images as then uploaded image link will not match the one in your migrated Blog Post (or Page) content.

6.2 - uploaded to Files Shopify Excelify WordPress post images.

7. Check the Excelify generated Excel file

Do this step if you did a dry-run earlier.

In the unzipped file you also had an Excel file.

This file should contain two sheets – “Blog Posts” or “Pages” and “Redirects“.

This is a great moment to clean up some data that you do not wish to migrate to Shopify.
Check the file for any obvious errors or incorrect data that you might wish to fix.

All none-colored columns are there only for the reference if you need to edit/check the data – they will not be actually imported into to Shopify.

Note – Image links in your blog post content already have been transformed to lead to your Shopify Files section, so they will not point to your old WordPress site.

Note – if you are copying the data to other sheets, then before importing make sure that sheet/tab name in the Excel file is “Blog Posts” for the blog posts, “Pages” for the pages and “Redirects” for redirects. The Excelify app uses this sheet name to tell what you are importing.

Blog Posts

7 - check generated Excel WordPress Shopify Blog Posts Excelify

Pages

7 - check generated Excel WordPress Shopify Redirects for pages Excelify

Redirects

7 - check generated Excel WordPress Shopify Redirects for blog psots Excelify

8. Import your Excel file in the Excelify

Do this step if you did a dry-run earlier or if you want to change some data and do the re-import again.

If all the data looks correct in the Excel file and images to have been uploaded, then you can go into the Excelify app and now in the “Import” section upload the generated Excel file.

Once the file is uploaded and analyzed, make sure that the app recognizes the contents as Blog Posts and Redirects, since you are now uploading 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 Blog Posts, if all details look correct, you can just start the import by pressing the “Import” button.

9. Check your Import Results file after the import

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why the particular item has failed. Then you can fix that issue and re-import just those failed and fixed rows again.

Note – you do not need to keep the app open while the job is running as the app is working on it on our servers. You are free to close the app and by default store owner will receive an email about a finished job (can be edited in Excelify app settings).
You can always find this job in the app by going into “All Jobs” page.

8 - import WordPress Post and Pages to Shopify Excelify CSV XLSX Excel

8.1 - imported WordPress Post and Pages to Shopify Excelify CSV XLSX Excel

10. Enjoy your migrated data

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 Blog Posts or Pages.

9 - enjoy migrated WordPress Blog Posts in Shopify Excelify Excel XLSX CSV

9 - enjoy migrated WordPress Pages in Shopify Excelify Excel XLSX CSV

Good to know

  • This tutorial explains how the WordPress migration can be done with the Excelify app, click here to install the Excelify app.
  • Check out other Shopify Blog Post related tutorials.
  • Each column in our template files is explained in our template documentation.
  • If the import speed is important to you, the higher plan you upgrade to, the quicker the import will be. For example, Enterprise Plan essentially spins off 10 parallel import processes, achieving the effect as if 10 apps would import your data in parallel.
  • If you feel stuck with something, our Support is willing to help you – just reach out to us.