Scraping Amazon Sellers


#21

Yes, I understand that. The formula I'm using only returns one email. You may have used the Dump() formula which returns several matches if exists.


#22

Ahh yes. That´s right, thanks.
Sorry for the newbie questions


#23

I saw that the fields are in different places on any profile.

Is is it possible to extract somehow the data after "Unternehmensvertreter:" and "Ustid:" (field names are always in bold)


#24

I'm kind of hesitant to suggest these custom Xpaths given that they stopped working earlier. But anyway:

=XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'Unternehmensvertreter:')]]/text()")

=Dump(XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'UStID:')]]/text()"))


#25

does not work, but thanks!


#26

@dovydasm Maybe you have a solution for this one?
Thanks !


#27

The invalid formulas was because of bad character formatting when pasting to from Excel. This one should work:

=Dump(XPathOnUrl(A1;"//span[@class='a-list-item'][descendant::span[contains(text(),'UStID:')]]/text()"))


#28

Very nice ! Thanks !
Can you tell me why I cant get "Unternehmensvertreter" In this one? I guess it´s because its in a different place. But is there a simple solution?


#29

Hello there! It seems like some of you were already active in scraping Amazon seller lists quite some time ago. Does any of you have them still on their discs? I'd be interested in these lists even if they are outdated.
Ideally, these lists would be from Amazon.de, but lists from other marketplaces would be interesting as well. Just send me an email to quark@arcor.de. Looking forward to hearing from you :slight_smile:


#30

I just downloaded the plugin, but I'm having issues returning the ranking of my store's ASIN #'s vs the amazon search ranking for specific keywords. Can someone please help?


#31

Hi MCS, answered your PM :slight_smile:


#32

Which data do you need ?


#33

Which Plugin is this ?


#35

Nathan Grimm created this worksheet using the SEO tools plugin, but I'm not able to replicate it, so I'm not sure what tool he used >>>>>
http://www.dnaresponse.com/amazon-rankings-tracking-excel/

Unfortunately, I can't get my EIN's to return ranking results from the worksheet he created - Can you help?