Category Lookup Information

This file will be updated when a new category structure has come into use. You can check the server modification time of this file to determine if you need to install a new category structure.

Position Column Column Type Description
1 site_id Integer, up to 9 digits Site ID
2 marketplace Integer, up to 9 digits Marketplace ID
3 category_ID Integer, up to 12 digits Unique identifier of the category
4 name String, up to 30 characters The name of the category
5 description String, up to 255 characters long Name of the category, with names off all categories up to the top level category
6 adult Single Character
  • 0: general audience
  • 1: adult audience
7 is_leaf Single character
  • 1 if this is a category with no children
  • 0 otherwise
8 is_expired Single character
  • 1 if the category is expired.
  • 0 otherwise
9 parent1_id Integer, up to 12 digits The ID of the level 1 category above the category referred to by the category_id column.
10 parent2_id Integer, up to 12 digits The ID of the level 2 category above the category referred to by the category_id column.
11 parent3_id Integer, up to 12 digits The ID of the level 3 category above the category referred to by the category_id column.
12 parent4_id Integer, up to 12 digits The ID of the level 4 category above the category referred to by the category_id column.
13 parent5_id Integer, up to 12 digits The ID of the level 5 category above the category referred to by the category_id column.
14 parent6_id Integer, up to 12 digits The ID of the level 6 category above the category referred to by the category_id column.
15 parent1_name String, up to 30 characters The name of the level 1 category above the category referred to by the category_id column.
16 parent2_name String, up to 30 characters The name of the level 2 category above the category referred to by the category_id column.
17 parent3_name String, up to 30 characters The name of the level 3category above the category referred to by the category_id column.
18 parent4_name String, up to 30 characters The name of the level 4 category above the category referred to by the category_id column.
19 parent5_name String, up to 30 characters The name of the level 5 category above the category referred to by the category_id column.
20 parent6_name String, up to 30 characters The name of the level 6 category above the category referred to by the category_id column.