---
title: Order details
slug: campaign/docs/order-details
docTags: 
createdAt: 2026-07-20T15:45:28.654Z
---

:::hint{type="info"}
**Note**

This topic is for administrators and developers with administration access rights in Magento 1.
:::

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 Optimizely Campaign, you can use a custom template that aggregates and calculates the required variables. This template is linked using the following line and defined in the file **items.phtml**.

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

:::hint{type="info"}
**Note**

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](docId\:ZWe1T3UPz3JW6_4mc76qV).
:::

| 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     |