Others
Account
Table: account
Column Name | Data type | Description |
---|---|---|
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
Column Name | Data type | Description |
---|---|---|
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
Column Name | Data type | Description |
---|---|---|
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
Column Name | Data Type | Description |
---|---|---|
id | Integer | Unique Identfier |
variant | string | Variant of the image, such as |
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 |
Last updated