Amazon MWS API Ranks

5/26/2017
Updated PriceCheck for Amazon MWS. Added Ranks column. Please refer to the sample output.csv file. PriceCheck has always had an output column called Rank which displays the high level Rank which is the one most people think of when they think of Amazon Rank. It is the one everyone is interested in and talks about.

Many times a product will have multiple Ranks. These additional Ranks aren't talked about as much, but they are still valuable and worth reviewing. For instance, Risky Business has the following Ranks,

  • #10,364 in Movies & TV
  • #762 in Movies & TV > DVD > Romance
  • #1626 in Movies & TV > DVD > Comedy
  • #2635 in Movies & TV > DVD > Drama
The main Rank plus all of these additional Ranks are placed in the new column called Ranks. The Ranks column for above looks like,
  • dvd_display_on_website:10364 2959109011:762 2959101011:1626 2959103011:2635
It is a paired list in the format category:rank category:rank category:rank ....
 

Typically, the first one is the high level Rank and is something like xxxx_display_on_website. The rest of the categories in the list are numbers instead of text. So, for above,

  • 2959109011 is the category "Movies & TV > DVD > Romance" and the Rank is 762
  • 2959101011 is the category "Movies & TV > DVD > Comedy" and the Rank is 1626
  • 2959103011 is the category "Movies & TV > DVD > Drama" and the Rank is 2635
Sometimes, the high level Rank is not returned from the API as expected. By separating out the Ranks into 2 columns and checking the data, PriceCheck ensures that the Rank is the high level Rank which everyone expects, and enables you to verify it against the list of all the Ranks. Plus you have the additional benefit of seeing all the other Ranks. See more details
 

For the software developers reading this, the Amazon MWS call to get the Rank information is GetMatchingProductForId and the snippet of the XML giving the information about Ranks is,
 
<SalesRankings>
<SalesRank>
<ProductCategoryId>dvd_display_on_website
</ProductCategoryId>
<Rank>10364
</Rank>
</SalesRank>
<SalesRank>
<ProductCategoryId>2959109011
</ProductCategoryId>
<Rank>7622
</Rank>
</SalesRank>
<SalesRank>
<ProductCategoryId>2959101011
</ProductCategoryId>
<Rank>1626
</Rank>
</SalesRank>
<SalesRank>
<ProductCategoryId>2959103011
</ProductCategoryId>
<Rank>2635
</Rank>
</SalesRank>
</SalesRankings>

Google