All things Shopify and commerce
I want to create a csv file for uploading products.
I have 100 images saved for different products in files.
I know I can go to each individual one and copy and paste the URL into my csv file.
I do not want to do that.
I know I can make a product listing, add 100 images to it, then export the product listing file onto a csv, then I would get the URL list of the 100. ( I am tyring that now but it is taking time
I do not want to do that.
I want to be able to grab the urls direct from the files folder and download into a csv..
Anyway to do that?
Thanks in advance.
Solved! Go to the solution
This is an accepted solution.
This is an accepted solution.
All good Jon, strangely I used that ext. for something else years ago.
To those who find it not working, log out of products or refresh the page before using the extension.
This is an accepted solution.
This is an accepted solution.
All good Jon, strangely I used that ext. for something else years ago.
To those who find it not working, log out of products or refresh the page before using the extension.
Glad it worked for you.
Great solution but this only allows 50 at a time even if i flick the switch inside the workshop for paged tables, has anyone else experienced this?
Andrew
@andrewralph In the table capture extension:
1 - Once you have selected the table on the 1st page (i.e. selected first n files)
2 - Set 'Dynamic Tables' to on
3 - Set 'Toggle Auto-Scrolling' to on
4 - Then click through the pages using the arrows at bottom of Files screen
5 - You should then see your Preview Data rows count go up accordingly
I didn't realize the "toggle auto scrolling" was a button to select....works perfectly! Exactly what i was looking for.
Thanks Jon
Good day,
I tried to upload a csv file with more than 700 products, i copied the URL with Table Capture as you explained. But when i upload the products not all of them get the image asigned.
I already checked some products URL's comparing the info from Shopify-Files with the URL from my excel and it is the same. For example:
From Shopify:
https://cdn.shopify.com/s/files/1/0258/6496/2099/files/TDDT.jpg?v=1589876090
From my excel:
https://cdn.shopify.com/s/files/1/0258/6496/2099/files/TDDT.jpg?v=1589876090 |
What could be the problem?
Thank you for your help.
@Aleon sounds like it's more of an issue with the CSV import process rather than the table capture download. The built in CSV import process can be a bit flakey. Only thing you could try is to use Excelify to do the products upload, there is a cost (you can uninstall it once finished with it) but it's a lot more reliable and powerful.
Other than that, try the native import again and see if it picks up the missing ones.
Good day,
I will try de addon, thank you.
Thanks JonWright!!!! This is awesome that you shared this free and super useful solution. I really appreciate it! Have an Awesome Day!
I don't know if this solution is still usable. The LINK URL table on the files page has been replaced with a button that copies to URL to your clipboard. Is there any way to revert it to the old layout?
I'm in the same hot water...I loved using table capture and now I'm screwed with the new button thing. Praying there is a work around. I contacted shopify today and they didn't have any answers for me.
Talked to the maker of the Table Capture (George) - he was awesome!! I emailed him and he met with me over zoom like the next day. So the current work around you can do is the following:
- open up the Table Capture
- select the pencil next to "settings" in the left corner
- check the "Extract image and icon attributes" box
- do the regular copy/paste in an excel/google sheet
- the url that will be copied is actually the thumbnail version of the main picture. BUT you can get the full one by doing a find & replace in excel (or google sheets) for "_60x60" and replace it with nothing. Basically taking out the "_60x60" will give you the image url to the full image.
BOOM. fixed. So help me, I hope shopify doesn't break it again. I was in full blown panic mode because I have thousands of photos to do.
Hi ..
This is exactly what I did earlier, and it worked for me
*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 🙂
We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024We want to take a moment to celebrate the incredible ways you all engage with the Shopi...
By JasonH Oct 15, 2024