Get Matrixify now
Get Matrixify now

Migrate Blog Posts and Pages from WordPress to Shopify

Blog Posts - WordPress to Shopify|1 - export posts using All export to csv||1.3 apply options and file name Wordpress Posts all export|1.5 - download all exported exported wordpress blog posts csv|2 - reanme the file to wordpress posts excleify csv migrate shopify blog psots|3 - upload Wordpress posts to Shopify Excelify||||6.1 - Upload files to Shopify Admin Wordpress|6.2 - uploaded to Files Shopify Excelify Wordpress post images.|7 - check generated Excel Wordpress Shopify Blog Posts Excelify|7 - check generated Excel Wordpress Shopify Redirects for blog psots Excelify|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|9 - enjoy migrated WordPress Blog Posts in Shopify Excelify Excel XLSX CSV|1.2 -Select fields to export in All Export CSV Excelify Pages|7 - check generated Excel Wordpress Shopify Redirects for pages Excelify|9 - enjoy migrated WordPress Pages in Shopify Excelify Excel XLSX CSV

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 Matrixify (Excelify) app.
  4. Select Import options – select “Dry-run” and fill Old server URL
  5. Download Matrixify (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 Matrixify (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 Matrixify (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 Matrixify (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 Matrixify (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 Matrixify (Excelify)

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

Head into the Matrixify (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 - Matrixify (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 Matrixify (Excelify)

4. Select Import options

Old server URL

In the Import Options, you should see the field “Old server URL” in which you would fill the website’s domain that you see when logged in to the WordPress admin.

This Domain URL will be used by the app for two main reasons:

  1. If in the Post or Pages content there are relative image links, that do not have a domain. Then the app will use the filled domain to construct the image link for an image download.
  2. If the store URL is filled, the app will try to take Post and Pages content primarily from WordPress API. The benefit here is that the API returns front-end content HTML code ensuring that formatting is correctly migrated if using various plugins for content formatting in WordPress.

Enable “Dry-run”

In the Import Options section of this import job and select the option “Dry Run – convert the file and test as far as possible without actually importing anything“.
Using dry-run the app will not import any data in the store but will generate Matrixify (Excelify) Excel file and Folder with Images from the content.

Once options are selected, press the “Import” button to convert the WordPress data to Matrixify (Excelify) template file which is suitable for later import to Shopify using Matrixify (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 Matrixify (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 Matrixify (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 Matrixify (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 Matrixify (Excelify) WordPress post images.

7. Check the Matrixify (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 Matrixify (Excelify) app uses this sheet name to tell what you are importing.

Blog Posts

7 - check generated Excel WordPress Shopify Blog Posts Matrixify (Excelify)

Pages

7 - check generated Excel WordPress Shopify Redirects for pages Matrixify (Excelify)

Redirects

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

8. Import your Excel file in the Matrixify (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 Matrixify (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 Matrixify (Excelify) template file then you will also see that format is “Matrixify (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 Matrixify (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 Matrixify (Excelify) CSV XLSX Excel

8.1 - imported WordPress Post and Pages to Shopify Matrixify (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 Matrixify (Excelify) Excel XLSX CSV

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

Good to know