All things Shopify and commerce
I uploaded 1300+ images to files, hoping I can one-click C&P the URLs to an excel file for bulk upload products.
But I realized I must click the URL button every time. How can I make this process quicker with less clicking?
If not, is there a way I can change the button to a visible URL with inspect element on Chrome? This way, I can filter and delete other text and keep what I need in Excel.
Solved! Go to the solution
This is an accepted solution.
I figured out the solution hoping this will help anyone who needs to import multiple products including the product URL.
Step 1: Download this Google Extension called Table Capture.
Step 2: Open the Table Capture extension > go to options > enable "Extract image and icon attributes" > Save
Step 3: Go to files on Shopify > click Table Capture > Select in page > Select the file table
Step 4: Click "Copy table data to the clipboard" > then paste to Excel or Google Sheets.
Step 5: You should receive an URL that looks something like this: https://cdn.shopify.com/s/files/1/0627/8889/4888/files/0862001_60x60.jpg?v=1664467
Step 6: Make sure you select all links and remove hyperlinks, otherwise, it will not work.
Step 7: In Excel or Google Sheets > Press Ctrl + H > find _60x60 > replace with nothing > replace all
Done!
Final helpful step: After you received all the URLs for your products. Copy & Paste to your product import file. Then educate yourself on how to use "=vlookup" function in Excel or Google Sheets to match the image names to the correct URLs.
This is an accepted solution.
I figured out the solution hoping this will help anyone who needs to import multiple products including the product URL.
Step 1: Download this Google Extension called Table Capture.
Step 2: Open the Table Capture extension > go to options > enable "Extract image and icon attributes" > Save
Step 3: Go to files on Shopify > click Table Capture > Select in page > Select the file table
Step 4: Click "Copy table data to the clipboard" > then paste to Excel or Google Sheets.
Step 5: You should receive an URL that looks something like this: https://cdn.shopify.com/s/files/1/0627/8889/4888/files/0862001_60x60.jpg?v=1664467
Step 6: Make sure you select all links and remove hyperlinks, otherwise, it will not work.
Step 7: In Excel or Google Sheets > Press Ctrl + H > find _60x60 > replace with nothing > replace all
Done!
Final helpful step: After you received all the URLs for your products. Copy & Paste to your product import file. Then educate yourself on how to use "=vlookup" function in Excel or Google Sheets to match the image names to the correct URLs.
Amazing. I was planning to generate these using excel since from the minimal sampling I did the first few url values are consistent in my shop. The URL could also be accessed without the v (version?) parameter.
But hopefully the method you proposed keeps working for a while. Or.. ahem.. shopify could help us out here with an in house exporter (please).
The use case for me is migrating inventory to Shopify, the service I'm exporting from on the other end doesn't include images or public image URLs. Thousands of images.
I think another alternative would be to find another hosting service that can generate consistent public URLs for uploaded files. Maybe Azure Storage or AWS.
Anyway thanks for sharing the solution!
This solution works perfectly, thank you good sir for sharing your knowledge as it has saved me hours of work 🙂
David @Gamers Combined
Thank You for this tip.
But I am not sure if I am missing something, but if I want to get the URL from multiple pages in the files. can it be done using this extension, or I have to go through each page and copy it to the clipboard.
As of November 2023 this works! and you DON'T need the 'premium' option that the Google Chrome extension offers
Amazing find my man! Great job 😉
Hello I tried this but can't get more than one page of file links in the export. Do you have to pay for it then?
Kind regards,
Stan Legebeke
If you are trying to manage product image files across multiple platforms, have a look at BucketLynx.com. Our product allows you to create buckets for your image files, then upload product bulk upload template files for 16 eCommerce marketplaces, including Shopify. See https://bucketlynx.com for more information.
*Confirmed Working Method* - Just did this a few minutes ago and worked like a CHARM.
Since Shopify does not appear to want to help its customers whatsoever with the simplest of tasks like this export, we're on our own folks! After hours of trying to figure this out, here is a FREE way to pull & download every single link:
If you need to pull/download MORE than 200 product links, stay here. Otherwise, skip to the bottom of this.
mutation {
bulkOperationRunQuery(
query: """
{
files (query:"created_at:'$created_at'") {
edges {
node {
... on MediaImage {
image {
id
url
}
}
}
}
}
}
"""
) {
bulkOperation {
id
status
}
userErrors {
field
message
}
}
}
query {
currentBulkOperation {
id
status
errorCode
createdAt
completedAt
objectCount
fileSize
url
partialDataUrl
}
}
NOTE: If you want the altText, height & width of the images along with the Name/URL, just add them as extra lines below the other options you are pulling.
If you need to pull/download LESS than 200 product links, follow below
{
files (first:200, query:"created_at:'$created_at'") {
edges {
node {
... on MediaImage {
image {
id
url
}
}
}
}
}
}
Hope this is able to help someone so you aren't spending countless hours like I have on the most basic of tasks. Perhaps Shopify will listen to its customers in the future. Good luck 🙂
Isn't this pretty insane shopify doesn't have a bulk option solution to do this by now? If I upload 500 photos and shopify has the static URL's for each one, it'd be really nice to select all, copy, and paste into the Src column on the product import template.
bogles the mind!!!
it worked but I am getting URL for a time thumbnail and not the high resolution image.. am I doing something wrong?
Hi,
I have the same problem. Have you found a solution?
Kind regards
This didn't work for me as of February 2025.
I suggest this one that did work 😃
Discover how to increase customer engagement on your store with articles from Shopify A...
By Jacqui Apr 23, 2025Hey Community 👋 Did you know that March 15th is National Everything You Think Is W...
By JasonH Apr 1, 2025Discover how to increase the efficiency of commerce operations with Shopify Academy's l...
By Jacqui Mar 26, 2025