Raw Magento Data (JSON)
{
"base_currency_code": "EUR",
"base_discount_amount": 0,
"base_grand_total": 195.22,
"base_discount_tax_compensation_amount": 0,
"base_shipping_amount": 0,
"base_shipping_discount_amount": 0,
"base_shipping_discount_tax_compensation_amnt": 0,
"base_shipping_incl_tax": 0,
"base_shipping_tax_amount": 0,
"base_subtotal": 162.68,
"base_subtotal_incl_tax": 195.22,
"base_tax_amount": 32.54,
"base_total_due": 195.22,
"base_to_global_rate": 1,
"base_to_order_rate": 0.85,
"billing_address_id": 22813,
"created_at": "2025-10-28 13:31:51",
"customer_email": "jon@trenchard.co",
"customer_firstname": "Jon",
"customer_gender": 0,
"customer_group_id": 96,
"customer_id": 6753,
"customer_is_guest": 0,
"customer_lastname": "Trenchard",
"customer_note_notify": 1,
"discount_amount": 0,
"email_sent": 1,
"entity_id": 11411,
"global_currency_code": "EUR",
"grand_total": 165.92,
"discount_tax_compensation_amount": 0,
"increment_id": "6000000308",
"is_virtual": 0,
"order_currency_code": "GBP",
"protect_code": "4ed111d912a074d133c72ad3d042e6ec",
"quote_id": 63605,
"remote_ip": "31.52.114.53",
"shipping_amount": 0,
"shipping_description": "Vrachtkosten na berekening - Freight on costing",
"shipping_discount_amount": 0,
"shipping_discount_tax_compensation_amount": 0,
"shipping_incl_tax": 0,
"shipping_tax_amount": 0,
"state": "new",
"status": "complete",
"store_currency_code": "EUR",
"store_id": 6,
"store_name": "UK Website\nEFKA UK\nUK",
"store_to_base_rate": 0,
"store_to_order_rate": 0,
"subtotal": 138.27,
"subtotal_incl_tax": 165.92,
"tax_amount": 27.65,
"total_due": 165.92,
"total_item_count": 2,
"total_qty_ordered": 2,
"updated_at": "2025-11-19 09:24:18",
"weight": 0,
"x_forwarded_for": "31.52.114.53, 127.0.0.1",
"items": [
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 0,
"base_price": 72.24,
"base_price_incl_tax": 86.69,
"base_row_invoiced": 0,
"base_row_total": 72.24,
"base_row_total_incl_tax": 86.69,
"base_tax_amount": 14.45,
"base_tax_invoiced": 0,
"created_at": "2025-10-28 13:31:51",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 21742,
"name": "Slim 25",
"no_discount": 0,
"order_id": 11411,
"original_price": 0,
"price": 61.4,
"price_incl_tax": 73.68,
"product_id": 12,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 37577,
"row_invoiced": 0,
"row_total": 61.4,
"row_total_incl_tax": 73.68,
"row_weight": 0,
"sku": "NF-04250",
"store_id": 6,
"tax_amount": 12.28,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-11-04 10:02:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "accessory_costs",
"option_value": "7.8606"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Afmeting\",\"value\":\"1670mm (width) x 2260mm (height) - 1x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"1670mm (width) x 2260mm (height) - 1x\",\"ignore_restriction\":false,\"sizes\":{\"width\":1670,\"height\":2260,\"max\":{\"width\":1670,\"height\":2260}},\"quantity\":1}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04250\",\"selected\":{\"id\":\"select-parent-665-1101\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04250\",\"main_sku\":\"NF-04250\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"stabilizers\",\"label\":\"Stabilizers\",\"value\":\"No\",\"selected\":{\"id\":\"stabilizers\",\"enabled\":false,\"value\":\"No\",\"selected\":{\"horizontal\":\"0\",\"vertical\":0,\"parts\":{\"horizontal\":0,\"vertical\":0}},\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"accessories\",\"label\":\"Accessories\",\"value\":\"Wall mount simple (2 per frame)\",\"selected\":{\"id\":\"accessories\",\"value\":\"Wall mount simple (2 per frame)\",\"selected\":[{\"choiceid\":\"6\",\"sku\":\"FK-0400\",\"opttitle\":\"Wall mount simple\",\"quantity\":2}],\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"color\":\"silver\"},\"sizes\":{\"width\":1670,\"height\":2260,\"max\":{\"width\":1670,\"height\":2260}},\"quantity\":1,\"color\":\"silver\"}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 17535,
"tax_id": 6080,
"item_id": 21742,
"tax_code": "UK",
"tax_percent": 20,
"amount": 12.28,
"base_amount": 14.45,
"real_amount": 12.28,
"real_base_amount": 14.45,
"taxable_item_type": "product"
}
]
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 0,
"base_price": 90.44,
"base_price_incl_tax": 108.53,
"base_row_invoiced": 0,
"base_row_total": 90.44,
"base_row_total_incl_tax": 108.53,
"base_tax_amount": 18.09,
"base_tax_invoiced": 0,
"created_at": "2025-10-28 13:31:51",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 21743,
"name": "Slim 25",
"no_discount": 0,
"order_id": 11411,
"original_price": 0,
"price": 76.87,
"price_incl_tax": 92.24,
"product_id": 12,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 37578,
"row_invoiced": 0,
"row_total": 76.87,
"row_total_incl_tax": 92.24,
"row_weight": 0,
"sku": "NF-04250",
"store_id": 6,
"tax_amount": 15.37,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-11-04 10:02:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "accessory_costs",
"option_value": "11.7909"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Afmeting\",\"value\":\"2700mm (width) x 2260mm (height) - 1x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"2700mm (width) x 2260mm (height) - 1x\",\"ignore_restriction\":false,\"sizes\":{\"width\":2700,\"height\":2260,\"max\":{\"width\":2700,\"height\":2260}},\"quantity\":1}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04250\",\"selected\":{\"id\":\"select-parent-665-1101\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04250\",\"main_sku\":\"NF-04250\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"stabilizers\",\"label\":\"Stabilizers\",\"value\":\"No\",\"selected\":{\"id\":\"stabilizers\",\"enabled\":false,\"value\":\"No\",\"selected\":{\"horizontal\":\"0\",\"vertical\":\"0\",\"parts\":{\"horizontal\":0,\"vertical\":0}},\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"accessories\",\"label\":\"Accessories\",\"value\":\"Wall mount simple (3 per frame)\",\"selected\":{\"id\":\"accessories\",\"value\":\"Wall mount simple (3 per frame)\",\"selected\":[{\"choiceid\":\"6\",\"sku\":\"FK-0400\",\"opttitle\":\"Wall mount simple\",\"quantity\":3}],\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"color\":\"silver\"},\"sizes\":{\"width\":2700,\"height\":2260,\"max\":{\"width\":2700,\"height\":2260}},\"quantity\":1,\"color\":\"silver\"}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 17536,
"tax_id": 6080,
"item_id": 21743,
"tax_code": "UK",
"tax_percent": 20,
"amount": 15.37,
"base_amount": 18.09,
"real_amount": 15.37,
"real_base_amount": 18.09,
"taxable_item_type": "product"
}
]
}
}
],
"billing_address": {
"address_type": "billing",
"city": "Lambourn Woodlands",
"company": "TRENCHARD",
"country_id": "GB",
"customer_address_id": 7334,
"email": "jon@trenchard.co",
"entity_id": 22813,
"firstname": "Jon",
"lastname": "Trenchard",
"parent_id": 11411,
"postcode": "RG17 7TP",
"region_id": 0,
"street": [
"Ermin Street"
],
"telephone": "07706147941"
},
"payment": {
"account_status": null,
"additional_information": [
"The sales team will be in touch with payment options."
],
"amount_ordered": 165.92,
"base_amount_ordered": 195.22,
"base_shipping_amount": 0,
"cc_exp_year": "0",
"cc_last4": null,
"cc_ss_start_month": "0",
"cc_ss_start_year": "0",
"entity_id": 11408,
"method": "checkmo",
"parent_id": 11411,
"shipping_amount": 0
},
"status_histories": [],
"extension_attributes": {
"shipping_assignments": [
{
"shipping": {
"address": {
"address_type": "shipping",
"city": "Newbury",
"company": "Trenchard",
"country_id": "GB",
"customer_address_id": 8445,
"email": "jon@trenchard.co",
"entity_id": 22812,
"firstname": "Jon",
"lastname": "Trenchard",
"parent_id": 11411,
"postcode": "RG14 1PZ",
"region_id": 0,
"street": [
"8 Amberley Close",
"Donnington"
],
"telephone": "07706147941"
},
"method": "freight_cost_after_calculation_freight_cost_after_calculation",
"total": {
"base_shipping_amount": 0,
"base_shipping_discount_amount": 0,
"base_shipping_discount_tax_compensation_amnt": 0,
"base_shipping_incl_tax": 0,
"base_shipping_tax_amount": 0,
"shipping_amount": 0,
"shipping_discount_amount": 0,
"shipping_discount_tax_compensation_amount": 0,
"shipping_incl_tax": 0,
"shipping_tax_amount": 0
}
},
"items": [
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 0,
"base_price": 72.24,
"base_price_incl_tax": 86.69,
"base_row_invoiced": 0,
"base_row_total": 72.24,
"base_row_total_incl_tax": 86.69,
"base_tax_amount": 14.45,
"base_tax_invoiced": 0,
"created_at": "2025-10-28 13:31:51",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 21742,
"name": "Slim 25",
"no_discount": 0,
"order_id": 11411,
"original_price": 0,
"price": 61.4,
"price_incl_tax": 73.68,
"product_id": 12,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 37577,
"row_invoiced": 0,
"row_total": 61.4,
"row_total_incl_tax": 73.68,
"row_weight": 0,
"sku": "NF-04250",
"store_id": 6,
"tax_amount": 12.28,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-11-04 10:02:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "accessory_costs",
"option_value": "7.8606"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Afmeting\",\"value\":\"1670mm (width) x 2260mm (height) - 1x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"1670mm (width) x 2260mm (height) - 1x\",\"ignore_restriction\":false,\"sizes\":{\"width\":1670,\"height\":2260,\"max\":{\"width\":1670,\"height\":2260}},\"quantity\":1}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04250\",\"selected\":{\"id\":\"select-parent-665-1101\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04250\",\"main_sku\":\"NF-04250\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"stabilizers\",\"label\":\"Stabilizers\",\"value\":\"No\",\"selected\":{\"id\":\"stabilizers\",\"enabled\":false,\"value\":\"No\",\"selected\":{\"horizontal\":\"0\",\"vertical\":0,\"parts\":{\"horizontal\":0,\"vertical\":0}},\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"accessories\",\"label\":\"Accessories\",\"value\":\"Wall mount simple (2 per frame)\",\"selected\":{\"id\":\"accessories\",\"value\":\"Wall mount simple (2 per frame)\",\"selected\":[{\"choiceid\":\"6\",\"sku\":\"FK-0400\",\"opttitle\":\"Wall mount simple\",\"quantity\":2}],\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"color\":\"silver\"},\"sizes\":{\"width\":1670,\"height\":2260,\"max\":{\"width\":1670,\"height\":2260}},\"quantity\":1,\"color\":\"silver\"}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 17535,
"tax_id": 6080,
"item_id": 21742,
"tax_code": "UK",
"tax_percent": 20,
"amount": 12.28,
"base_amount": 14.45,
"real_amount": 12.28,
"real_base_amount": 14.45,
"taxable_item_type": "product"
}
]
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 0,
"base_price": 90.44,
"base_price_incl_tax": 108.53,
"base_row_invoiced": 0,
"base_row_total": 90.44,
"base_row_total_incl_tax": 108.53,
"base_tax_amount": 18.09,
"base_tax_invoiced": 0,
"created_at": "2025-10-28 13:31:51",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"discount_tax_compensation_amount": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 21743,
"name": "Slim 25",
"no_discount": 0,
"order_id": 11411,
"original_price": 0,
"price": 76.87,
"price_incl_tax": 92.24,
"product_id": 12,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 37578,
"row_invoiced": 0,
"row_total": 76.87,
"row_total_incl_tax": 92.24,
"row_weight": 0,
"sku": "NF-04250",
"store_id": 6,
"tax_amount": 15.37,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-11-04 10:02:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "accessory_costs",
"option_value": "11.7909"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Afmeting\",\"value\":\"2700mm (width) x 2260mm (height) - 1x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"2700mm (width) x 2260mm (height) - 1x\",\"ignore_restriction\":false,\"sizes\":{\"width\":2700,\"height\":2260,\"max\":{\"width\":2700,\"height\":2260}},\"quantity\":1}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04250\",\"selected\":{\"id\":\"select-parent-665-1101\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04250\",\"main_sku\":\"NF-04250\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"stabilizers\",\"label\":\"Stabilizers\",\"value\":\"No\",\"selected\":{\"id\":\"stabilizers\",\"enabled\":false,\"value\":\"No\",\"selected\":{\"horizontal\":\"0\",\"vertical\":\"0\",\"parts\":{\"horizontal\":0,\"vertical\":0}},\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"accessories\",\"label\":\"Accessories\",\"value\":\"Wall mount simple (3 per frame)\",\"selected\":{\"id\":\"accessories\",\"value\":\"Wall mount simple (3 per frame)\",\"selected\":[{\"choiceid\":\"6\",\"sku\":\"FK-0400\",\"opttitle\":\"Wall mount simple\",\"quantity\":3}],\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"color\":\"silver\"},\"sizes\":{\"width\":2700,\"height\":2260,\"max\":{\"width\":2700,\"height\":2260}},\"quantity\":1,\"color\":\"silver\"}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 17536,
"tax_id": 6080,
"item_id": 21743,
"tax_code": "UK",
"tax_percent": 20,
"amount": 15.37,
"base_amount": 18.09,
"real_amount": 15.37,
"real_base_amount": 18.09,
"taxable_item_type": "product"
}
]
}
}
]
}
],
"payment_additional_info": [
{
"key": "method_title",
"value": "The sales team will be in touch with payment options."
}
],
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 27.65,
"base_amount": 32.54
}
],
"item_applied_taxes": [
{
"type": "shipping",
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 0,
"base_amount": 0
}
]
},
{
"type": "product",
"item_id": 21742,
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 12.28,
"base_amount": 14.45
}
]
},
{
"type": "product",
"item_id": 21743,
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 15.37,
"base_amount": 18.09
}
]
}
],
"converting_from_quote": false,
"taxes": [
{
"tax_id": 6080,
"order_id": 11411,
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 27.65,
"base_amount": 32.54,
"base_real_amount": 32.54,
"priority": 0,
"position": 0,
"process": 0
}
],
"additional_itemized_taxes": [
{
"tax_item_id": 17537,
"tax_id": 6080,
"tax_code": "UK",
"tax_percent": 20,
"amount": 0,
"base_amount": 0,
"real_amount": 0,
"real_base_amount": 0,
"taxable_item_type": "shipping"
}
],
"files": [],
"order_reference": "AML25",
"customer_company": "TRENCHARD",
"additional_shipping_information": {
"order_id": 11411,
"route_id": 0,
"desired_delivery_datetime": "2025-11-03 00:00:00",
"shipping_datetime": "2025-10-31 00:00:00"
},
"mollie_payment_fee": 0,
"base_mollie_payment_fee": 0,
"mollie_payment_fee_tax": 0,
"base_mollie_payment_fee_tax": 0
}
}