Raw Magento Data (JSON)
{
"base_currency_code": "EUR",
"base_discount_amount": 0,
"base_grand_total": 93.82,
"base_discount_tax_compensation_amount": 0,
"base_shipping_amount": 20,
"base_shipping_discount_amount": 0,
"base_shipping_discount_tax_compensation_amnt": 0,
"base_shipping_incl_tax": 24.2,
"base_shipping_tax_amount": 4.2,
"base_subtotal": 57.54,
"base_subtotal_incl_tax": 69.62,
"base_tax_amount": 16.28,
"base_total_due": 93.82,
"base_to_global_rate": 1,
"base_to_order_rate": 1,
"billing_address_id": 11631,
"created_at": "2025-02-11 10:28:33",
"customer_email": "richard@expoexpert.nl",
"customer_firstname": "Richard",
"customer_gender": 0,
"customer_group_id": 8,
"customer_id": 3672,
"customer_is_guest": 0,
"customer_lastname": "Boelens",
"customer_note_notify": 1,
"discount_amount": 0,
"email_sent": 1,
"entity_id": 5820,
"global_currency_code": "EUR",
"grand_total": 93.82,
"discount_tax_compensation_amount": 0,
"increment_id": "000003909",
"is_virtual": 0,
"order_currency_code": "EUR",
"protect_code": "6d98180e93077c86a2931d37f89852ba",
"quote_id": 50453,
"remote_ip": "185.214.115.4",
"shipping_amount": 20,
"shipping_description": "Transmission - Transmission (8:00 - 17:00 uur)",
"shipping_discount_amount": 0,
"shipping_discount_tax_compensation_amount": 0,
"shipping_incl_tax": 24.2,
"shipping_tax_amount": 4.2,
"state": "processing",
"status": "processing",
"store_currency_code": "EUR",
"store_id": 1,
"store_name": "Dutch Website\nMain Website Store\nNL",
"store_to_base_rate": 0,
"store_to_order_rate": 0,
"subtotal": 57.54,
"subtotal_incl_tax": 69.62,
"tax_amount": 16.28,
"total_due": 93.82,
"total_item_count": 3,
"total_qty_ordered": 3,
"updated_at": "2025-02-13 18:15:24",
"weight": 0,
"x_forwarded_for": "185.214.115.4, 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": 37.91,
"base_price": 37.91,
"base_price_incl_tax": 45.87,
"base_row_invoiced": 0,
"base_row_total": 37.91,
"base_row_total_incl_tax": 45.87,
"base_tax_amount": 7.96,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11163,
"name": "Lockset carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 37.91,
"price": 37.91,
"price_incl_tax": 45.87,
"product_id": 86,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19436,
"row_invoiced": 0,
"row_total": 37.91,
"row_total_incl_tax": 45.87,
"row_weight": 0,
"sku": "FK-0280",
"store_id": 1,
"tax_amount": 7.96,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9230,
"tax_id": 3166,
"item_id": 11163,
"tax_code": "NL",
"tax_percent": 21,
"amount": 7.96,
"base_amount": 7.96,
"real_amount": 7.96,
"real_base_amount": 7.96,
"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": 10.12,
"base_price": 10.12,
"base_price_incl_tax": 12.25,
"base_row_invoiced": 0,
"base_row_total": 10.12,
"base_row_total_incl_tax": 12.25,
"base_tax_amount": 2.13,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11164,
"name": "Endcap carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 10.12,
"price": 10.12,
"price_incl_tax": 12.25,
"product_id": 140,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19437,
"row_invoiced": 0,
"row_total": 10.12,
"row_total_incl_tax": 12.25,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 2.13,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "93",
"option_value": 91
}
]
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9231,
"tax_id": 3166,
"item_id": 11164,
"tax_code": "NL",
"tax_percent": 21,
"amount": 2.13,
"base_amount": 2.13,
"real_amount": 2.13,
"real_base_amount": 2.13,
"taxable_item_type": "product"
}
]
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 11165,
"name": "Endcap carre 80, zilver",
"no_discount": 0,
"order_id": 5820,
"original_price": 0,
"parent_item_id": 11164,
"price": 0,
"product_id": 295,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 19438,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2025-02-11 10:28:33",
"parent_item": {
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 10.12,
"base_price": 10.12,
"base_price_incl_tax": 12.25,
"base_row_invoiced": 0,
"base_row_total": 10.12,
"base_row_total_incl_tax": 12.25,
"base_tax_amount": 2.13,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11164,
"name": "Endcap carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 10.12,
"price": 10.12,
"price_incl_tax": 12.25,
"product_id": 140,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19437,
"row_invoiced": 0,
"row_total": 10.12,
"row_total_incl_tax": 12.25,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 2.13,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "93",
"option_value": 91
}
]
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9231,
"tax_id": 3166,
"item_id": 11164,
"tax_code": "NL",
"tax_percent": 21,
"amount": 2.13,
"base_amount": 2.13,
"real_amount": 2.13,
"real_base_amount": 2.13,
"taxable_item_type": "product"
}
]
}
},
"extension_attributes": {
"itemized_taxes": []
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 9.51,
"base_price": 9.51,
"base_price_incl_tax": 11.5,
"base_row_invoiced": 0,
"base_row_total": 9.51,
"base_row_total_incl_tax": 11.5,
"base_tax_amount": 1.99,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11166,
"name": "Extension set aluminium keeper",
"no_discount": 0,
"order_id": 5820,
"original_price": 9.51,
"price": 9.51,
"price_incl_tax": 11.5,
"product_id": 97,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19439,
"row_invoiced": 0,
"row_total": 9.51,
"row_total_incl_tax": 11.5,
"row_weight": 0,
"sku": "FK-0532",
"store_id": 1,
"tax_amount": 1.99,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9232,
"tax_id": 3166,
"item_id": 11166,
"tax_code": "NL",
"tax_percent": 21,
"amount": 1.99,
"base_amount": 1.99,
"real_amount": 1.99,
"real_base_amount": 1.99,
"taxable_item_type": "product"
}
]
}
}
],
"billing_address": {
"address_type": "billing",
"city": "Eindhoven",
"company": "eXpo eXpert",
"country_id": "NL",
"customer_address_id": 3627,
"email": "richard@expoexpert.nl",
"entity_id": 11631,
"firstname": "Richard",
"lastname": "Boelens",
"parent_id": 5820,
"postcode": "5652 AH",
"region_id": 0,
"street": [
"Hurksestraat",
"19"
],
"telephone": "0615244410"
},
"payment": {
"account_status": null,
"additional_information": [
"Op rekening"
],
"amount_ordered": 93.82,
"base_amount_ordered": 93.82,
"base_shipping_amount": 20,
"cc_exp_year": "0",
"cc_last4": null,
"cc_ss_start_month": "0",
"cc_ss_start_year": "0",
"entity_id": 5817,
"method": "checkmo",
"parent_id": 5820,
"shipping_amount": 20
},
"status_histories": [],
"extension_attributes": {
"shipping_assignments": [
{
"shipping": {
"address": {
"address_type": "shipping",
"city": "Den Haag",
"company": "Binck",
"country_id": "NL",
"email": "richard@expoexpert.nl",
"entity_id": 11630,
"firstname": "Pepijn",
"lastname": "Voorham",
"parent_id": 5820,
"postcode": "2516AK",
"street": [
"Zonweg",
"11A"
],
"telephone": "0645097188"
},
"method": "transmission_transmission",
"total": {
"base_shipping_amount": 20,
"base_shipping_discount_amount": 0,
"base_shipping_discount_tax_compensation_amnt": 0,
"base_shipping_incl_tax": 24.2,
"base_shipping_tax_amount": 4.2,
"shipping_amount": 20,
"shipping_discount_amount": 0,
"shipping_discount_tax_compensation_amount": 0,
"shipping_incl_tax": 24.2,
"shipping_tax_amount": 4.2
}
},
"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": 37.91,
"base_price": 37.91,
"base_price_incl_tax": 45.87,
"base_row_invoiced": 0,
"base_row_total": 37.91,
"base_row_total_incl_tax": 45.87,
"base_tax_amount": 7.96,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11163,
"name": "Lockset carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 37.91,
"price": 37.91,
"price_incl_tax": 45.87,
"product_id": 86,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19436,
"row_invoiced": 0,
"row_total": 37.91,
"row_total_incl_tax": 45.87,
"row_weight": 0,
"sku": "FK-0280",
"store_id": 1,
"tax_amount": 7.96,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9230,
"tax_id": 3166,
"item_id": 11163,
"tax_code": "NL",
"tax_percent": 21,
"amount": 7.96,
"base_amount": 7.96,
"real_amount": 7.96,
"real_base_amount": 7.96,
"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": 10.12,
"base_price": 10.12,
"base_price_incl_tax": 12.25,
"base_row_invoiced": 0,
"base_row_total": 10.12,
"base_row_total_incl_tax": 12.25,
"base_tax_amount": 2.13,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11164,
"name": "Endcap carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 10.12,
"price": 10.12,
"price_incl_tax": 12.25,
"product_id": 140,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19437,
"row_invoiced": 0,
"row_total": 10.12,
"row_total_incl_tax": 12.25,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 2.13,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "93",
"option_value": 91
}
]
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9231,
"tax_id": 3166,
"item_id": 11164,
"tax_code": "NL",
"tax_percent": 21,
"amount": 2.13,
"base_amount": 2.13,
"real_amount": 2.13,
"real_base_amount": 2.13,
"taxable_item_type": "product"
}
]
}
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_price": 0,
"base_row_invoiced": 0,
"base_row_total": 0,
"base_tax_amount": 0,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"discount_amount": 0,
"discount_invoiced": 0,
"discount_percent": 0,
"free_shipping": 0,
"is_qty_decimal": 0,
"is_virtual": 0,
"item_id": 11165,
"name": "Endcap carre 80, zilver",
"no_discount": 0,
"order_id": 5820,
"original_price": 0,
"parent_item_id": 11164,
"price": 0,
"product_id": 295,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 19438,
"row_invoiced": 0,
"row_total": 0,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 0,
"tax_invoiced": 0,
"tax_percent": 0,
"updated_at": "2025-02-11 10:28:33",
"parent_item": {
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 10.12,
"base_price": 10.12,
"base_price_incl_tax": 12.25,
"base_row_invoiced": 0,
"base_row_total": 10.12,
"base_row_total_incl_tax": 12.25,
"base_tax_amount": 2.13,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11164,
"name": "Endcap carre 80",
"no_discount": 0,
"order_id": 5820,
"original_price": 10.12,
"price": 10.12,
"price_incl_tax": 12.25,
"product_id": 140,
"product_type": "configurable",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19437,
"row_invoiced": 0,
"row_total": 10.12,
"row_total_incl_tax": 12.25,
"row_weight": 0,
"sku": "FK-0725",
"store_id": 1,
"tax_amount": 2.13,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"product_option": {
"extension_attributes": {
"configurable_item_options": [
{
"option_id": "93",
"option_value": 91
}
]
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9231,
"tax_id": 3166,
"item_id": 11164,
"tax_code": "NL",
"tax_percent": 21,
"amount": 2.13,
"base_amount": 2.13,
"real_amount": 2.13,
"real_base_amount": 2.13,
"taxable_item_type": "product"
}
]
}
},
"extension_attributes": {
"itemized_taxes": []
},
"row_total_incl_tax": 0,
"base_row_total_incl_tax": 0
},
{
"amount_refunded": 0,
"base_amount_refunded": 0,
"base_discount_amount": 0,
"base_discount_invoiced": 0,
"base_discount_tax_compensation_amount": 0,
"base_original_price": 9.51,
"base_price": 9.51,
"base_price_incl_tax": 11.5,
"base_row_invoiced": 0,
"base_row_total": 9.51,
"base_row_total_incl_tax": 11.5,
"base_tax_amount": 1.99,
"base_tax_invoiced": 0,
"created_at": "2025-02-11 10:28:33",
"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": 11166,
"name": "Extension set aluminium keeper",
"no_discount": 0,
"order_id": 5820,
"original_price": 9.51,
"price": 9.51,
"price_incl_tax": 11.5,
"product_id": 97,
"product_type": "simple",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 1,
"qty_refunded": 0,
"qty_shipped": 1,
"quote_item_id": 19439,
"row_invoiced": 0,
"row_total": 9.51,
"row_total_incl_tax": 11.5,
"row_weight": 0,
"sku": "FK-0532",
"store_id": 1,
"tax_amount": 1.99,
"tax_invoiced": 0,
"tax_percent": 21,
"updated_at": "2025-02-13 18:15:24",
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9232,
"tax_id": 3166,
"item_id": 11166,
"tax_code": "NL",
"tax_percent": 21,
"amount": 1.99,
"base_amount": 1.99,
"real_amount": 1.99,
"real_base_amount": 1.99,
"taxable_item_type": "product"
}
]
}
}
]
}
],
"payment_additional_info": [
{
"key": "method_title",
"value": "Op rekening"
}
],
"applied_taxes": [
{
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 16.28,
"base_amount": 16.28
}
],
"item_applied_taxes": [
{
"type": "shipping",
"applied_taxes": [
{
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 4.2,
"base_amount": 4.2
}
]
},
{
"type": "product",
"item_id": 11163,
"applied_taxes": [
{
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 7.96,
"base_amount": 7.96
}
]
},
{
"type": "product",
"item_id": 11164,
"applied_taxes": [
{
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 2.13,
"base_amount": 2.13
}
]
},
{
"type": "product",
"item_id": 11166,
"applied_taxes": [
{
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 1.99,
"base_amount": 1.99
}
]
}
],
"converting_from_quote": false,
"taxes": [
{
"tax_id": 3166,
"order_id": 5820,
"code": "NL",
"title": "NL",
"percent": 21,
"amount": 16.28,
"base_amount": 16.28,
"base_real_amount": 16.28,
"priority": 0,
"position": 0,
"process": 0
}
],
"additional_itemized_taxes": [
{
"tax_item_id": 9233,
"tax_id": 3166,
"tax_code": "NL",
"tax_percent": 21,
"amount": 4.2,
"base_amount": 4.2,
"real_amount": 4.2,
"real_base_amount": 4.2,
"taxable_item_type": "shipping"
}
],
"files": [],
"additional_shipping_information": {
"order_id": 5820,
"route_id": 0,
"delivery_datetime": "2025-02-14 00:00:00",
"shipping_datetime": "2025-02-13 00:00:00"
},
"ittica_order_number": "276987",
"order_reference": "Binck",
"customer_company": "eXpo eXpert",
"mollie_payment_fee": 0,
"base_mollie_payment_fee": 0,
"mollie_payment_fee_tax": 0,
"base_mollie_payment_fee_tax": 0
}
}