## 0 replies

Last post Sep 12, 2005 06:52 PM by benganeer1

None

0 Points

1 Post

### Amazon ASIN

How could I find an ASIN that is not searchable, but, is stored on their servers? For instance, if you search for something on Amazon in their search function let’s say “MLB 13”, three of the 5 items will be found, but, I was able to figure out that if you roll the fifth, sixth seventh, eighth and ninth digits and change the last digit of the ASIN to every tenth letter in the URL you can find the other 2 of the 5 items that were not found using their search function based on the ASIN of three that were found using their search function and here is the URL for those items, http://www.amazon.com/exec/obidos/tg/detail/-/B00080M5T6 and

http://www.amazon.com/exec/obidos/tg/detail/-/B00080M5UA

Is there an easier way of doing this search without the manual data entry you know rolling the fifth, sixth, seventh, eighth and ninth digits and changing the last digit of the ASIN to every tenth letter, can a macro be written to shorten the search time and find the items on their servers that cannot be found using their search function? If you don’t know what I mean by rolling the fifth, sixth, seventh, eighth and ninth digits and changing the last digit of the ASIN to every tenth letter, here is an explanation below with a table I use to do it manually, let’s use one of the previous ASIN as an example of what I mean only the last 6 digits in an ASIN change up to a certain point of the Base ASIN number.

B000 = Base ASIN

8 = fifth rolling digit and can be any number.

0 = sixth rolling digit and can be any number.

M = seventh rolling digit and can be any letter or number.

5 = eighth rolling digit and can be any letter or number.

U = ninth rolling digit and can be any letter or number.

A = changes to every tenth letter in table shown below.

TABLE

0     1     2     3     4     5      6     7      8      9

A    B     C    D     E    F      G    H      I       J

K    L     M    N     O    P     Q     R     S      T

U    V    W    X     Y    Z

If we put those numbers above together, we get B00080M5UA and then we add this number to the end of the following URL

we get http://www.amazon.com/exec/obidos/tg/detail/-/B00080M5UA, but to find the next item on the Amazon using the URL we would remove the “A” at the end and add “K” to the end and you find the next item, remove the “K” and add a “U” at the end you find the next item and then to find the next item and since the last ASIN we looked up was B00080M5UU that you have to change the ninth digit from a “U” to a “V” and following the process to change the last digit to every tenth number or letter in the table the tenth digit changes from “U” to “4” and so forth.

Please let me if a macro or script can be written to cut down the manual data entry.

Thanks,

Larry Abshire