# Products: ActiveCampaign Products ## Documentation Products imported into ActiveCampaign - Catalog: `ActiveCampaign` - Schema: `CustomObjects` - Primary Keys: `id` - Label: Products - Retrieve: True - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `Products` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `attributes` | `varchar2` | Attributes | ☐ | Attributes | | `average_rating` | `varchar2` | Average Rating | ☐ | DEPRECATED! | | `average_ratings` | `decimal` | Average Ratings | ☐ | Average Rating | | `base_product_description` | `varchar2` | Base Product Description | ☐ | FIELD_BASE_PRODUCT_DESCRIPTION | | `base_product_dimensions` | `varchar2` | Base Product Dimensions | ☐ | Base product dimensions | | `base_product_images` | `varchar2` | Base Product Images | ☐ | Base product images | | `base_product_name` | `varchar2` | Base Product Name | ☐ | Base Product Name | | `base_product_store_created_date` | `datetime` | Base Product Store Created Date | ☐ | Created date for base product in store | | `base_product_store_modified_date` | `datetime` | Base Product Store Modified Date | ☐ | Modified date for base product in store | | `base_product_url_slug` | `varchar2` | Base Product URL Slug | ☐ | Base product URL slugs | | `base_product_url` | `varchar2` | Base Product URL | ☐ | Base product URL | | `base_product_weight` | `decimal` | Base Product Weight | ☐ | Base product weight | | `brand` | `varchar2` | Brand | ☐ | Brand | | `categories` | `varchar2` | Categories | ☐ | Categories | | `condition` | `varchar2` | Condition | ☐ | Condition | | `connection_id` | `varchar2` | Connection ID | ☐ | Connection ID | | `createdTimestamp` | `datetime` | Created | ☐ | Moment of creation. | | `dimensions_unit` | `varchar2` | Dimensions Unit | ☐ | Unit for dimensions | | `id` | `varchar2` | ID | ☑ | Unique ID of the record, in the form of a GUID. | | `inventory_quantity` | `int64` | Inventory Quantity | ☐ | Inventory Quantity | | `is_backorders_allowed` | `varchar2` | Is Backorders Allowed | ☐ | Are backorders allowed | | `is_deleted` | `varchar2` | Is Deleted | ☐ | Is deleted | | `is_downloadable` | `varchar2` | Is Downloadable | ☐ | Is downloadable | | `is_on_sale` | `varchar2` | Is on Sale | ☐ | Is on sale | | `is_virtual` | `varchar2` | Is Virtual | ☐ | Is virtual | | `is_visible` | `varchar2` | Is Visible | ☐ | Is visible | | `legacy_connection_id` | `int64` | Legacy Connection ID | ☐ | Legacy Connection ID | | `number_of_sales` | `int64` | Number of Sales | ☐ | Number of sales | | `rating_count` | `int64` | Rating Count | ☐ | Rating Count | | `schemaId` | `varchar2` | Schema ID | ☐ | Unique ID of the custom object the record belongs to. | | `search_keywords` | `varchar2` | Search Keywords | ☐ | Search keywords | | `status` | `varchar2` | Status | ☐ | Status | | `stock_status` | `varchar2` | Stock Status | ☐ | Stock status | | `store_base_product_id` | `varchar2` | Store Base Product ID | ☐ | Store Parent ID | | `store_primary_id` | `varchar2` | Store Primary ID | ☐ | Store variant ID | | `store_variant_id` | `varchar2` | Store Variant ID | ☐ | Deprecated | | `tags` | `varchar2` | Tags | ☐ | Tags | | `type` | `varchar2` | Type | ☐ | Type | | `upc` | `varchar2` | UPC | ☐ | UPC | | `updatedTimestamp` | `datetime` | Last Modified | ☐ | Moment of last change. | | `variant_description` | `varchar2` | Variant Description | ☐ | Variant description | | `variant_dimensions` | `varchar2` | Variant Dimensions | ☐ | Variant Dimension | | `variant_images` | `varchar2` | Variant Images | ☐ | Variant Image | | `variant_name` | `varchar2` | Variant Name | ☐ | Variant name | | `variant_price_amount` | `varchar2` | Variant Price Amount | ☐ | Variant price amount (deprecated field) | | `variant_price_amounts` | `varchar2` | Variant Price Amounts | ☐ | Variant price (Deprecated Field) | | `variant_price_currency_code` | `varchar2` | Variant Price Currency Code | ☐ | Currency of the amount in column variant_price. | | `variant_price_currency` | `varchar2` | Variant Price Currency | ☐ | Variant price currency | | `variant_price` | `decimal` | Variant Price | ☐ | Variant price | | `variant_sku` | `varchar2` | Variant SKU | ☐ | Variant sku | | `variant_store_created_date` | `datetime` | Variant Store Created Date | ☐ | Variant store created date | | `variant_store_modified_date` | `datetime` | Variant Store Modified Date | ☐ | Variant store modified date | | `variant_url_slug` | `varchar2` | Variant URL Slug | ☐ | Variant URL slug | | `variant_url` | `varchar2` | Variant URL | ☐ | Variant URL | | `variant_weight` | `decimal` | Variant Weight | ☐ | Variant weight | | `view_count` | `int64` | View Count | ☐ | View count |