Convert WordPress image URLs to your Shopify image URLs in Blog Posts

In this tutorial, we will take a look at how to convert your WordPress image URLs to your Shopify image URLs in your Blog Posts.

As you might have noticed – when migrating Blog Posts from WordPress to Shopify image links within your post content have not changed to new image links in Shopify, and now by closing your WordPress blog, you risk to lose all images. Worry no more – here we will take a look on how to fix this.

Here we will assume that you have already migrated your blog posts from WordPress to Shopify successfully. To do this, please, follow tutorial – Migrate Blog Posts from WordPress to Shopify.

Steps to convert image links

  1. Go to your WordPress site, and download all media library – there are multiple plugins that can achieve that – https://wordpress.org/plugins/search/image+download/.
  2. Head over to your Shopify admin and go to Settings -> Files, and press ‘Upload files’ and select images to upload. If all your media files are in the compressed file, then extract it to a folder.1-UploadToShopify
  3. Now export your Blog Posts from your Shopify Admin using Excelify app to Excel format.2-ExportBlogPosts
  4. In Exported file delete all unnecessary columns. Leaving us with only the following ones:
    • ID
    • Handle
    • Body HTML
    • Blog: ID
    • Blog: Handle3-EditExportedFile
  5. Now we are going to actually change links.
    • For this, we will need to locate ANY single picture link within ‘Body HTML’ column, and copy its link. This is how the link would look for me, but it will be different for you – https://excelify.io/wp-content/uploads/Blog-Posts-WordPress-to-Shopify-272×182.png4-FindWPImageLink
    • Select all ‘Body HTML’ column and open Find & Replace tool (Ctrl+H) and paste the link you just found in ‘Find what’. Delete image name/handle from the URL. If the link is with year and month folder, in the example – https://excelify.io/wp-content/uploads/2018/11/ then you must change it to – https://excelify.io/wp-content/uploads/*/*/
      5-CopyLinkFindRep
    • Open your Shopify admin Settings – Files and copy any image link.
    • Open Excel and paste this URL into ‘Replace with’, and again delete image name/handle from this URL.6-CopyShopifyLink
  6. Press ‘Replace All’ button and BOOM – all your image links within ‘Body HTML’ column are changed to image links that lead to Shopify.7-ExcelReplaceAll
  7. Save this file and import into Shopify using Excelify app.
  8. In your Shopify admin, go to Online Store -> Blog Posts. Locate any just now updated blog post, open it and press ‘View’. Now you can see images within it and if you click check image URLs they will lead to Shopify, not WordPress.8-CheckImageLink

Important!!!

  • If you have any issue with this, please, ask our Support, and we will help you.
  • If you have many Blog Posts, please, go thru this tutorial with one or few Blog Posts to test if everything works and you have filled fields correctly.