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.

 

Bulk import images to Shopify from your computer

Shopify bulk images - too many images

When you bulk import images to Shopify for Products or Collections, you need to provide image URL in the “Image Src” column.

But what if you have those images only on your computer? Then they don’t have URL because URL is only for images that are hosted online.

Your goal is to host your images online so that you get the URL for each image.

Manual option: upload to Shopify Files section (Free)

The default way of getting images uploaded to Shopify is through the Shopify Admin: “Settings -> Files” section. And then copy-paste each URL to your import file.

While this may work for 100 images, it’s not too easy when you have a lot more, even thousands of images.

Images in Shopify Admin

Bulk upload images to Excelify.io image server (for Excelify Enterprise Plan customers)

The bulk way of uploading images to Shopify is provided by Excelify.io image server. That will allow you to upload unlimited volumes of images directly from your computer, and instantly get them as URL to use in your bulk imports.

When you request the image server, you will get the instructions that will look like this.

Assuming that <your-store-folder> is “test”.

Instructions

  1. Install the CrossFTP application, free version, to your desktop: http://www.crossftp.com
  2. Open CrossFTP
  3. Open “Site Manager” under File -> Connect
    • Protocol: S3/HTTPS
    • Label: <Whatever name you want to give for this connection>
    • Host: s3.amazonaws.com
    • Port: 443
    • Access Key: ***************
    • Secret: ***************
    • Remote Path: /excelify-images/test
  4. Press “Apply” and “Connect”
  5. You will see all your images here.
  6. You can create subfolders there as you like.

Your files will appear on this URL:

https://s3-us-west-2.amazonaws.com/excelify-images/<your-store-folder>/<subfolder>/<file>

When you connect the first time, you should see there one test file: airplane.png

The URL for this file is respectively:
https://s3-us-west-2.amazonaws.com/excelify-images/test/airplane.png

Instructions in details

1. Install the CrossFTP application, free version, to your desktop: http://www.crossftp.com/download.htm

Shopify images bulk upload from desktop - CrossFTP downloadYou have a few options how to download the CrossFTP app.

The default way is to download the version that matches your operating system – Windows, MacOS, or Linux.

If you are having the computer that doesn’t allow installing new apps from the internet, you can use the Web Start to launch the CrossFTP directly from the web browser. Or you can download the Portable version to still have it on your computer, but it will not require installing.

2. Open CrossFTP

When opened for the first time, CrossFTP will look like this:

Shopify images - opened CrossFTP first time

3. Open “Site Manager” under File -> Connect

To open the Site Manager, click File, and then Connect.

The Site Manager will open with a new clean form to enter the connection details. Fill those fields one by one, with details provided in the instructions, so that you end up with filled form like this:

Shopify bulk images - connect to image server with CrossFTP

After you will enter and Apply to save your connection details, those will be saved and you will not have to enter them again.

4. Press “Apply” and “Connect”

You will now be connected to your image server. It will look like this:Shopify bulk upload images - connected to image file server

On the left side, you see files and directories on your computer.

On the right side, you see the files and directories on the image server.

There should be already one image on the server with name airplane.png. That is a test image, so you know that you are connected.

Now you can drag & drop files and folders from your computer (left side) to the image server (right side), and it will start uploading them. The upload should be very fast – it can upload at about 5’000 typical images per hour.

When uploading images, you will see the upload queue in the left bottom section of the app – like this:

Shopify bulk upload images - upload in progressWhile image uploading is in progress, you can press the Refresh icon on the top to see what has already been uploaded. In the status bar at the middle of the window, you can see the count of images that are already uploaded. That way you can get a clue of how far the overall upload is progressed.

How to get URLs for uploaded files?

Ideally, before uploading, you want to name your image files in such a way that you can calculate the image names from the product data you have.

One way is to give image names to match the SKU number. For example, if your Variant SKU for a product is ABC-123, then you want your image file to be named like ABC-123.jpg.

Another way is to give image names to match the Handle of the Product or Collection. For example, if your Handle is tshirt-red-slim-fit, then your file name should be tshirt-red-shim-fit.jpg.

That way you will be able to guess the image URLs by knowing your SKU or Handles. Then you can use the Excel formula to concatenate the pieces to make up your URL.

Guess the image URL from SKU

If you have SKU in the Excel column A, then the formula to calculate the image link for Product “Image Src” column is:

="https://s3-us-west-2.amazonaws.com/excelify-images/<your-store-folder>/"&A2&".jpg"

Notice the <your-store-folder> part of the formula – you need to replace that with your store folder, which is the folder name that comes after the /excelify-images folder.

Many images per SKU or Product

Sometimes you need to have more than one image per SKU or per product.

You can then name your images by adding numbers to the end.

