Raw Magento Data (JSON)
{
"base_currency_code": "EUR",
"base_discount_amount": 0,
"base_grand_total": 7253.35,
"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": 6044.46,
"base_subtotal_incl_tax": 7253.35,
"base_tax_amount": 1208.89,
"base_total_due": 7253.35,
"base_to_global_rate": 1,
"base_to_order_rate": 0.85,
"billing_address_id": 12685,
"created_at": "2025-03-06 16:10:04",
"customer_email": "lbroad@thisisspiro.com",
"customer_firstname": "Lauren",
"customer_gender": 0,
"customer_group_id": 96,
"customer_id": 6323,
"customer_is_guest": 0,
"customer_lastname": "Broad",
"customer_note_notify": 1,
"discount_amount": 0,
"email_sent": 1,
"entity_id": 6347,
"global_currency_code": "EUR",
"grand_total": 6165.34,
"discount_tax_compensation_amount": 0,
"increment_id": "6000000137",
"is_virtual": 0,
"order_currency_code": "GBP",
"protect_code": "f4b44a11dd3509a4cd9f0e6b0a04a975",
"quote_id": 52150,
"remote_ip": "82.1.254.2",
"shipping_amount": 0,
"shipping_description": "Freight on costing - 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": 5137.78,
"subtotal_incl_tax": 6165.34,
"tax_amount": 1027.56,
"total_due": 6165.34,
"total_item_count": 2,
"total_qty_ordered": 4,
"updated_at": "2025-04-01 14:41:59",
"weight": 0,
"x_forwarded_for": "82.1.254.2, 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": 1136.31,
"base_price_incl_tax": 1363.57,
"base_row_invoiced": 0,
"base_row_total": 1136.31,
"base_row_total_incl_tax": 2727.14,
"base_tax_amount": 454.52,
"base_tax_invoiced": 0,
"created_at": "2025-03-06 16:10:04",
"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": 12151,
"name": "Lightbox 60",
"no_discount": 0,
"order_id": 6347,
"original_price": 0,
"price": 965.86,
"price_incl_tax": 1159.03,
"product_id": 22,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 2,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 21176,
"row_invoiced": 0,
"row_total": 965.86,
"row_total_incl_tax": 2318.06,
"row_weight": 0,
"sku": "NF-04604",
"store_id": 6,
"tax_amount": 386.34,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-03-14 12:34:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "light_type",
"option_value": "withLight"
},
{
"option_id": "dimmable",
"option_value": "dimmableYes"
},
{
"option_id": "led_type",
"option_value": "ledTypeBrightLed"
},
{
"option_id": "cable_connection",
"option_value": "ukConnection"
},
{
"option_id": "cable_color",
"option_value": "cableColorBlack"
},
{
"option_id": "cable_length",
"option_value": "cableLength2"
},
{
"option_id": "led_color",
"option_value": "ledColor6500"
},
{
"option_id": "cable_exit",
"option_value": "throughBack"
},
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "cable_position",
"option_value": "Bottom"
},
{
"option_id": "accessory_costs",
"option_value": "0"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Size and quantity\",\"value\":\"2000 x 2500 mm - 2x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"2000 x 2500 mm - 2x\",\"ignore_restriction\":false,\"sizes\":{\"width\":2000,\"height\":2500,\"max\":{\"width\":2000,\"height\":2500}},\"quantity\":2}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04604\",\"selected\":{\"id\":\"select-parent-847-1391\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04604\",\"main_sku\":\"NF-04604\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Illuminated or unlit\",\"value\":\"With LED lighting\",\"sku\":null,\"selected\":{\"id\":\"select-parent-848-1395\",\"price\":null,\"value\":\"With LED lighting\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"withLight\",\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Brightness\",\"value\":\"Bright LED\",\"sku\":null,\"selected\":{\"id\":\"select-parent-849-1396\",\"type\":\"ledTypeBrightLed\",\"price\":0,\"value\":\"Bright LED\",\"sku\":null,\"color_type\":\"\",\"main_sku\":null,\"optional_skus\":[],\"ignore_restriction\":false}},{\"name\":\"elem7\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Colour\",\"value\":\"6500K\",\"sku\":null,\"selected\":{\"id\":\"select-parent-850-1397\",\"price\":null,\"value\":\"6500K\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ledColor6500\",\"ignore_restriction\":false}},{\"name\":\"elem8\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Dimmable\",\"value\":\"Dimmable\",\"sku\":null,\"selected\":{\"id\":\"select-parent-851-1400\",\"price\":null,\"value\":\"Dimmable\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"dimmableYes\",\"ignore_restriction\":false}},{\"name\":\"elem9\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Power outlet\",\"value\":\"Through the back \",\"sku\":null,\"selected\":{\"id\":\"select-parent-852-1402\",\"price\":null,\"value\":\"Through the back \",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"throughBack\",\"ignore_restriction\":false}},{\"name\":\"elem10\",\"label\":\"Position cable outlet\",\"value\":\"Bottom\",\"selected\":{\"id\":\"cableHole\",\"radioValue\":\"Bottom\",\"position\":null,\"value\":\"Bottom\",\"ignore_restriction\":false}},{\"name\":\"elem11\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable connection\",\"value\":\"UK connection\",\"sku\":null,\"selected\":{\"id\":\"select-parent-854-1405\",\"price\":null,\"value\":\"UK connection\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ukConnection\",\"ignore_restriction\":false}},{\"name\":\"elem12\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable colour\",\"value\":\"Black\",\"sku\":null,\"selected\":{\"id\":\"select-parent-855-1407\",\"price\":null,\"value\":\"Black\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableColorBlack\",\"ignore_restriction\":false}},{\"name\":\"elem13\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable length\",\"value\":\"2 meters\",\"sku\":null,\"selected\":{\"id\":\"select-parent-856-1409\",\"price\":null,\"value\":\"2 meters\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableLength2\",\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\"},\"sizes\":{\"width\":2000,\"height\":2500,\"max\":{\"width\":2000,\"height\":2500}},\"quantity\":2,\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\",\"cadix\":{\"type\":\"Lightbox 60MM\",\"color\":\"Silver\",\"width\":2000,\"height\":2500,\"quantity\":2,\"poweradapter\":\"UK 2m zwart\",\"power_position\":\"6A\",\"dimmer\":true,\"led_type\":\"FK3\",\"led_color\":\"6500K\",\"seconds\":7632,\"minutes\":127.2,\"total_seconds\":8292,\"total_minutes\":138.2,\"square_meter\":4.76,\"parts\":[{\"type\":\"dibond\",\"part_number\":\"FK-9810\",\"quantity\":2,\"seconds\":1428},{\"type\":\"dibond connector (CM1)\",\"part_number\":\"NF-56290\",\"quantity\":1,\"seconds\":300},{\"type\":\"adapter\",\"part_number\":\"AF99-344-WC\",\"quantity\":5,\"seconds\":1500},{\"type\":\"connector\",\"part_number\":\"AF90-530\",\"quantity\":5,\"seconds\":300},{\"type\":\"LED\",\"part_number\":\"AF92-350\",\"quantity\":15,\"seconds\":342},{\"type\":\"LED\",\"part_number\":\"AF92-345\",\"quantity\":30,\"seconds\":684},{\"type\":\"LED\",\"part_number\":\"AF92-330\",\"quantity\":15,\"seconds\":342},{\"type\":\"Wire cord clip\",\"part_number\":\"FK8220\",\"quantity\":180,\"seconds\":1836},{\"type\":\"dimmer\",\"part_number\":\"AF92-220\",\"quantity\":1,\"seconds\":120},{\"type\":\"remote\",\"part_number\":\"AF92-230\",\"quantity\":1,\"seconds\":0},{\"type\":\"repeater\",\"part_number\":\"AF99-112\",\"quantity\":4,\"seconds\":480},{\"type\":\"poweradapter\",\"part_number\":\"MK-0560\",\"quantity\":1,\"seconds\":300}]}}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9967,
"tax_id": 3438,
"item_id": 12151,
"tax_code": "UK",
"tax_percent": 20,
"amount": 386.34,
"base_amount": 454.52,
"real_amount": 386.34,
"real_base_amount": 454.52,
"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": 1885.92,
"base_price_incl_tax": 2263.11,
"base_row_invoiced": 0,
"base_row_total": 1885.92,
"base_row_total_incl_tax": 4526.21,
"base_tax_amount": 754.37,
"base_tax_invoiced": 0,
"created_at": "2025-03-06 16:10:04",
"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": 12152,
"name": "Lightbox 60",
"no_discount": 0,
"order_id": 6347,
"original_price": 0,
"price": 1603.03,
"price_incl_tax": 1923.64,
"product_id": 22,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 2,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 21177,
"row_invoiced": 0,
"row_total": 1603.03,
"row_total_incl_tax": 3847.28,
"row_weight": 0,
"sku": "NF-04604",
"store_id": 6,
"tax_amount": 641.22,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-03-14 12:34:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "light_type",
"option_value": "withLight"
},
{
"option_id": "dimmable",
"option_value": "dimmableYes"
},
{
"option_id": "led_type",
"option_value": "ledTypeBrightLed"
},
{
"option_id": "cable_connection",
"option_value": "ukConnection"
},
{
"option_id": "cable_color",
"option_value": "cableColorBlack"
},
{
"option_id": "cable_length",
"option_value": "cableLength2"
},
{
"option_id": "led_color",
"option_value": "ledColor6500"
},
{
"option_id": "cable_exit",
"option_value": "throughBack"
},
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "cable_position",
"option_value": "Bottom"
},
{
"option_id": "accessory_costs",
"option_value": "0"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Size and quantity\",\"value\":\"3600 x 2300 mm - 2x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"3600 x 2300 mm - 2x\",\"ignore_restriction\":false,\"sizes\":{\"width\":3600,\"height\":2300,\"max\":{\"width\":\"3000\",\"height\":2300}},\"quantity\":2}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04604\",\"selected\":{\"id\":\"select-parent-847-1391\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04604\",\"main_sku\":\"NF-04604\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Illuminated or unlit\",\"value\":\"With LED lighting\",\"sku\":null,\"selected\":{\"id\":\"select-parent-848-1395\",\"price\":null,\"value\":\"With LED lighting\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"withLight\",\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Brightness\",\"value\":\"Bright LED\",\"sku\":null,\"selected\":{\"id\":\"select-parent-849-1396\",\"type\":\"ledTypeBrightLed\",\"price\":0,\"value\":\"Bright LED\",\"sku\":null,\"color_type\":\"\",\"main_sku\":null,\"optional_skus\":[],\"ignore_restriction\":false}},{\"name\":\"elem7\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Colour\",\"value\":\"6500K\",\"sku\":null,\"selected\":{\"id\":\"select-parent-850-1397\",\"price\":null,\"value\":\"6500K\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ledColor6500\",\"ignore_restriction\":false}},{\"name\":\"elem8\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Dimmable\",\"value\":\"Dimmable\",\"sku\":null,\"selected\":{\"id\":\"select-parent-851-1400\",\"price\":null,\"value\":\"Dimmable\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"dimmableYes\",\"ignore_restriction\":false}},{\"name\":\"elem9\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Power outlet\",\"value\":\"Through the back \",\"sku\":null,\"selected\":{\"id\":\"select-parent-852-1402\",\"price\":null,\"value\":\"Through the back \",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"throughBack\",\"ignore_restriction\":false}},{\"name\":\"elem10\",\"label\":\"Position cable outlet\",\"value\":\"Bottom\",\"selected\":{\"id\":\"cableHole\",\"radioValue\":\"Bottom\",\"position\":null,\"value\":\"Bottom\",\"ignore_restriction\":false}},{\"name\":\"elem11\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable connection\",\"value\":\"UK connection\",\"sku\":null,\"selected\":{\"id\":\"select-parent-854-1405\",\"price\":null,\"value\":\"UK connection\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ukConnection\",\"ignore_restriction\":false}},{\"name\":\"elem12\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable colour\",\"value\":\"Black\",\"sku\":null,\"selected\":{\"id\":\"select-parent-855-1407\",\"price\":null,\"value\":\"Black\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableColorBlack\",\"ignore_restriction\":false}},{\"name\":\"elem13\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable length\",\"value\":\"2 meters\",\"sku\":null,\"selected\":{\"id\":\"select-parent-856-1409\",\"price\":null,\"value\":\"2 meters\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableLength2\",\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\"},\"sizes\":{\"width\":3600,\"height\":2300,\"max\":{\"width\":\"3000\",\"height\":2300}},\"quantity\":2,\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\",\"cadix\":{\"type\":\"Lightbox 60MM\",\"color\":\"Silver\",\"width\":3600,\"height\":2300,\"quantity\":2,\"poweradapter\":\"UK 2m zwart\",\"power_position\":\"6A\",\"dimmer\":true,\"led_type\":\"FK3\",\"led_color\":\"6500K\",\"seconds\":12093,\"minutes\":201.6,\"total_seconds\":12753,\"total_minutes\":212.6,\"square_meter\":7.964,\"parts\":[{\"type\":\"dibond\",\"part_number\":\"FK-9810\",\"quantity\":3,\"seconds\":2389.2},{\"type\":\"dibond connector (CM1)\",\"part_number\":\"NF-56290\",\"quantity\":2,\"seconds\":600},{\"type\":\"adapter\",\"part_number\":\"AF99-342-WC\",\"quantity\":11,\"seconds\":3300},{\"type\":\"connector\",\"part_number\":\"AF90-520\",\"quantity\":11,\"seconds\":660},{\"type\":\"LED\",\"part_number\":\"AF92-350\",\"quantity\":44,\"seconds\":1003.2},{\"type\":\"LED\",\"part_number\":\"AF92-340\",\"quantity\":22,\"seconds\":501.6},{\"type\":\"Wire cord clip\",\"part_number\":\"FK8220\",\"quantity\":198,\"seconds\":2019.6},{\"type\":\"dimmer\",\"part_number\":\"AF92-220\",\"quantity\":1,\"seconds\":120},{\"type\":\"remote\",\"part_number\":\"AF92-230\",\"quantity\":1,\"seconds\":0},{\"type\":\"repeater\",\"part_number\":\"AF99-112\",\"quantity\":10,\"seconds\":1200},{\"type\":\"poweradapter\",\"part_number\":\"MK-0560\",\"quantity\":1,\"seconds\":300}]}}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9968,
"tax_id": 3438,
"item_id": 12152,
"tax_code": "UK",
"tax_percent": 20,
"amount": 641.22,
"base_amount": 754.37,
"real_amount": 641.22,
"real_base_amount": 754.37,
"taxable_item_type": "product"
}
]
}
}
],
"billing_address": {
"address_type": "billing",
"city": "Coventry",
"company": "Spiro",
"country_id": "GB",
"customer_address_id": 6792,
"email": "lbroad@thisisspiro.com",
"entity_id": 12685,
"firstname": "Lauren",
"lastname": "Broad",
"parent_id": 6347,
"postcode": "CV22TA",
"region_id": 0,
"street": [
"Richardson Way"
],
"telephone": "07971981566"
},
"payment": {
"account_status": null,
"additional_information": [
"The sales team will be in touch with payment options."
],
"amount_ordered": 6165.34,
"base_amount_ordered": 7253.35,
"base_shipping_amount": 0,
"cc_exp_year": "0",
"cc_last4": null,
"cc_ss_start_month": "0",
"cc_ss_start_year": "0",
"entity_id": 6344,
"method": "checkmo",
"parent_id": 6347,
"shipping_amount": 0
},
"status_histories": [],
"extension_attributes": {
"shipping_assignments": [
{
"shipping": {
"address": {
"address_type": "shipping",
"city": "Coventry",
"company": "Spiro",
"country_id": "GB",
"customer_address_id": 6792,
"email": "lbroad@thisisspiro.com",
"entity_id": 12684,
"firstname": "Lauren",
"lastname": "Broad",
"parent_id": 6347,
"postcode": "CV22TA",
"region_id": 0,
"street": [
"Richardson Way"
],
"telephone": "07971981566"
},
"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": 1136.31,
"base_price_incl_tax": 1363.57,
"base_row_invoiced": 0,
"base_row_total": 1136.31,
"base_row_total_incl_tax": 2727.14,
"base_tax_amount": 454.52,
"base_tax_invoiced": 0,
"created_at": "2025-03-06 16:10:04",
"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": 12151,
"name": "Lightbox 60",
"no_discount": 0,
"order_id": 6347,
"original_price": 0,
"price": 965.86,
"price_incl_tax": 1159.03,
"product_id": 22,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 2,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 21176,
"row_invoiced": 0,
"row_total": 965.86,
"row_total_incl_tax": 2318.06,
"row_weight": 0,
"sku": "NF-04604",
"store_id": 6,
"tax_amount": 386.34,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-03-14 12:34:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "light_type",
"option_value": "withLight"
},
{
"option_id": "dimmable",
"option_value": "dimmableYes"
},
{
"option_id": "led_type",
"option_value": "ledTypeBrightLed"
},
{
"option_id": "cable_connection",
"option_value": "ukConnection"
},
{
"option_id": "cable_color",
"option_value": "cableColorBlack"
},
{
"option_id": "cable_length",
"option_value": "cableLength2"
},
{
"option_id": "led_color",
"option_value": "ledColor6500"
},
{
"option_id": "cable_exit",
"option_value": "throughBack"
},
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "cable_position",
"option_value": "Bottom"
},
{
"option_id": "accessory_costs",
"option_value": "0"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Size and quantity\",\"value\":\"2000 x 2500 mm - 2x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"2000 x 2500 mm - 2x\",\"ignore_restriction\":false,\"sizes\":{\"width\":2000,\"height\":2500,\"max\":{\"width\":2000,\"height\":2500}},\"quantity\":2}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04604\",\"selected\":{\"id\":\"select-parent-847-1391\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04604\",\"main_sku\":\"NF-04604\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Illuminated or unlit\",\"value\":\"With LED lighting\",\"sku\":null,\"selected\":{\"id\":\"select-parent-848-1395\",\"price\":null,\"value\":\"With LED lighting\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"withLight\",\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Brightness\",\"value\":\"Bright LED\",\"sku\":null,\"selected\":{\"id\":\"select-parent-849-1396\",\"type\":\"ledTypeBrightLed\",\"price\":0,\"value\":\"Bright LED\",\"sku\":null,\"color_type\":\"\",\"main_sku\":null,\"optional_skus\":[],\"ignore_restriction\":false}},{\"name\":\"elem7\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Colour\",\"value\":\"6500K\",\"sku\":null,\"selected\":{\"id\":\"select-parent-850-1397\",\"price\":null,\"value\":\"6500K\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ledColor6500\",\"ignore_restriction\":false}},{\"name\":\"elem8\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Dimmable\",\"value\":\"Dimmable\",\"sku\":null,\"selected\":{\"id\":\"select-parent-851-1400\",\"price\":null,\"value\":\"Dimmable\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"dimmableYes\",\"ignore_restriction\":false}},{\"name\":\"elem9\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Power outlet\",\"value\":\"Through the back \",\"sku\":null,\"selected\":{\"id\":\"select-parent-852-1402\",\"price\":null,\"value\":\"Through the back \",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"throughBack\",\"ignore_restriction\":false}},{\"name\":\"elem10\",\"label\":\"Position cable outlet\",\"value\":\"Bottom\",\"selected\":{\"id\":\"cableHole\",\"radioValue\":\"Bottom\",\"position\":null,\"value\":\"Bottom\",\"ignore_restriction\":false}},{\"name\":\"elem11\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable connection\",\"value\":\"UK connection\",\"sku\":null,\"selected\":{\"id\":\"select-parent-854-1405\",\"price\":null,\"value\":\"UK connection\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ukConnection\",\"ignore_restriction\":false}},{\"name\":\"elem12\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable colour\",\"value\":\"Black\",\"sku\":null,\"selected\":{\"id\":\"select-parent-855-1407\",\"price\":null,\"value\":\"Black\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableColorBlack\",\"ignore_restriction\":false}},{\"name\":\"elem13\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable length\",\"value\":\"2 meters\",\"sku\":null,\"selected\":{\"id\":\"select-parent-856-1409\",\"price\":null,\"value\":\"2 meters\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableLength2\",\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\"},\"sizes\":{\"width\":2000,\"height\":2500,\"max\":{\"width\":2000,\"height\":2500}},\"quantity\":2,\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\",\"cadix\":{\"type\":\"Lightbox 60MM\",\"color\":\"Silver\",\"width\":2000,\"height\":2500,\"quantity\":2,\"poweradapter\":\"UK 2m zwart\",\"power_position\":\"6A\",\"dimmer\":true,\"led_type\":\"FK3\",\"led_color\":\"6500K\",\"seconds\":7632,\"minutes\":127.2,\"total_seconds\":8292,\"total_minutes\":138.2,\"square_meter\":4.76,\"parts\":[{\"type\":\"dibond\",\"part_number\":\"FK-9810\",\"quantity\":2,\"seconds\":1428},{\"type\":\"dibond connector (CM1)\",\"part_number\":\"NF-56290\",\"quantity\":1,\"seconds\":300},{\"type\":\"adapter\",\"part_number\":\"AF99-344-WC\",\"quantity\":5,\"seconds\":1500},{\"type\":\"connector\",\"part_number\":\"AF90-530\",\"quantity\":5,\"seconds\":300},{\"type\":\"LED\",\"part_number\":\"AF92-350\",\"quantity\":15,\"seconds\":342},{\"type\":\"LED\",\"part_number\":\"AF92-345\",\"quantity\":30,\"seconds\":684},{\"type\":\"LED\",\"part_number\":\"AF92-330\",\"quantity\":15,\"seconds\":342},{\"type\":\"Wire cord clip\",\"part_number\":\"FK8220\",\"quantity\":180,\"seconds\":1836},{\"type\":\"dimmer\",\"part_number\":\"AF92-220\",\"quantity\":1,\"seconds\":120},{\"type\":\"remote\",\"part_number\":\"AF92-230\",\"quantity\":1,\"seconds\":0},{\"type\":\"repeater\",\"part_number\":\"AF99-112\",\"quantity\":4,\"seconds\":480},{\"type\":\"poweradapter\",\"part_number\":\"MK-0560\",\"quantity\":1,\"seconds\":300}]}}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9967,
"tax_id": 3438,
"item_id": 12151,
"tax_code": "UK",
"tax_percent": 20,
"amount": 386.34,
"base_amount": 454.52,
"real_amount": 386.34,
"real_base_amount": 454.52,
"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": 1885.92,
"base_price_incl_tax": 2263.11,
"base_row_invoiced": 0,
"base_row_total": 1885.92,
"base_row_total_incl_tax": 4526.21,
"base_tax_amount": 754.37,
"base_tax_invoiced": 0,
"created_at": "2025-03-06 16:10:04",
"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": 12152,
"name": "Lightbox 60",
"no_discount": 0,
"order_id": 6347,
"original_price": 0,
"price": 1603.03,
"price_incl_tax": 1923.64,
"product_id": 22,
"product_type": "configurator",
"qty_canceled": 0,
"qty_invoiced": 0,
"qty_ordered": 2,
"qty_refunded": 0,
"qty_shipped": 0,
"quote_item_id": 21177,
"row_invoiced": 0,
"row_total": 1603.03,
"row_total_incl_tax": 3847.28,
"row_weight": 0,
"sku": "NF-04604",
"store_id": 6,
"tax_amount": 641.22,
"tax_invoiced": 0,
"tax_percent": 20,
"updated_at": "2025-03-14 12:34:34",
"product_option": {
"extension_attributes": {
"custom_options": [
{
"option_id": "light_type",
"option_value": "withLight"
},
{
"option_id": "dimmable",
"option_value": "dimmableYes"
},
{
"option_id": "led_type",
"option_value": "ledTypeBrightLed"
},
{
"option_id": "cable_connection",
"option_value": "ukConnection"
},
{
"option_id": "cable_color",
"option_value": "cableColorBlack"
},
{
"option_id": "cable_length",
"option_value": "cableLength2"
},
{
"option_id": "led_color",
"option_value": "ledColor6500"
},
{
"option_id": "cable_exit",
"option_value": "throughBack"
},
{
"option_id": "color",
"option_value": "silver"
},
{
"option_id": "cable_position",
"option_value": "Bottom"
},
{
"option_id": "accessory_costs",
"option_value": "0"
}
],
"product_config_json": "{\"steps\":[{\"name\":\"elem3\",\"type\":\"checkbox\",\"label\":\"Size and quantity\",\"value\":\"3600 x 2300 mm - 2x\",\"selected\":{\"id\":\"checkbox\",\"price\":0,\"value\":\"3600 x 2300 mm - 2x\",\"ignore_restriction\":false,\"sizes\":{\"width\":3600,\"height\":2300,\"max\":{\"width\":\"3000\",\"height\":2300}},\"quantity\":2}},{\"name\":\"elem4\",\"type\":\"select\",\"is_frame\":true,\"label\":\"Frame colour\",\"value\":\"Silver\",\"sku\":\"NF-04604\",\"selected\":{\"id\":\"select-parent-847-1391\",\"price\":null,\"value\":\"Silver\",\"color_type\":\"silver\",\"sku\":\"NF-04604\",\"main_sku\":\"NF-04604\",\"optional_skus\":[],\"type\":\"default\",\"ignore_restriction\":false}},{\"name\":\"elem5\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Illuminated or unlit\",\"value\":\"With LED lighting\",\"sku\":null,\"selected\":{\"id\":\"select-parent-848-1395\",\"price\":null,\"value\":\"With LED lighting\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"withLight\",\"ignore_restriction\":false}},{\"name\":\"elem6\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Brightness\",\"value\":\"Bright LED\",\"sku\":null,\"selected\":{\"id\":\"select-parent-849-1396\",\"type\":\"ledTypeBrightLed\",\"price\":0,\"value\":\"Bright LED\",\"sku\":null,\"color_type\":\"\",\"main_sku\":null,\"optional_skus\":[],\"ignore_restriction\":false}},{\"name\":\"elem7\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Colour\",\"value\":\"6500K\",\"sku\":null,\"selected\":{\"id\":\"select-parent-850-1397\",\"price\":null,\"value\":\"6500K\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ledColor6500\",\"ignore_restriction\":false}},{\"name\":\"elem8\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Dimmable\",\"value\":\"Dimmable\",\"sku\":null,\"selected\":{\"id\":\"select-parent-851-1400\",\"price\":null,\"value\":\"Dimmable\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"dimmableYes\",\"ignore_restriction\":false}},{\"name\":\"elem9\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Power outlet\",\"value\":\"Through the back \",\"sku\":null,\"selected\":{\"id\":\"select-parent-852-1402\",\"price\":null,\"value\":\"Through the back \",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"throughBack\",\"ignore_restriction\":false}},{\"name\":\"elem10\",\"label\":\"Position cable outlet\",\"value\":\"Bottom\",\"selected\":{\"id\":\"cableHole\",\"radioValue\":\"Bottom\",\"position\":null,\"value\":\"Bottom\",\"ignore_restriction\":false}},{\"name\":\"elem11\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable connection\",\"value\":\"UK connection\",\"sku\":null,\"selected\":{\"id\":\"select-parent-854-1405\",\"price\":null,\"value\":\"UK connection\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"ukConnection\",\"ignore_restriction\":false}},{\"name\":\"elem12\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable colour\",\"value\":\"Black\",\"sku\":null,\"selected\":{\"id\":\"select-parent-855-1407\",\"price\":null,\"value\":\"Black\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableColorBlack\",\"ignore_restriction\":false}},{\"name\":\"elem13\",\"type\":\"select\",\"is_frame\":false,\"label\":\"Cable length\",\"value\":\"2 meters\",\"sku\":null,\"selected\":{\"id\":\"select-parent-856-1409\",\"price\":null,\"value\":\"2 meters\",\"color_type\":\"\",\"sku\":null,\"main_sku\":null,\"optional_skus\":[],\"type\":\"cableLength2\",\"ignore_restriction\":false}}],\"reference\":null,\"options\":{\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\"},\"sizes\":{\"width\":3600,\"height\":2300,\"max\":{\"width\":\"3000\",\"height\":2300}},\"quantity\":2,\"light_type\":\"withLight\",\"dimmable\":\"dimmableYes\",\"led_type\":\"ledTypeBrightLed\",\"cable_connection\":\"ukConnection\",\"cable_color\":\"cableColorBlack\",\"cable_length\":\"cableLength2\",\"led_color\":\"ledColor6500\",\"cable_exit\":\"throughBack\",\"color\":\"silver\",\"cable_position\":\"Bottom\",\"cadix\":{\"type\":\"Lightbox 60MM\",\"color\":\"Silver\",\"width\":3600,\"height\":2300,\"quantity\":2,\"poweradapter\":\"UK 2m zwart\",\"power_position\":\"6A\",\"dimmer\":true,\"led_type\":\"FK3\",\"led_color\":\"6500K\",\"seconds\":12093,\"minutes\":201.6,\"total_seconds\":12753,\"total_minutes\":212.6,\"square_meter\":7.964,\"parts\":[{\"type\":\"dibond\",\"part_number\":\"FK-9810\",\"quantity\":3,\"seconds\":2389.2},{\"type\":\"dibond connector (CM1)\",\"part_number\":\"NF-56290\",\"quantity\":2,\"seconds\":600},{\"type\":\"adapter\",\"part_number\":\"AF99-342-WC\",\"quantity\":11,\"seconds\":3300},{\"type\":\"connector\",\"part_number\":\"AF90-520\",\"quantity\":11,\"seconds\":660},{\"type\":\"LED\",\"part_number\":\"AF92-350\",\"quantity\":44,\"seconds\":1003.2},{\"type\":\"LED\",\"part_number\":\"AF92-340\",\"quantity\":22,\"seconds\":501.6},{\"type\":\"Wire cord clip\",\"part_number\":\"FK8220\",\"quantity\":198,\"seconds\":2019.6},{\"type\":\"dimmer\",\"part_number\":\"AF92-220\",\"quantity\":1,\"seconds\":120},{\"type\":\"remote\",\"part_number\":\"AF92-230\",\"quantity\":1,\"seconds\":0},{\"type\":\"repeater\",\"part_number\":\"AF99-112\",\"quantity\":10,\"seconds\":1200},{\"type\":\"poweradapter\",\"part_number\":\"MK-0560\",\"quantity\":1,\"seconds\":300}]}}"
}
},
"extension_attributes": {
"itemized_taxes": [
{
"tax_item_id": 9968,
"tax_id": 3438,
"item_id": 12152,
"tax_code": "UK",
"tax_percent": 20,
"amount": 641.22,
"base_amount": 754.37,
"real_amount": 641.22,
"real_base_amount": 754.37,
"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": 1027.56,
"base_amount": 1208.89
}
],
"item_applied_taxes": [
{
"type": "shipping",
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 0,
"base_amount": 0
}
]
},
{
"type": "product",
"item_id": 12151,
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 386.34,
"base_amount": 454.52
}
]
},
{
"type": "product",
"item_id": 12152,
"applied_taxes": [
{
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 641.22,
"base_amount": 754.37
}
]
}
],
"converting_from_quote": false,
"taxes": [
{
"tax_id": 3438,
"order_id": 6347,
"code": "UK",
"title": "UK",
"percent": 20,
"amount": 1027.56,
"base_amount": 1208.89,
"base_real_amount": 1208.89,
"priority": 0,
"position": 0,
"process": 0
}
],
"additional_itemized_taxes": [
{
"tax_item_id": 9969,
"tax_id": 3438,
"tax_code": "UK",
"tax_percent": 20,
"amount": 0,
"base_amount": 0,
"real_amount": 0,
"real_base_amount": 0,
"taxable_item_type": "shipping"
}
],
"files": [],
"additional_shipping_information": {
"order_id": 6347,
"route_id": 0,
"desired_delivery_datetime": "2025-04-04 00:00:00",
"shipping_datetime": "2025-04-03 00:00:00"
},
"order_reference": "Alphasigma @ BSR",
"customer_company": "Spiro",
"mollie_payment_fee": 0,
"base_mollie_payment_fee": 0,
"mollie_payment_fee_tax": 0,
"base_mollie_payment_fee_tax": 0
}
}