# Orders ## Documentation The orders of the shops of the sites. Holds the names, e-mail addresses and addresses of customers. Amounts are in the smallest unit of the currency, such as cents. 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 `Orders` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accepted_on` | `datetime` | | ☐ | When the order was placed, UTC. | | `billing_country` | `varchar2` | | ☐ | The country of the billing address. | | `comment` | `varchar2` | | ☐ | The comment of the shop on the order. | | `currency` | `varchar2` | | ☐ | The currency of the amounts, an ISO 4217 code. | | `customer_email` | `varchar2` | | ☐ | The e-mail address of the customer. | | `customer_full_name` | `varchar2` | | ☐ | The name of the customer. | | `customer_paid_value` | `decimal` | | ☐ | What the customer paid. | | `disputed_on` | `datetime` | | ☐ | When the order was disputed, UTC. | | `fulfilled_on` | `datetime` | | ☐ | When the order was fulfilled, UTC. | | `id` | `varchar2` | | ☑ | The id of the order, mostly 6 hexadecimal characters. | | `net_amount_value` | `decimal` | | ☐ | What is left after the application fee. | | `order_comment` | `varchar2` | | ☐ | The comment the customer left. | | `payment_processor` | `varchar2` | | ☐ | The payment processor, such as stripe or paypal. | | `purchased_items_count` | `decimal` | | ☐ | The number of items purchased. | | `refunded_on` | `datetime` | | ☐ | When the order was refunded, UTC. | | `shipping_city` | `varchar2` | | ☐ | The city of the shipping address. | | `shipping_country` | `varchar2` | | ☐ | The country of the shipping address. | | `shipping_postal_code` | `varchar2` | | ☐ | The postal code of the shipping address. | | `shipping_provider` | `varchar2` | | ☐ | The carrier, as the shop noted it. | | `shipping_tracking` | `varchar2` | | ☐ | The tracking number, as the shop noted it. | | `site_id` | `varchar2` | | ☑ | The site. | | `status` | `varchar2` | | ☐ | pending, unfulfilled, fulfilled, disputed, dispute-lost or refunded. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Ecommerce-OrderLines\|Ecommerce.OrderLines]] | `order_id` | Declared by the connector, not enforced by the platform |