Solved

How to bulk extract image URL after uploaded to files?

newBornCharacte
Tourist
3 1 8

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.

 

WeChat Screenshot_20220927014750.png

Accepted Solution (1)

newBornCharacte
Tourist
3 1 8

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. 

 

 

 

 

View solution in original post

Replies 13 (13)

newBornCharacte
Tourist
3 1 8

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. 

 

 

 

 

jsmi
Visitor
1 0 1

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!

Gamers_Combined
Tourist
4 0 1

This solution works perfectly, thank you good sir for sharing your knowledge as it has saved me hours of work 🙂 

David @Gamers Combined

mustafa_ab93
Visitor
2 0 0

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.

Harrytux13
Visitor
2 0 0

As of November 2023 this works! and you DON'T need the 'premium' option that the Google Chrome extension offers 

Harrytux13
Visitor
2 0 0

Amazing find my man! Great job 😉

stanlegebeke
Excursionist
21 0 2

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

UwDiervoeding.nl | Founder

kgrammer
Tourist
38 0 1

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. 

Owner, https://bucketlynx.com

keeks95
Shopify Partner
5 0 4

*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:

 

  • Install GraphiQL App for free
  • Be sure to tick 'Select All' in case you want to modify this query for future use

If you need to pull/download MORE than 200 product links, stay here. Otherwise, skip to the bottom of this.

  • Open a query and copy/paste the red text below:

mutation {
bulkOperationRunQuery(
query: """
{
files (query:"created_at:'$created_at'") {
edges {
node {
... on MediaImage {
image {
id
url
}
}
}
}
}
}
"""
) {
bulkOperation {
id
status
}
userErrors {
field
message
}
}
}

 

  • Depending on how many you need to pull, this could take a min, but it should be pretty fast. I had to pull ~25,000 and it completed in a minute or two (it's very quick!!).
  • Next, run this query to actually DOWNLOAD the file:

query {
currentBulkOperation {
id
status
errorCode
createdAt
completedAt
objectCount
fileSize
url
partialDataUrl
}
}

 

  • If you see 'Completed' with the Status line, then you're ready to download!
  • Copy the very long URL link you see a few lines below
    • BulkQuery_Shopify.png 
    • This is a JSONL file, which can easily be opened/copied in Notepad or as a TXT file and then into Excel/GoogleSheets
  • Once you successfully download the file, it will have both the file name and the corresponding URL.
    • You will need to do you own extraction of the link itself (i.e. use Excel to get the value before/after the "url:"
    • Be sure to mass-delate all of the '\'  so you have a working URL link

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

  • Open a query and copy/paste the blue text below:

{
files (first:200, query:"created_at:'$created_at'") {
edges {
node {
... on MediaImage {
image {
id
url
}
}
}
}
}
}

  • This will retrieve the first 200 images in your Files/Content section, so if you have more than 200 there, use the first set of instructions.
  • You will need to do the copy/pasting/extracting from there.

 

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 🙂

Basement_bio
Visitor
1 0 0

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. 

CutiePieDirect
Visitor
2 0 0

bogles the mind!!!

CutiePieDirect
Visitor
2 0 0

it worked but I am getting URL for a time thumbnail and not the high resolution image.. am I doing something wrong?

MichiH2H
Tourist
5 0 1

Hi, 

I have the same problem. Have you found a solution? 

Kind regards