# ProductSkus ## Documentation The SKUs, the variants that are sold, of the products, from the same answer as the products. - 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 `ProductSkus` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cms_locale_id` | `varchar2` | | ☐ | The locale of the SKU. | | `created_on` | `datetime` | | ☐ | When the SKU was created, UTC. | | `field_data_json` | `varchar2` | | ☐ | Every field of the SKU as JSON. | | `id` | `varchar2` | | ☑ | The id of the SKU. | | `last_updated` | `datetime` | | ☐ | When the SKU was last changed, UTC. | | `name` | `varchar2` | | ☐ | The name of the SKU. | | `price_unit` | `varchar2` | | ☐ | The currency of the price, an ISO 4217 code. | | `price_value` | `decimal` | | ☐ | The price in the smallest unit of the currency, such as cents. | | `product_id` | `varchar2` | | ☑ | The product. | | `site_id` | `varchar2` | | ☑ | The site. | | `sku` | `varchar2` | | ☐ | The code of the SKU the shop chose. | | `slug` | `varchar2` | | ☐ | The slug of the SKU. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `product_id` | [[Ecommerce-Products\|Ecommerce.Products]] | `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]] | `sku_id` | Declared by the connector, not enforced by the platform | | [[Ecommerce-Products\|Ecommerce.Products]] | `default_sku_id` | Declared by the connector, not enforced by the platform |