Ordered products

Collection of all ordered products

Fields

Field alias Description Data type Editable
canWrite write permission boolean
combinationId combination id number
currencyId currency id number
discountAmount specific price - discount amount currency
discountAmountWithoutTax specific price - discount amount without tax currency
discountPercent specific price - discount percentage number
downloadCount number of downloads number yes
downloadDeadline download deadline datetime yes
downloadHash download secure key string yes
ean13 product EAN 13/JAN Barcode string yes
ecotax ecotax currency
ecotaxRate ecotax rate number
groupDiscount group discount currency
groupDiscountPercent group discount % number
groupDiscountWithoutTax group discount without tax currency
id id number
invoiceId invoice id number
isDownload is download boolean
name name string yes
onStock sufficient quantity on stock boolean
orderId order id number
productId product id number
productReference product reference string yes
quantity quantity number
quantityDiscountApplied quantity discount applied boolean
refunded quantity refunded number
returned quantity returned number
shippingCost shipping cost currency
shippingCostWithoutTax shipping cost tax excl. currency
shopId shop id number
supplierReference product supplier reference string yes
totalPrice total price currency
totalPriceWithoutTax total price tax excl. currency
unitPrice unit price currency
unitPriceWithoutTax unit price tax excl. currency
upc product UPC code number yes
validatedOrder order is validated boolean
warehouseId warehouse id number
weight product weight number yes

Common expressions

Expression Description Data type
orderedProduct.isDownload && orderedProduct.validatedOrder can download boolean
if(orderedProduct.isDownload, <param:shopUrl>+'index.php?controller=get-file&key=file-'+orderedProduct.downloadHash,'') download link string

Relations

Relationship Relationshiop description
Has one combination Combination
Belongs to order Order
Has one product Product
Update your privacy settings