Grabbing Image Url

**deadmanramsey** · 03-25-2014, 10:12 AM

So I guess the question is, is there some sort of constant that can be predicted for each product image? What I am trying to do is have the image url inserted into the spreadsheet, which can then import the image onto a website once the excel file is uploaded. I tried the following url which didn't work :

http://www.amazon.com/gp/product/images/B0014WAAE4

The actual url that would work is :

http://ecx.images-amazon.com/images/...VL._SS500_.jpg

I just don't know how the two can be associated and integrated into some sort of formula. I'm really not that familiar with this type of stuff on Excel : (

**Ron Coderre** · 03-25-2014, 10:20 AM

The short answer is: They can't.
The image url is:

http://ecx.images-amazon.com/images/I/51XywMcPdVL._SS500_.jpg

Amazon has millions of images in its libraries and its web pages are built dynamically when accessed. As with most databases, objects are identified by unique identifiers. Descriptive names are associated with them when implemented on the web page. Consequently, you'd need to know the image name before you can try to download it.