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
Update your privacy settings