Orders
Collection of placed orders
Fields
| Field alias | Description | Data type | Editable |
|---|---|---|---|
| canWrite | write permission | boolean | |
| carrierId | carrier id | number | |
| cartId | cart id | number | |
| conversionRate | conversion rate | number | |
| created | date created | datetime | |
| currencyId | currency id | number | |
| customer | customer | string | |
| customerId | customer id | number | |
| deliveryAddressId | delivery address id | number | |
| deliveryDate | delivery date | datetime | |
| deliveryNumber | delivery number | number | |
| description | order description | string | |
| gift | gift wrapping | boolean | yes |
| giftMessage | gift message | string | yes |
| id | id | number | |
| invoiceAddressId | invoice address id | number | |
| invoiceDate | invoice date | datetime | |
| invoiceNumber | invoice number | number | |
| payment | payment type | string | yes |
| recyclable | use recycled packaging | boolean | yes |
| reference | reference | string | yes |
| secureKey | secure key | string | yes |
| shop | shop | string | |
| shopId | shop id | number | |
| status | status | string | |
| statusId | current status id | number | yes |
| total | total | currency | |
| totalDiscounts | total discounts | currency | |
| totalDiscountsWithoutTax | total discounts tax excl. | currency | |
| totalPaid | total paid | currency | |
| totalProducts | total products | currency | |
| totalProductsWithoutTax | total products tax excl. | currency | |
| totalShipping | total shipping | currency | |
| totalShippingWithoutTax | total shipping tax excl. | currency | |
| totalWithoutTax | total tax excl. | currency | |
| totalWrapping | total wrapping | currency | |
| totalWrappingWithoutTax | total wrapping tax excl. | currency | |
| trackingNumber | tracking number | string | yes |
| updated | date updated | datetime | |
| validated | is validated | boolean | yes |
Common expressions
| Expression | Description | Data type |
|---|---|---|
| order.deliveryAddressId = order.invoiceAddressId | same invoice and delivery address | boolean |
| toCurrency(toNumber(order.total) / order.conversionRate, <param:defaultCurrency>) | total [shop currency] | currency |
Relations
| Relationship | Relationshiop description |
|---|---|
| Has one address | Delivery address |
| Has one address | Invoice address |
| Has one carrier | Used carrier |
| Has one cart | Cart |
| Has one currency | Used currency |
| Has one customer | Customer |
| Has many invoices | Invoices |
| Has many ordered products | Ordered products |
| Has many payments | Payments |
| Has many stock movements | Stock movements |