# eComOrderProducts: ActiveCampaign eCommerce Order Products - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: eCommerce Order Products Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `eComOrderProducts` 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 and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `category` | `varchar2` | Category | ☑ | | | `connectionid` | `int64` | Connection ID | ☑ | | | `createdDate` | `datetime` | Created | ☑ | | | `description` | `varchar2` | Description | ☐ | | | `ecomOrder` | `int64` | eCommerce Order | ☑ | | | `externalid` | `varchar2` | External ID | ☐ | | | `id` | `int64` | ID | ☑ | | | `imageUrl` | `varchar2` | Image (URL) | ☐ | | | `name` | `varchar2` | Name | ☑ | | | `orderid` | `int64` | Order ID | ☑ | | | `price` | `int64` | Price | ☑ | Unit price in smallest unit, typically cents. | | `productUrl` | `varchar2` | Product URL | ☐ | Link to the product on the store. | | `quantity` | `int64` | Quantity | ☑ | | | `sku` | `varchar2` | SKU | ☐ | | | `tstamp` | `datetime` | | ☑ | | | `updatedDate` | `datetime` | Last Updated | ☑ | |