Amazon Best Seller Rank

Support
#1

I am trying to scrape the Amazon "Best Sellers Rank" value from a list of ASIN's

I use the following, which for some amazon.com URLs work fine, but sometimes it does not, I also try on .co.uk and .de like below, with no results. It's the same path.
I have set my User-agent to my browser so it should return the identical results looking at developer tools on Edge/Chrome.

d9=https://www.amazon.de/dp/B07STZ7N9Y/

e9=//*[@id="productDetails_detailBullets_sections1"]/tbody/tr[3]/td/span/span[2]/text()

=XPathOnUrl(D9,E9)

I don't understand when I can get results fine on one page but not on another, or in the case of some shops (.ca, .de,.co.uk) no results at all, just nothing returned.

Is there a way to look at the full returned HTML from a XPathOnUrl search?

#2

You could add the "html" to the final XPathOnUrl formula argument, and use "//*" as the XPath:

=XPathOnUrl("https://seotoolsforexcel.com";"//*";;;"html")

#3

Amazon has anti scrape measures which you might run into if you're doing a lot of asins. Try =GetTextOnUrl() on the blank results to see.

#4

Thanks,
I can see amazon is returning a script I guess to stop scrapping. time to learn how to implement the SP-API in excel :frowning:

#5

Or use keepa.com