This database represents complete categories trees of Amazon websites.
All the data is obtained by native BrowseNodes calls of Amazon Product Advertising API. 49,762 nodes, July 22, 2017 Free Demo Order $49 / Update $19 42,013 nodes, July 23, 2017 Free Demo Order $49 / Update $19 60,618 nodes, July 24, 2017 Free Demo Order $49 / Update $19 44,403 nodes, July 25, 2017 Free Demo Order $49 / Update $19 26,391 nodes, July 26, 2017 Free Demo Order $49 / Update $19 30,637 nodes, July 26, 2017 Free Demo Order $49 / Update $19 24,865 nodes, July 28, 2017 Free Demo Order $49 / Update $19 8,494 nodes, July 26, 2017 Free Demo Order $49 / Update $19 4,907 nodes, July 27, 2017 Free Demo Order $49 / Update $19 12,141 nodes, July 27, 2017 Free Demo Order $49 / Update $19
What data does Amazon Nodes contain?
Amazon Nodes database contains the following fields:

level Level of the node in the hierarchy.
node Node identifier.
name Name of node.
parent Parent node identifier.
parents List of parent nodes in node=name expressions separated by semicolons
ancestors List of parent nodes in the primary hierarchy.
isroot Reserved for future use.
childrencount Children count of the node.
searchindex Search index value for ItemSearch operation of Amazon's Product Advertising API.

What data formats are available?
Database contains the following files (* is replaced by the marketplace domain):

*.data.csv Database in canonical CSV format (tested and compatible with MySQL):
"1","3737671","Air Conditioners & Accessories","2619526011","2619526011=Appliances","-1063498=Categories;1055398=Home & Kitchen","0","3"
"2","14554126011","Air Conditioners","3737671","3737671=Air Conditioners & Accessories;2619526011=Appliances","3206324011=Heating, Cooling & Air Quality;-1063498=Categories;1055398=Home & Kitchen","0","5"
*.data.txt Database in alternative format with values, separated by vertical bar:
1|3737671|Air Conditioners & Accessories|2619526011|2619526011=Appliances|-1063498=Categories;1055398=Home & Kitchen|0|3
2|14554126011|Air Conditioners|3737671|3737671=Air Conditioners & Accessories;2619526011=Appliances|3206324011=Heating, Cooling & Air Quality;-1063498=Categories;1055398=Home & Kitchen|0|5
*.tree.txt Structure of categories' tree represented by the name field in tabbed text format:
	Air Conditioners & Accessories
		Air Conditioners

Something else?
Yes. Database set contains additional *.locale.csv table with complete locale data from Locale Reference for the Product Advertising API. This table can be linked with main data using the searchindex field to create correct queries to the Product Advertising API.
How can I test the Amazon Nodes before order?
Just click the "Free Demo" button and download truncated trial data.
Are there examples of using?
Yes, the following website was created with Amazon Nodes database:

Comments? Questions? Suggestions?
Please do not hesitate to contact us: