Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Where to host images so that share link has a valid image extension? CSV Product Import


Recommended Posts

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 comment
  • Replies 12
  • Created
  • Last Reply

Top Posters In This Topic

  • 1 month later...

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 comment

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

1204516632_ScreenShot2021-03-10at12_07_49PM.png.de101c627c95672ffd99841fec2d6c1b.png

In the Share dialog click Change .

116000141_ScreenShot2021-06-10at9_44_34AM.png.50e7b849a32b5ce697eccce805bc165b.png

Set all the links to share with anyone, click Copy links, and Done.

160507280_ScreenShot2021-06-10at9_46_58AM.png.04ad93285b54b97d0fdbde1fcf19e299.png

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.

Edited by creedon

Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support!

Link to comment
  • 2 months later...

@babrsome

It looks like it might be a CORS issue. I just tested trying to load a glb from Google Drive and got the following.

137224457_ScreenShot2021-06-15at5_10_50PM.thumb.png.f826277e4f6423dbb242c5bc6e4ae04b.png

Digging a little deeper it appears that Google is redirecting some or all drive url requests to another server. Apparently CORS is not robust enough to deal with the redirect down the line. It's interesting as the first server indeed is not set up to allow all comers as far as CORS is concerned. The second server is set up to handle all comers per CORS.

I don't have a solid handle on all the ins and outs of this mess so take everything with a grain of salt.

You'll need to find another server/service that doesn't have an issue. Dropbox perhaps? I did test Amazon S3 and was able to get a test file to work there after setting a CORS policy. But that is not on most people's list of go to file server, services. S3 is for the very technically inclined but it works great when configured properly! 🙂

Find my contributions useful? Please like, upvote, mark my answer as best , and see my profile. Thanks for your support!

Link to comment
  • 3 months later...
On 6/16/2021 at 3:44 AM, creedon said:

@babrsome

It looks like it might be a CORS issue. I just tested trying to load a glb from Google Drive and got the following.

137224457_ScreenShot2021-06-15at5_10_50PM.thumb.png.f826277e4f6423dbb242c5bc6e4ae04b.png

Digging a little deeper it appears that Google is redirecting some or all drive url requests to another server. Apparently CORS is not robust enough to deal with the redirect down the line. It's interesting as the first server indeed is not set up to allow all comers as far as CORS is concerned. The second server is set up to handle all comers per CORS.

I don't have a solid handle on all the ins and outs of this mess so take everything with a grain of salt.

You'll need to find another server/service that doesn't have an issue. Dropbox perhaps? I did test Amazon S3 and was able to get a test file to work there after setting a CORS policy. But that is not on most people's list of go to file server, services. S3 is for the very technically inclined but it works great when configured properly! 🙂

Thanks for the diagnostics !! Will leave Google Drive then :-). A nice loss to experience.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...