Last post Sep 12, 2005 06:52 PM by benganeer1
Sep 12, 2005 06:52 PM|benganeer1|LINK
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
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,
Is there an easier way of doing this search without the manual data entry you know rolling the
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
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
fifth rolling digit and can be any number.
sixth rolling digit and can be any number.
seventh rolling digit and can be any letter or number.
eighth rolling digit and can be any letter or number.
ninth rolling digit and can be any letter or number.
changes to every tenth letter in table shown below.
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
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
“4” and so forth.
Please let me if
a macro or script can be written to cut down the manual data entry.