Get ASINs from Amazon (.de)

#1

Hello,
I am looking for a way to look up EANs and get back the ASIN and more information about the product in amazon catalog.
I didn't manage to get this running with the Amazon connector (Amazon.xml). I enabled debugging, it seems like reviews is only working for amazon.com and search doens't work at all?!

Request url: http://www.amazon.de/s?url=search-alias=aps&field-keywords=football&page=1&sort=price-asc-rank

Response:

<Parse>
  <XPath Expr="//div[contains(@@class,'s-result-list')]//h5/a[contains(@@href,'qid=')][not(contains(@@href,'offer-listing'))]">
    <Compute Id="Url" Title="URL">
      <Compute.Expr><![CDATA[
						https://www.amazon.com@(Utils.HtmlDecode(Model.Inp))
            ]]></Compute.Expr>
      <XPath Expr="." Id="Inp" Attribute="href" />
    </Compute>
    <XPath Expr="." Id="Title" Title="Title" />
  </XPath>
  <XPath Expr="//div[@@data-asin][descendant::h5/a[contains(@@href,'qid=')][not(contains(@@href,'offer-listing'))]]">
    <XPath Expr="." Id="Asin" Title="ASIN" Attribute="data-asin" />
    <XPath Expr=".//span[@@class='a-price'][1]/span" Id="LowestPrice" Title="Lowest Price" Converter="Auto" DefaultValue="" />
    <XPath Expr=".//a[contains(@@href,'customerReviews')]" Id="Reviews" Title="Reviews" Converter="Int" DefaultValue="0" />
    <Compute Id="AverageReview" Title="Average Score" Converter="Double" DefaultValue="0">
      <Compute.Expr><![CDATA[
						@{
							string output = (Model.Inp is string && Model.Inp.Contains("out")) ?
								Model.Inp.Substring(0, Model.Inp.IndexOf("out")) : "0";
						}
						@output
            ]]></Compute.Expr>
      <XPath Id="Inp" Expr=".//i[contains(@@class,'a-icon a-icon-star')]" Converter="String" DefaultValue="" />
    </Compute>
    <XPath Expr=".//a[contains(@@href,'offer-listing')]/text()" Id="Offers" Title="Offers" Converter="Int" DefaultValue="0" />
    <XPath Expr=".//img[contains(@@src,'media-amazon')]" Attribute="src" Id="Thumbnail" Title="Thumbnail" DefaultValue="" />
  </XPath>
</Parse>

-> No results in Excel.

However, is there another good and easy way to do it? Some XPathOnUrl?

Thanks!

#2

Hi, will look into your original question.

In the meantime, I've updated the Amazon connector so it should be working now. You can get the latest version from the Manager:
https://seotoolsforexcel.com/manage-connectors/

#3

Hi, I updated the Amazon connector and it's working fine now. Thank you!

#4

Hello again,

I am having problems looking up a few EANs on amazon .de using a formula.
Formula I am using:

=Dump(Connector("Amazon.Search";Tabelle1!A3;"amazon.de";"aps";"relevanceblender";0;"Url,Title,Asin,LowestPrice,Reviews,AverageReview,Offers,Thumbnail";WAHR;15))

It seems to be working for some cells, but not for all cells in a row. Formula sometimes returns a blank cell (but in some cells it is working and all EANs can be found in amazon catalog). After reloading the formula in a blank cell several times, it returns the correct information.

Is there some kind of throttling? I used different values for "delay" but it didn't help.

EANs I am using for amazon .de:

4039784538115
4039784725355
4039784725379
4039784725386
4039784725393
4039784725423
4039784714953
4039784727267
4039784727274
4039784727281
4039784727298
4039784727311

Thank you in advance!

#5

Hi,

I had no idea it was possible to search with EAN inputs :slight_smile: Based on your description, it sounds like a throttling issue. Perhaps proxies would be an alternative?