Others
Account
Table: account
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
organization_name
String
Organization name used within the intentwise
amazon_profile_id
Integer
Unique amazon Identifier for sellers and vendors referenced by APIs
region
String
Account region
country_code
String
Country code of the account
currency_code
String
Currency Code of the account
market_place
String
Market place of the account
brand_id
String
Identifier for sellers and vendors. Note that this value is not unique and maybe the same across the marketplace.
brand_type
String
The SELLER and VENDOR account types are associated with Sponsored Ads APIs. The AGENCY account type is associated with DSP
vendor_name
String
Account name used within the amazon console
Catalog Master
Table: catalog_master
Note: This table should be used in conjunction with catalog_item_summary. Use ctlg_master_id as the join condition
ctlg_master_id
Integer
Unique Identifier
asin
String
Amazon ASIN
account_id
Integer
Intentwise Account Identifier
account_name
String
Intentwise Account Name
Catalog Item Summary
Table: catalog_item_summary
id
Integer
Unique Identfier
brand_name
String
Name of the brand associated with an Amazon catalog item
browse_node
String
Classification (browse node) associated with an Amazon catalog item.
color_name
String
Name of the color associated with an Amazon catalog item.
item_name
String
Name, or title, associated with an Amazon catalog item.
manufacturer
String
Name of the manufacturer associated with an Amazon catalog item.
model_number
String
Model number associated with an Amazon catalog item.
size_name
String
Name of the size associated with an Amazon catalog item.
style_name
String
Name of the style associated with an Amazon catalog item.
ctlg_master_id
Integer
Key to join with catalog_master table
account_id
Integer
Intentwise account identifier
Catalog Item Images
Table: catalog_item_images
Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition
id
Integer
Unique Identfier
variant
string
Variant of the image, such as MAIN or PT01
link
String
Link, or URL, for the image.
height
Integer
Height of the image in pixels.
width
Integer
Width of the image in pixels.
ctlg_master_id
Integer
Key to join with catalog_master table
account_id
Integer
Intentwise account identifier
Catalog Item Dimension
Table: catalog_item_dimension
Dimensions associated with the item in the Amazon catalog
Note: This table has to be used in conjunction with catalog_master. Use ctlg_master_id as the join condition
item_height_value
Numeric
Height of an item
item_height_unit
String
Measurement unit of the dimension value.
item_length_value
Numeric
Length of an item
item_length_unit
String
Measurement unit of the dimension value.
item_weight_value
Numeric
Weight of an item
item_weight_unit
String
Measurement unit of the dimension value.
item_width_value
Numeric
Width of an item
item_width_unit
String
Measurement unit of the dimension value.
package_height_value
Numeric
Height of an package
package_height_unit
String
Measurement unit of the dimension value.
package_length_value
Numeric
Length of an package
package_length_unit
String
Measurement unit of the dimension value.
package_weight_value
Numeric
Weight of an package
package_weight_unit
String
Measurement unit of the dimension value.
package_width_value
Numeric
Width of an package
package_width_unit
String
Measurement unit of the dimension value.
ctlg_master_id
Integer
Key to join with catalog_master table
account_id
Integer
Intentwise account identifier
Catalog Item Vendor Detail
Table: catalog_item_vendor_detail
Vendor details associated with an Amazon catalog item. Vendor details are available to vendors only.
Note: This table has to be used in conjunction with catalog_master. Use ctlg_master_id as the join condition
brand_code
String
Brand code associated with an Amazon catalog item.
manufacturer_code
String
Manufacturer code associated with an Amazon catalog item.
manufacturer_code_parent
String
Parent vendor code of the manufacturer code.
product_group
String
Product group associated with an Amazon catalog item.
ctlg_master_id
Integer
Key to join with catalog_master table
product_category_display_name
String
Display name of the product category
product_category_value
String
Value (code) of the product category
product_sub_category_display_name
String
Display name of the product subcategory
product_sub_category_value
String
Value (code) of the subcategory.
replenishment_category
String
Replenishment category associated with an Amazon catalog item.
account_id
Integer
Intentwise account identifier
Last updated