Amazon Categories is a database set that represents complete categories trees of Amazon's sites.

Amazon site Nodes Trial Order
amazon.com Amazon.com 50,864 Free $49
amazon.ca Amazon.ca 53,030 Free $49
amazon.co.uk Amazon.co.uk 35,926 Free $49
amazon.fr Amazon.fr 32,558 Free $49
amazon.de Amazon.de 41,799 Free $49
amazon.nl Amazon.nl 622 Free $49
amazon.it Amazon.it 26,694 Free $49
amazon.es Amazon.es 26,790 Free $49
amazon.com.au Amazon.com.au 3,133 Free $49
amazon.com.br Amazon.com.br 5,197 Free $49
amazon.co.jp Amazon.co.jp 22,781 Free $49
amazon.cn Amazon.cn 16,329 Free $49
amazon.in Amazon.in 8,066 Free $49
amazon.com.mx Amazon.com.mx 16,666 Free $49
All these databases $686  $249!
What data does Amazon Categories contain?
Amazon Categories database contains the following fields:

parentid ID of parent node, contains "0" for the top-level nodes.
id ID of current node. Top-level node ID is just a name of top category ("appliances", "mobile-apps"), all other nodes' IDs contain name of top category and some unique digital code, separated by slash ("appliances/3741261", "mobile-apps/2478834011").
category Name of top category that contains the node ("appliances", "mobile-apps").
node Unique digital identifier of the node ("3741261", "2478834011").
name Name of node used in the navigation from left sidebar of Amazon's website ("Books & Comics").
urlname* Name of node used in the URL of the node's page ("Appstore-Android-Book-Comic-Apps").
longname Name of node used in the node's page title ("Book & Comic Apps").

* urlname field is applicable to some English-language Amazon's stores only
What data formats are available?
Database contains the following files:

data.csv Database in canonical CSV format (tested and compatible with MySQL):
parentid,id,category,node,name,urlname,longname
"0","appliances","appliances","0","Appliances","Appliances","Appliances"
"appliances","appliances/3741261","appliances","3741261","Cooktops","Appliances-Cooktops","Cooktops"
"appliances","appliances/3741271","appliances","3741271","Dishwashers","Appliances-Dishwashers","Dishwashers"
...
data.txt Database in alternative format with values, separated by vertical bar:
parentid|id|category|node|name|urlname|longname
0|appliances|appliances|0|Appliances|Appliances|Appliances
appliances|appliances/3741261|appliances|3741261|Cooktops|Appliances-Cooktops|Cooktops
appliances|appliances/3741271|appliances|3741271|Dishwashers|Appliances-Dishwashers|Dishwashers
...
magento2.csv Database in Magento2 format (beta version):
"rootid","store","category_id","name","categories","level","position","description","url_key","is_active","display_mode","page_layout","cms_block","is_anchor","meta_title","meta_keywords","meta_description","category_image","include_in_menu","custom_layout_update","custom_design","custom_use_parent_settings","custom_apply_to_products","category_products"
"2","default","25","Appliances","Appliances","2","2","","Appliances","1","PRODUCTS","","","","Appliances","appliances","","","1","","","0","0",""
"2","default","26","Cooktops","Appliances/Cooktops","3","1","","Appliances-Cooktops","1","PRODUCTS","","","","Cooktops","appliances cooktops","","","1","","","0","0",""
"2","default","27","Dishwashers","Appliances/Dishwashers","3","2","","Appliances-Dishwashers","1","PRODUCTS","","","","Dishwashers","appliances dishwashers","","","1","","","0","0",""
...
tree.txt Structure of categories' tree represented by the name field in tabbed text format:
Appliances
	Cooktops
	Dishwashers
...
links.txt Links formats that can be built with Amazon Categories data.

How Amazon Categories database can be used?
Using data from Amazon Categories database you can build links to:
  • ...page of any category on Amazon's website
  • ...any rating page (Best Sellers, Hot New Releases, Movers & Shakers, Top Rated, Most Wished For and Gift Ideas, if these categories are presented on the Amazon's website) for any category
  • ...RSS feed of any rating page for any category
All the possible links formats are described in the links.txt file.
Something new?
Yes, database in Magento2 format is added.
Are there examples of using?
Yes, the following websites were created with Amazon Categories Database:

Comments? Questions? Suggestions?
Please do not hesitate to contact us: contact@blinmedia.com.