| Http://search:9200 |
{
"query": {
"query": {
"bool": {
"must": [
{
"match_all": {}
},
{
"match": {
"type": "product_abstract"
}
},
{
"match": {
"store": "DE"
}
},
{
"match": {
"locale": "en_US"
}
},
{
"match": {
"is-active": true
}
},
{
"bool": {
"should": [
{
"range": {
"active-from": {
"lte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-from"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"active-to": {
"gte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-to"
}
}
]
}
}
]
}
}
],
"filter": [
{
"nested": {
"query": {
"term": {
"integer-facet.facet-name": {
"value": "price-DEFAULT-EUR-GROSS_MODE",
"boost": 1
}
}
},
"path": "integer-facet"
}
},
{
"term": {
"category.all-parents": {
"value": "26",
"boost": 1
}
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"sort": [
{
"integer-sort.category:26": {
"order": "ASC",
"mode": "min",
"unmapped_type": "integer"
}
}
],
"from": 0,
"size": 12,
"aggs": {
"category.all-parents.category": {
"terms": {
"field": "category.all-parents",
"size": 1000
}
},
"global-category": {
"global": {},
"aggs": {
"filter": {
"filter": {
"bool": {
"must": [
{
"match_all": {}
},
{
"match": {
"type": "product_abstract"
}
},
{
"match": {
"store": "DE"
}
},
{
"match": {
"locale": "en_US"
}
},
{
"match": {
"is-active": true
}
},
{
"bool": {
"should": [
{
"range": {
"active-from": {
"lte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-from"
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"range": {
"active-to": {
"gte": "now"
}
}
},
{
"bool": {
"must_not": [
{
"exists": {
"field": "active-to"
}
}
]
}
}
]
}
}
],
"filter": [
{
"nested": {
"query": {
"term": {
"integer-facet.facet-name": {
"value": "price-DEFAULT-EUR-GROSS_MODE",
"boost": 1
}
}
},
"path": "integer-facet"
}
}
]
}
},
"aggs": {
"category.all-parents.category": {
"terms": {
"field": "category.all-parents",
"size": 1000
}
}
}
}
}
},
"integer-facet": {
"nested": {
"path": "integer-facet"
},
"aggs": {
"integer-facet-name": {
"terms": {
"field": "integer-facet.facet-name",
"size": 10
},
"aggs": {
"integer-facet-stats": {
"stats": {
"field": "integer-facet.facet-value"
}
}
}
}
}
},
"string-facet": {
"nested": {
"path": "string-facet"
},
"aggs": {
"string-facet-name": {
"terms": {
"field": "string-facet.facet-name",
"size": 10
},
"aggs": {
"string-facet-value": {
"terms": {
"field": "string-facet.facet-value",
"size": 10
}
}
}
}
}
}
}
},
"parameters": {
"category": 26
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 290,
"id_product_image": 992,
"alt_text_small": "",
"product_image_key": "product_image_992",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518O",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 992,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 992
}
],
"id_product_labels": [
2
],
"price": 3086,
"abstract_name": "Veloflex table flipchart 4132280 DIN A3 crosswise, 4 rings, 10 covers, black",
"id_product_abstract": 148,
"type": "product_abstract",
"add_to_cart_sku": "421540",
"prices": {
"DEFAULT": 3086
},
"abstract_sku": "M21779",
"url": "\/en\/veloflex-tischflipchart-4132280-din-a3-quer-4ringe-10huellen-schwarz-M21779"
},
{
"images": [
{
"fk_product_image_set": 286,
"id_product_image": 986,
"alt_text_small": "",
"product_image_key": "product_image_986",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021O?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021O",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 986,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 986
},
{
"fk_product_image_set": 286,
"id_product_image": 988,
"alt_text_small": "",
"product_image_key": "product_image_988",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518Q",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 988,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 988
}
],
"id_product_labels": [],
"price": 1437,
"abstract_name": "Veloflex table flipchart 4101080 DIN A4 crosswise, 4 rings, 10 covers, black",
"id_product_abstract": 146,
"type": "product_abstract",
"add_to_cart_sku": "421538",
"prices": {
"DEFAULT": 1437
},
"abstract_sku": "M21777",
"url": "\/en\/veloflex-tischflipchart-4101080-din-a4-quer-4ringe-10huellen-schwarz-M21777"
},
{
"images": [
{
"fk_product_image_set": 288,
"id_product_image": 990,
"alt_text_small": "",
"product_image_key": "product_image_990",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007039A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007039A",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 990,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 990
}
],
"id_product_labels": [],
"price": 1437,
"abstract_name": "Veloflex table flipchart V4102080 DIN A4 crosswise 4 rings, 10 covers, black",
"id_product_abstract": 147,
"type": "product_abstract",
"add_to_cart_sku": "421539",
"prices": {
"DEFAULT": 1437
},
"abstract_sku": "M21778",
"url": "\/en\/veloflex-tischflipchart-v4102080-din-a4-hoch-4ringe-10huellen-schwarz-M21778"
},
{
"images": [
{
"fk_product_image_set": 448,
"id_product_image": 1528,
"alt_text_small": "",
"product_image_key": "product_image_1528",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006114R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006114R",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1528,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1528
}
],
"id_product_labels": [],
"price": 7344,
"abstract_name": "Franken flipchart Standard X-tra Line Plus EL-FC22 105x68 cm, gray",
"id_product_abstract": 235,
"type": "product_abstract",
"add_to_cart_sku": "426376",
"prices": {
"DEFAULT": 7344
},
"abstract_sku": "M24416",
"url": "\/en\/franken-flipchart-standard-x-tra-line-plus-el-fc22-105x68cm-grau-M24416"
},
{
"images": [
{
"fk_product_image_set": 450,
"id_product_image": 1530,
"alt_text_small": "",
"product_image_key": "product_image_1530",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074T?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074T",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1530,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1530
}
],
"id_product_labels": [],
"price": 13448,
"abstract_name": "Franken Flipchart Standard Deluxe FC84 67x95 cm, light gray",
"id_product_abstract": 236,
"type": "product_abstract",
"add_to_cart_sku": "426377",
"prices": {
"DEFAULT": 13448
},
"abstract_sku": "M24417",
"url": "\/en\/franken-flipchart-standard-deluxe-fc84-67x95cm-hellgrau-M24417"
},
{
"images": [
{
"fk_product_image_set": 60,
"id_product_image": 176,
"alt_text_small": "",
"product_image_key": "product_image_176",
"updated_at": "2025-12-02 09:55:09.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031524F-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031524F-03",
"created_at": "2025-12-02 09:55:09.000000",
"id_product_image_set_to_product_image": 176,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 176
},
{
"fk_product_image_set": 60,
"id_product_image": 178,
"alt_text_small": "",
"product_image_key": "product_image_178",
"updated_at": "2025-12-02 09:55:09.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031524-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031524-01",
"created_at": "2025-12-02 09:55:09.000000",
"id_product_image_set_to_product_image": 178,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 178
}
],
"id_product_labels": [
5
],
"price": 21993,
"abstract_name": "Smit visual flipchart - for double rail system",
"id_product_abstract": 28,
"type": "product_abstract",
"add_to_cart_sku": "101509",
"prices": {
"DEFAULT": 21993,
"ORIGINAL": 24436
},
"abstract_sku": "M1014948",
"url": "\/en\/flipchart-fuer-doppel-schienensystem-M1014948"
},
{
"images": [
{
"fk_product_image_set": 134,
"id_product_image": 512,
"alt_text_small": "",
"product_image_key": "product_image_512",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926275II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926275II-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 512,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 512
},
{
"fk_product_image_set": 134,
"id_product_image": 514,
"alt_text_small": "",
"product_image_key": "product_image_514",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 514,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 514
},
{
"fk_product_image_set": 134,
"id_product_image": 516,
"alt_text_small": "",
"product_image_key": "product_image_516",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-03",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 516,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 516
}
],
"id_product_labels": [
5
],
"price": 13682,
"abstract_name": "Smit visual flip chart - floor model with side arms",
"id_product_abstract": 65,
"type": "product_abstract",
"add_to_cart_sku": "100430",
"prices": {
"DEFAULT": 13682,
"ORIGINAL": 15202
},
"abstract_sku": "M11222",
"url": "\/en\/flip-chart-standmodell-mit-seitenarmen-M11222"
},
{
"images": [
{
"fk_product_image_set": 452,
"id_product_image": 1532,
"alt_text_small": "",
"product_image_key": "product_image_1532",
"updated_at": "2025-12-02 09:55:18.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007074R",
"created_at": "2025-12-02 09:55:18.000000",
"id_product_image_set_to_product_image": 1532,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1532
}
],
"id_product_labels": [
4,
5
],
"price": 19099,
"abstract_name": "Franken Flipchart Mobile Deluxe FC81 67x95 cm, round foot, light gray",
"rating": 4,
"id_product_abstract": 237,
"review_count": 6,
"type": "product_abstract",
"add_to_cart_sku": "426378",
"prices": {
"DEFAULT": 19099,
"ORIGINAL": 21221
},
"abstract_sku": "M24418",
"url": "\/en\/franken-flipchart-mobile-deluxe-fc81-67x95cm-rundfuss-hellgrau-M24418"
},
{
"images": [
{
"fk_product_image_set": 532,
"id_product_image": 1674,
"alt_text_small": "",
"product_image_key": "product_image_1674",
"updated_at": "2025-12-02 09:55:19.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-01",
"created_at": "2025-12-02 09:55:19.000000",
"id_product_image_set_to_product_image": 1674,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1674
},
{
"fk_product_image_set": 532,
"id_product_image": 1676,
"alt_text_small": "",
"product_image_key": "product_image_1676",
"updated_at": "2025-12-02 09:55:19.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926273II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926273II-01",
"created_at": "2025-12-02 09:55:19.000000",
"id_product_image_set_to_product_image": 1676,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 1676
},
{
"fk_product_image_set": 532,
"id_product_image": 1678,
"alt_text_small": "",
"product_image_key": "product_image_1678",
"updated_at": "2025-12-02 09:55:19.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052674-02",
"created_at": "2025-12-02 09:55:19.000000",
"id_product_image_set_to_product_image": 1678,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 1678
}
],
"id_product_labels": [
5
],
"price": 8364,
"abstract_name": "Smit visual flip chart - height-adjustable with telescope legs",
"id_product_abstract": 277,
"type": "product_abstract",
"add_to_cart_sku": "100429",
"prices": {
"DEFAULT": 8364,
"ORIGINAL": 9293
},
"abstract_sku": "M39654",
"url": "\/en\/flip-chart-hoehenverstellbar-mit-teleskopbeinen-M39654"
},
{
"images": [
{
"fk_product_image_set": 322,
"id_product_image": 1108,
"alt_text_small": "",
"product_image_key": "product_image_1108",
"updated_at": "2025-12-02 09:55:15.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007395I?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007395I",
"created_at": "2025-12-02 09:55:15.000000",
"id_product_image_set_to_product_image": 1108,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 1108
}
],
"id_product_labels": [],
"price": 5487,
"abstract_name": "Soennecken flipchart 1134 68x105 cm tripod gray",
"id_product_abstract": 168,
"type": "product_abstract",
"add_to_cart_sku": "423237",
"prices": {
"DEFAULT": 5487
},
"abstract_sku": "M22682",
"url": "\/en\/soennecken-flipchart-1134-68x105cm-dreibeinstativ-grau-M22682"
},
{
"images": [
{
"fk_product_image_set": 22,
"id_product_image": 68,
"alt_text_small": "",
"product_image_key": "product_image_68",
"updated_at": "2025-12-02 09:55:08.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01",
"created_at": "2025-12-02 09:55:08.000000",
"id_product_image_set_to_product_image": 68,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 68
}
],
"id_product_labels": [],
"price": 13725,
"abstract_name": "magnetoplan\u00ae Flipchart JUNIOR PLUS - writing surface 680 x 980 mm, magnetic",
"id_product_abstract": 11,
"type": "product_abstract",
"add_to_cart_sku": "517598",
"prices": {
"DEFAULT": 13725
},
"abstract_sku": "M1013168",
"url": "\/en\/magnetoplan-flipchart-junior-plus-schreibflaeche-680-x-980-mm-magnethaftend-M1013168"
},
{
"images": [
{
"fk_product_image_set": 110,
"id_product_image": 420,
"alt_text_small": "",
"product_image_key": "product_image_420",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 420,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 420
},
{
"fk_product_image_set": 110,
"id_product_image": 422,
"alt_text_small": "",
"product_image_key": "product_image_422",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 422,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 422
},
{
"fk_product_image_set": 110,
"id_product_image": 424,
"alt_text_small": "",
"product_image_key": "product_image_424",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 424,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 424
},
{
"fk_product_image_set": 110,
"id_product_image": 426,
"alt_text_small": "",
"product_image_key": "product_image_426",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 426,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 426
},
{
"fk_product_image_set": 110,
"id_product_image": 428,
"alt_text_small": "",
"product_image_key": "product_image_428",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 428,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 428
},
{
"fk_product_image_set": 110,
"id_product_image": 430,
"alt_text_small": "",
"product_image_key": "product_image_430",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 430,
"sort_order": 11,
"alt_text_large": "",
"fk_product_image": 430
},
{
"fk_product_image_set": 110,
"id_product_image": 432,
"alt_text_small": "",
"product_image_key": "product_image_432",
"updated_at": "2025-12-02 09:55:11.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07",
"created_at": "2025-12-02 09:55:11.000000",
"id_product_image_set_to_product_image": 432,
"sort_order": 13,
"alt_text_large": "",
"fk_product_image": 432
}
],
"id_product_labels": [],
"price": 19888,
"abstract_name": "magnetoplan\u00ae Flipchart DE LUXE - mobile",
"id_product_abstract": 53,
"type": "product_abstract",
"add_to_cart_sku": "408034",
"prices": {
"DEFAULT": 19888
},
"abstract_sku": "M1031236",
"url": "\/en\/magnetoplan-flipchart-de-luxe-mobil-M1031236"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|