Order details

This topic is for administrators and developers with administration access rights in Episerver Campaign.

If you are using Magento 1 as e-commerce platform, you can integrate this with Episerver Campaign. If you want to send more than the five standard order parameters (product ID, order number, name, price and quantity) provided by the function getOptivoProducts to Episerver Campaign, you can use a custom template that aggregates and calculates the required variables. This template is linked using the line:

{{layout area="frontend" handle="optivo_email_order_items" order=$order}}

and defined in the file items.phtml.

To program the template, you need relevant PHP skills and good knowledge of the Magento object model or order items. Any changes must be applied only after consultation with customer support.

Field name Data type
item_id Integer
order_id Integer
parent_item_id Integer
quote_item_id Integer
store_id Integer
created_at Date
updated_at Date
product_id Integer
product_type String
product_options String
weight Float
is_virtual Boolean
sku String
Name String
Description String
applied_rule_ids String
additional_data String
free_shipping Boolean
is_qty_decimal Boolean
no_discount Boolean
qty_backordered Float
qty_canceled Float
qty_invoiced Float
qty_ordered Float
qty_refunded Float
qty_shipped Float
base_cost Float
price Float
base_price Float
original_price Float
base_original_price Float
tax_percent Float
tax_amount Float
base_tax_amount Float
tax_invoiced Float
base_tax_invoiced Float
discount_percent Float
discount_amount Float
base_discount_amount Float
discount_invoiced Float
base_discount_invoiced Float
amount_refunded Float
base_amount_refunded Float
row_total Float
base_row_total Float
row_invoiced Float
base_row_invoiced Float
row_weight Float
gift_message_id Integer
gift_message_available Integer
base_tax_before_discount Float
tax_before_discount Float
ext_order_item_id String
weee_tax_applied String
weee_tax_applied_amount Float
weee_tax_applied_row_amount Float
base_weee_tax_applied_amount Float
base_weee_tax_applied_row_amnt Float
weee_tax_disposition Float
weee_tax_row_disposition Float
base_weee_tax_disposition Float
base_weee_tax_row_disposition Float
locked_do_invoice Boolean
locked_do_ship Boolean
price_incl_tax Float
base_price_incl_tax Float
row_total_incl_tax Float
base_row_total_incl_tax Float
hidden_tax_amount Float
base_hidden_tax_amount Float
hidden_tax_invoiced Float
base_hidden_tax_invoiced Float
hidden_tax_refunded Float
base_hidden_tax_refunded Float
is_nominal Integer
tax_canceled Float
hidden_tax_canceled Float
tax_refunded Float
event_id Integer
giftregistry_item_id Integer
base_tax_refunded Float
discount_refunded Float
base_discount_refunded Float
gw_id Integer
gw_base_price Float
gw_price Float
gw_base_tax_amount Float
gw_tax_amount Float
gw_base_price_invoiced Float
gw_price_invoiced Float
gw_base_tax_amount_invoiced Float
gw_tax_amount_invoiced Float
gw_base_price_refunded Float
gw_price_refunded Float
gw_base_tax_amount_refunded Float
gw_tax_amount_refunded Float
qty_returned Float