I want to set up a programme (Windows XP compatible).
It will import an excel spread sheet containing an asin or barcode (ean upc) number. And our internal Tag.
Field 1 will be the ASIN
Field 2 will be UPC OR EAN
Field 3 will be our tag
If Field 1 is filled it will go to [login to view URL] (german site) and scrape from their listings and insert in.
Field 4 will be (Amazon German Title ) (heading = Title)
Field 5 will be (Von Manufacturer) (heading = Manufacturer)
Field 6 will be for (**Modellnummer:**) (heading = part number)
If field 2 is filled it will also add:
Field 7 (German Asin)
So if you input on german site as an example B000BC8VSU (an asin)
it will fill in:
Field 4 Lexmark C530, C530dn R?ckgabe-Tonerkassette Gelb, 1.500Seiten
Field 5 Lexmark
Field 6 C5220YS
BUT if I input on german site as an example 0734646039482 (UPC)
it will fill in:
also
Field 7 B000BC8VSU
If you search that UPC you in fact will get several results in which case it will need to insert a new row and repeat the field for the extra results.
It will then go to [login to view URL] and scrape the same information.
Filed 8 9 10 and if required 11 (with multiple results being possible)