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