Get ASINs from Amazon (.de)

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!

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/

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

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!

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?