| 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"
}
}
]
}
},
"suggest": {
"text": ""
},
"_source": [
"search-result-data"
],
"from": 252,
"size": 12,
"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": {
"page": "22"
}
}
|
{
"facets": {
"category": {},
"rating": {},
"label": {},
"farbe": {},
"material": {},
"brand": {},
"merchant_name": {}
},
"sort": {},
"pagination": {},
"products": [
{
"images": [
{
"fk_product_image_set": 248,
"id_product_image": 916,
"alt_text_small": "",
"product_image_key": "product_image_916",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 916,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 916
},
{
"fk_product_image_set": 248,
"id_product_image": 918,
"alt_text_small": "",
"product_image_key": "product_image_918",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 918,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 918
}
],
"id_product_labels": [],
"price": 541,
"abstract_name": "Clairefontaine notebook DIN A6 90 g, 96 sheets, sorted",
"id_product_abstract": 127,
"type": "product_abstract",
"add_to_cart_sku": "421418",
"prices": {
"DEFAULT": 541
},
"abstract_sku": "M21708",
"url": "\/en\/clairefontaine-kladde-din-a6-90g-96blatt-sortiert-M21708"
},
{
"images": [
{
"fk_product_image_set": 252,
"id_product_image": 922,
"alt_text_small": "",
"product_image_key": "product_image_922",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109P?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109P",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 922,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 922
},
{
"fk_product_image_set": 252,
"id_product_image": 924,
"alt_text_small": "",
"product_image_key": "product_image_924",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109Q?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109Q",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 924,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 924
},
{
"fk_product_image_set": 252,
"id_product_image": 926,
"alt_text_small": "",
"product_image_key": "product_image_926",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109R?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007109R",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 926,
"sort_order": 5,
"alt_text_large": "",
"fk_product_image": 926
},
{
"fk_product_image_set": 252,
"id_product_image": 928,
"alt_text_small": "",
"product_image_key": "product_image_928",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 928,
"sort_order": 7,
"alt_text_large": "",
"fk_product_image": 928
},
{
"fk_product_image_set": 252,
"id_product_image": 930,
"alt_text_small": "",
"product_image_key": "product_image_930",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 930,
"sort_order": 9,
"alt_text_large": "",
"fk_product_image": 930
}
],
"id_product_labels": [],
"price": 1024,
"abstract_name": "Clairefontaine notebook DIN A4, 96 sheets, sorted",
"id_product_abstract": 129,
"type": "product_abstract",
"add_to_cart_sku": "421428",
"prices": {
"DEFAULT": 1024
},
"abstract_sku": "M21713",
"url": "\/en\/clairefontaine-kladde-din-a4-90g-96blatt-sortiert-M21713"
},
{
"images": [
{
"fk_product_image_set": 254,
"id_product_image": 932,
"alt_text_small": "",
"product_image_key": "product_image_932",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007761W",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 932,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 932
}
],
"id_product_labels": [],
"price": 1004,
"abstract_name": "Clairefontaine Meetingblock 328000C DIN A4, 80 sheets, color sorted",
"id_product_abstract": 130,
"type": "product_abstract",
"add_to_cart_sku": "421432",
"prices": {
"DEFAULT": 1004
},
"abstract_sku": "M21714",
"url": "\/en\/clairefontaine-meetingblock-328000c-din-a4-80blatt-farbig-sortiert-M21714"
},
{
"images": [
{
"fk_product_image_set": 256,
"id_product_image": 934,
"alt_text_small": "",
"product_image_key": "product_image_934",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762B?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762B",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 934,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 934
},
{
"fk_product_image_set": 256,
"id_product_image": 936,
"alt_text_small": "",
"product_image_key": "product_image_936",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762A?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762A",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 936,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 936
}
],
"id_product_labels": [],
"price": 580,
"abstract_name": "Clairefontaine Spiralblock DIN A4, 90 sheets",
"id_product_abstract": 131,
"type": "product_abstract",
"add_to_cart_sku": "421433",
"prices": {
"DEFAULT": 580
},
"abstract_sku": "M21715",
"url": "\/en\/clairefontaine-spiralblock-din-a4-90blatt-M21715"
},
{
"images": [
{
"fk_product_image_set": 258,
"id_product_image": 938,
"alt_text_small": "",
"product_image_key": "product_image_938",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007772E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007772E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 938,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 938
}
],
"id_product_labels": [],
"price": 649,
"abstract_name": "Clairefontaine Collegeblock 328626C DIN A4, 80 sheets, checkered",
"id_product_abstract": 132,
"type": "product_abstract",
"add_to_cart_sku": "421435",
"prices": {
"DEFAULT": 649
},
"abstract_sku": "M21716",
"url": "\/en\/clairefontaine-collegeblock-328626c-din-a4-80blatt-kariert-M21716"
},
{
"images": [
{
"fk_product_image_set": 260,
"id_product_image": 940,
"alt_text_small": "",
"product_image_key": "product_image_940",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762C?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007762C",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 940,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 940
}
],
"id_product_labels": [],
"price": 245,
"abstract_name": "Clairefontaine Spiralblock 328725C DIN 17x22 mm, 50 sheets, checkered",
"id_product_abstract": 133,
"type": "product_abstract",
"add_to_cart_sku": "421436",
"prices": {
"DEFAULT": 245
},
"abstract_sku": "M21717",
"url": "\/en\/clairefontaine-spiralblock-328725c-17x22mm-50blatt-kariert-M21717"
},
{
"images": [
{
"fk_product_image_set": 262,
"id_product_image": 942,
"alt_text_small": "",
"product_image_key": "product_image_942",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005E?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005E",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 942,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 942
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904694, 0.35 mm, black",
"id_product_abstract": 134,
"type": "product_abstract",
"add_to_cart_sku": "421475",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21740",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904694-0-35mm-schwarz-M21740"
},
{
"images": [
{
"fk_product_image_set": 264,
"id_product_image": 944,
"alt_text_small": "",
"product_image_key": "product_image_944",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005F?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005F",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 944,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 944
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904695 0.5 mm, black",
"id_product_abstract": 135,
"type": "product_abstract",
"add_to_cart_sku": "421476",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21741",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904695-0-5mm-schwarz-M21741"
},
{
"images": [
{
"fk_product_image_set": 266,
"id_product_image": 946,
"alt_text_small": "",
"product_image_key": "product_image_946",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005G?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005G",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 946,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 946
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904696 0.7 mm, black",
"id_product_abstract": 136,
"type": "product_abstract",
"add_to_cart_sku": "421477",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21742",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904696-0-7mm-schwarz-M21742"
},
{
"images": [
{
"fk_product_image_set": 268,
"id_product_image": 948,
"alt_text_small": "",
"product_image_key": "product_image_948",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 948,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 948
}
],
"id_product_labels": [],
"price": 393,
"abstract_name": "rotring mechanical pencil Tikky RD 1904697, 1 mm, black",
"id_product_abstract": 137,
"type": "product_abstract",
"add_to_cart_sku": "421478",
"prices": {
"DEFAULT": 393
},
"abstract_sku": "M21743",
"url": "\/en\/rotring-druckbleistift-tikky-rd-1904697-1mm-schwarz-M21743"
},
{
"images": [
{
"fk_product_image_set": 270,
"id_product_image": 950,
"alt_text_small": "",
"product_image_key": "product_image_950",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075H?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075H",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 950,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 950
},
{
"fk_product_image_set": 270,
"id_product_image": 952,
"alt_text_small": "",
"product_image_key": "product_image_952",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075G?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075G",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 952,
"sort_order": 3,
"alt_text_large": "",
"fk_product_image": 952
}
],
"id_product_labels": [],
"price": 442,
"abstract_name": "rotring ballpoint pen Tikky Redesign M",
"id_product_abstract": 138,
"type": "product_abstract",
"add_to_cart_sku": "421479",
"prices": {
"DEFAULT": 442
},
"abstract_sku": "M21744",
"url": "\/en\/rotring-kugelschreiber-tikky-redesign-m-M21744"
},
{
"images": [
{
"fk_product_image_set": 272,
"id_product_image": 954,
"alt_text_small": "",
"product_image_key": "product_image_954",
"updated_at": "2025-12-02 09:55:14.000000",
"external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W?$normal$",
"external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W",
"created_at": "2025-12-02 09:55:14.000000",
"id_product_image_set_to_product_image": 954,
"sort_order": 1,
"alt_text_large": "",
"fk_product_image": 954
}
],
"id_product_labels": [],
"price": 1182,
"abstract_name": "rotring mechanical pencil Tikky S0801310, 3 pieces\/pack",
"id_product_abstract": 139,
"type": "product_abstract",
"add_to_cart_sku": "421481",
"prices": {
"DEFAULT": 1182
},
"abstract_sku": "M21745",
"url": "\/en\/rotring-druckbleistift-tikky-s0801310-3-st-pack-M21745"
}
],
"spellingSuggestion": null,
"categoryTreeFilter": {
"0": {},
"1": {},
"2": {},
"3": {},
"4": {},
"5": {}
}
}
|