For example, if your SKU is ABC-123, then you can create images with names ABC-123-1.jpgABC-123-2.jpgABC-123-3.jpg, and so on.

Then your formula for the Product “Image Src” column will be like this:

="https://s3-us-west-2.amazonaws.com/excelify-images/<your-store-folder>/"&A2&"-1.jpg ; "&
"https://s3-us-west-2.amazonaws.com/excelify-images/<your-store-folder>/"&A2&"-2.jpg ; "&
"https://s3-us-west-2.amazonaws.com/excelify-images/<your-store-folder>/"&A2&"-3.jpg"

Again, you need to replace the <your-store-folder> with your store folder.

Notice that now in the Image Src cell you will have three images, separated by ; (semicolon). That import will work because the app allows you to import several images from the same row. For more details about that feature, read the tutorial how to import several images from the same row.

Different products might have a different count of images. You don’t have to worry about that because if the image will be missing from the URL, it will still skip it and continue importing only images that really exist.

How to get the list of all uploaded image files into Excel?

If you just want to get the list of uploaded images to the Excel table, so that you can then put the links where you need them, you can copy-paste them from CrossFTP app to Excel.

To do it, select all uploaded images on the server, and press Ctrl+C on the keyboard (Cmd+C on MacOS). That will have all your image file list copied. Then go to Excel and paste the list of images.

The pasted list of images in Excel will look like this:

Shopify bulk import images - paste image links to ExcelNow, to make the full image URL of those images, you can use the formula like that:

="https://s3-us-west-2.amazonaws.com/"&A1

Potential issues with uploading images and how to solve them

If you find yourself on the empty server

Shopify bulk image upload - empty serverNotice in the address bar at the top – where you are located. If you see you are at the /excelify-images folder, then most likely you have entered the [..] folder (which takes you one level up), or you have pressed the backspace on the keyboard (which also takes you one level up). There, one level up, is an empty void of nothingness, because it’s outside of your image folder. Now you need to go back to your store image folder. The easiest way to do it is to connect again.

Press File, and Connect to bring up the Site Manager. Find your saved connection there, and click Connect. It should connect you again to the image server, and you should see your images again.

If that still doesn’t help, then please check the Remote Location field in the Site Manager. It should be /excelify-images/<your-store-folder>.

If that doesn’t help either, please, contact Excelify.io Support.

If your internet got disconnected or CrossFTP closed while upload was not finished

The CrossFTP app is robust enough to be able to continue uploading images from where it left off, in case you lost the internet connection or had to close the app.

When you will open the app again, it will offer you to continue uploading, like this:

Shopify bulk image upload - continue uploading after disconnectThere you need to press the Restore button. It will restore the “queue” of files that still need to be uploaded.

After pressing Restore, you will again see the queue of files in the left bottom section. Click on that queue and press Ctrl+A (or Cmd+A on MacOS) to select all items. Then right-click with the mouse there and select Start Transfer. That will continue uploading images from where you left off.Shopify bulk upload images - image upload queue

 

How to gain access Excelify.io image server?

  1. Install the “Bulk Import Export Update with Excel” app to your Shopify Store.
  2. Activate the Enterprise Plan (you need this plan to use image server).
  3. Request your image server by contacting Support.

How to import several product images from one row?

Shopify several images for product (with video)

So you are in this situation when you have to import several product images, but you hate to copy rows?

Here’s how you import several images per Product as one row – by separating image URLs with ; (semicolon).

Step 1: Prepare Import File With Several Product Images

Prepare your import file, where you have one row per Product, and put all your images in the same “Image Src” column, delimited by ; (semicolon).

For example:

https://i.com/image-1.jpg ; https://i.com/image-2.jpg

To change images for a Product in this way, you need at minimum the following columns in your import file:

  • ID (or Handle)
  • Image Src

Shopify import several product images separated by semicolon

Step 2: Import That Excel File With Images

Import that with Bulk Import Export Update with Excel app.

Shopify Product several images import

Step 3: View Imported Images

Shopify imported several images delimited by semicolon

Good To Know

  1. You can have up to 250 images per Product.
  2. You can add, replace and update images for products the same way.
  3. You can combine both image import methods – have them as several rows, and split by ; (semicolon) in the same cell. As visible in the example image with Product “Jumping Dog”.
  4. Remember to give name for sheet “Products”, so that it knows which sheet contains Products import.
  5. You can update many Product fields at once with the same import file – just put them as additional columns.

 

Where To Go From Here?

  1. Install the Bulk Import Export Update with Excel app from Shopify AppStore and try bulk update for Free on your own store.
  2. If you want to know more about this app, look the How it works? tutorial and video.
  3. Read the detailed Field Descriptions.
  4. Read other Tutorials.
  5. If you are not sure how to prepare the import file, ask our Support, we will teach you, or do that for you.