# Products ## Documentation The products of the shops of the sites. A site without e-commerce reads no rows. - Catalog: `Webflow` - Schema: `Ecommerce` - Primary Keys: `id` This is a read-only table. The Webflow API may not support changing the data or the Invantive UniversalSQL driver for Webflow does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Webflow API. ## Table Columns The columns of the table `Products` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cms_locale_id` | `varchar2` | | ☐ | The locale of the product. | | `created_on` | `datetime` | | ☐ | When the product was created, UTC. | | `default_sku_id` | `varchar2` | | ☐ | The SKU shown first. | | `description` | `varchar2` | | ☐ | The description of the product. | | `field_data_json` | `varchar2` | | ☐ | Every field of the product as JSON. | | `id` | `varchar2` | | ☑ | The id of the product. | | `is_archived` | `char` | | ☐ | Whether the product is archived. | | `is_draft` | `char` | | ☐ | Whether the product is a draft. | | `last_published` | `datetime` | | ☐ | When the product was last published, UTC. | | `last_updated` | `datetime` | | ☐ | When the product was last changed, UTC. | | `name` | `varchar2` | | ☐ | The name of the product. | | `shippable` | `char` | | ☐ | Whether the product is shipped. | | `site_id` | `varchar2` | | ☑ | The site. | | `slug` | `varchar2` | | ☐ | The slug of the product in its address. | | `tax_category` | `varchar2` | | ☐ | The tax category, such as standard-taxable. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `default_sku_id` | [[Ecommerce-ProductSkus\|Ecommerce.ProductSkus]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Ecommerce-OrderLines\|Ecommerce.OrderLines]] | `product_id` | Declared by the connector, not enforced by the platform | | [[Ecommerce-ProductSkus\|Ecommerce.ProductSkus]] | `product_id` | Declared by the connector, not enforced by the platform |