6910studio 0 Share Posted February 5 I am in the process of importing my products with the upload template CSV. I have all of my images hosted within our company Google drive, and have added the public share links to my CSV under "Hosted Image URLs." After importing, though, only a blank square with a grey diagonal slash is visible where an imported photo should be. My guess is this is because my URLs don't end in .jpeg, .png, etc. Is there a way to get a link to my images hosted in Drive so that I won't encounter this problem? Is there a different hosting service I should be using that will automatically generate a link with an image extension? Link to post
creedon 769 Share Posted February 5 Can you post a URL for one of these images? Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support! Link to post
6910studio 0 Author Share Posted February 5 https://drive.google.com/file/d/1JUg5lvcdLhuKhxhOKjvqtSGzB0JKRj8T Link to post
creedon 769 Share Posted February 5 Use the following URL structure. https://drive.google.com/uc?export=view&id=1JUg5lvcdLhuKhxhOKjvqtSGzB0JKRj8T Using search and replace change... file/d/ ...to... uc?export=view&id= Let us know how it goes. Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support! Link to post
DanielVanDenSchnurtz 0 Share Posted March 10 Amazing answer ! Would you have any advice for me? I have 100 JPG files and would like to get them automatically added to the CSV file for 100 distinct products, but don't know how do to that efficiently. Shall I copy them all to Google Drive? How would I then get their 100 distinct random URLs to shove them into the CSV? Link to post
creedon 769 Share Posted March 10 @DanielVanDenSchnurtz Please see the following. The main point is that unless your images are already hosted somewhere then it would probably be faster to do them manually. Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support! Link to post
DanielVanDenSchnurtz 0 Share Posted March 10 9 hours ago, creedon said: @DanielVanDenSchnurtz Please see the following. The main point is that unless your images are already hosted somewhere then it would probably be faster to do them manually. Thank you for your prompt answer ! There are hundreds of images, and manual import is not an option 🙂 Link to post
creedon 769 Share Posted March 10 @DanielVanDenSchnurtz Upload the files to Google Drive in a folder. There are probably limits to how much GD can handle at a time so you may want to upload in batches. Then go into the folder and select the files. Right click and click Share. In the Share dialog select Copy links. The links should now be on the clipboard. From there paste into a text editor to start manipulating the links. They will come over as a comma separated list. I don't know how many files you can do at once like this in GD. So you may want to work in batches at this step as well. Start of with something like 25 files. Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support! Link to post
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment