| 1 |
4.63 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"19f788f18d0c4b26a3e6c44447742268"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["5494b24b09d445ebace47112836b4458","de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 21,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "02a3187f1cc04e3eb5927333bcdfd3e3",
"_score": null,
"_source": {
"id": "02a3187f1cc04e3eb5927333bcdfd3e3",
"autoIncrement": 67186.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1004,
"productNumber": "5731.7",
"ean": null,
"displayGroup": "04c9644b8aa38f2165f8dd8a1e3193e4",
"sales": 0,
"stock": 1004,
"weight": 0.2,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "TT10760",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"356a4a2234f94af7b8ec77a57731335e",
"19f788f18d0c4b26a3e6c44447742268",
"435e789f5fa14f5a828e390d940d4cdc",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5",
"ff26c879706241e8b79d126177a806bc"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
},
{
"id": "435e789f5fa14f5a828e390d940d4cdc",
"_count": 1
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1
},
{
"id": "ff26c879706241e8b79d126177a806bc",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "8bec4a0a29c44b6eab7435e875fc630a",
"coverId": "6fe2234601d0458cb002f962a2468cba",
"childCount": 0,
"categories": [
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe"
}
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe",
"de44571ddc4e4d0095c01af6ee299351": "Downpipes"
}
},
{
"id": "435e789f5fa14f5a828e390d940d4cdc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Accessories"
}
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "ff26c879706241e8b79d126177a806bc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Silenciador universal",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Universal Schalld\u00e4mpfer",
"5494b24b09d445ebace47112836b4458": "Silencieux universel",
"de44571ddc4e4d0095c01af6ee299351": "Universal Silencer"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "90051cdd03514a33b6e3accea609eca9",
"_count": 1,
"groupId": "7b846261d30c4e268d7e8c7321242bfd",
"group": {
"id": "7b846261d30c4e268d7e8c7321242bfd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 mm",
"5494b24b09d445ebace47112836b4458": "51 mm",
"de44571ddc4e4d0095c01af6ee299351": "51 mm"
}
}
],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268",
"435e789f5fa14f5a828e390d940d4cdc",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5",
"ff26c879706241e8b79d126177a806bc"
],
"optionIds": [
"90051cdd03514a33b6e3accea609eca9"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "3 zoll kit 19 netto Daisy",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "V-Band Schelle",
"migration_Shopware5DB_product_bullet1": "Anschweissringe mit NUT und FEDER",
"migration_Shopware5DB_product_bullet2": "V-Band Schelle aus Edelstahl ",
"migration_Shopware5DB_product_bullet3": "Perfekte Montage der Auspuffanlage",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "abgasrohr-vband-schelle-auspuff-nut-feder",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Auspuff Schelle Edelstahl Nut & Feder Set",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "3 zoll kit 19 netto Daisy",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "V-Band Schelle",
"migration_Shopware5DB_product_bullet1": "Anschweissringe mit NUT und FEDER",
"migration_Shopware5DB_product_bullet2": "V-Band Schelle aus Edelstahl ",
"migration_Shopware5DB_product_bullet3": "Perfekte Montage der Auspuffanlage",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Auspuff Schelle Edelstahl Nut & Feder Set",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "3 zoll kit 19 netto Daisy",
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "V-band clamp",
"migration_Shopware5DB_product_bullet1": "Welding rings with NUT and SPRING",
"migration_Shopware5DB_product_bullet2": "Stainless steel V-band clamp ",
"migration_Shopware5DB_product_bullet3": "Perfect assembly of the exhaust system",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "V-Band Auspuff Schelle Edelstahl Nut & Feder Set",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Auspuff Schelle Edelstahl Nut & Feder Set",
"5494b24b09d445ebace47112836b4458": "Collier d'\u00e9chappement V-Band Ensemble de languettes et de rainures en acier inoxydable",
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp stainless steel male & female set"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Schelle mit Anschweissringen zur perfekten Montage von Auspuffanlagen. Anschweissringe mit NUT unf FEDER sorgen f\u00fcr eine 100%ige Ausrichtung. Auch genannt Male & Female. Mit der hochwertigen V-Band Schelle aus Edelstahl lassen sich s\u00e4mtlichen Verbindungen an der Auspuffanlage schnell und einfach montieren. Auch f\u00fcr Downpipes, Katalysatoren oder Turbolader Montage m\u00f6glich. Die jeweilige Gr\u00f6\u00dfe bezieht sich auf den Innendurchmesser.",
"5494b24b09d445ebace47112836b4458": "Pince \u00e0 bande en V avec anneaux de soudure pour un montage parfait des syst\u00e8mes d'\u00e9chappement. Des anneaux soud\u00e9s avec rainure et ressort assurent un alignement \u00e0 100%. Aussi appel\u00e9 Male & Female. Gr\u00e2ce \u00e0 la pince \u00e0 bande en V de haute qualit\u00e9 en acier inoxydable, tous les raccords du syst\u00e8me d'\u00e9chappement peuvent \u00eatre mont\u00e9s rapidement et facilement. Egalement possible pour les tuyaux de descente, les convertisseurs catalytiques ou l'assemblage de turbocompresseurs. La taille respective se r\u00e9f\u00e8re au diam\u00e8tre int\u00e9rieur.",
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel exhaust V-band clamps. The inner rings have the new male\/female combination for perfekt connection. The size refers to the inner diameter."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-Band Auspuff Schelle Edelstahl Nut & Feder Set",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "V-band exhaust clamp stainless steel tongue & groove set"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.05,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.168066,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.278002,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.2,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.8615,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.85,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.35,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.663864,
"shop-customer": "24.663864",
"a-dealer": "15.168066",
"b-dealer": "16.2",
"c-dealer": "15.85"
},
"fields": {
"displayGroup": [
"04c9644b8aa38f2165f8dd8a1e3193e4"
]
},
"sort": [
"true",
0,
"02a3187f1cc04e3eb5927333bcdfd3e3"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "24e30a7414824b289152b4eebb0eef45",
"_score": null,
"_source": {
"id": "24e30a7414824b289152b4eebb0eef45",
"autoIncrement": 60467.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1,
"productNumber": "31600033",
"ean": "4260630976748",
"displayGroup": "f9fbcf381e70984838b028de96966946",
"sales": 0,
"stock": 1,
"weight": 0.4,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "Enzo 350103",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"356a4a2234f94af7b8ec77a57731335e",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
},
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "19d1bff0e69b481ba1295d913b0613bf",
"childCount": 0,
"categories": [
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bridas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flansche",
"5494b24b09d445ebace47112836b4458": " Brides",
"de44571ddc4e4d0095c01af6ee299351": "Flange"
}
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe"
}
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe",
"de44571ddc4e4d0095c01af6ee299351": "Downpipes"
}
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "102mm-vband-schelle-clamp",
"migration_Shopware5DB_product_dreisc_seo_title": "102mm 4\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "102mm 4\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "108mm-4-v-band-clamp",
"migration_Shopware5DB_product_dreisc_seo_title": "102mm 4\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "102mm 4\" V-Band Schelle",
"5494b24b09d445ebace47112836b4458": "108mm 4,25\" Pince pour bande V",
"de44571ddc4e4d0095c01af6ee299351": "108mm 4,25\" V-Band Clamp"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl V-band Schelle f\u00fcr 102mm 4\" V-Band Flansch.",
"5494b24b09d445ebace47112836b4458": "Acier inoxydable Pince pour bande en V pour bride en V de 108 mm 4,25\".",
"de44571ddc4e4d0095c01af6ee299351": "4,25\" V-Band Clamp for 108mm V-Band flange. -stainless steel -high quality"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "102mm 4\" V-Band Schelle ",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "102mm 4\" V-Band Clamp"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.5,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 23.95,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 26.75,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.47899,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 28.322,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 23.8,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 31.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 26.428572,
"shop-customer": "26.428572",
"c-dealer": "23.95",
"a-dealer": "22.47899",
"b-dealer": "23.8"
},
"fields": {
"displayGroup": [
"f9fbcf381e70984838b028de96966946"
]
},
"sort": [
"true",
0,
"24e30a7414824b289152b4eebb0eef45"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "2a39d75a8e7f4038b37ca731c5e0a430",
"_score": null,
"_source": {
"id": "2a39d75a8e7f4038b37ca731c5e0a430",
"autoIncrement": 63154.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1007,
"productNumber": "2100544.1",
"ean": null,
"displayGroup": "99ae07c824aca37717b19bd82e8e668c",
"sales": 0,
"stock": 1007,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "201458",
"releaseDate": null,
"createdAt": "2021-11-04T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"19f788f18d0c4b26a3e6c44447742268"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "8b191941c78048aa8fe00603272476dd",
"coverId": "cccfb14018a44a09b1619a140ae574ed",
"childCount": 0,
"categories": [
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "dc49e6ac807f4309b64db18941b0fdcf",
"_count": 1,
"groupId": "7d744fc2ef344e23ba93ea37876ddd23",
"group": {
"id": "7d744fc2ef344e23ba93ea37876ddd23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76 mm",
"5494b24b09d445ebace47112836b4458": "76 mm",
"de44571ddc4e4d0095c01af6ee299351": "76 mm"
}
}
],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268"
],
"optionIds": [
"dc49e6ac807f4309b64db18941b0fdcf"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Abgasschelle",
"migration_Shopware5DB_product_bullet1": "komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet2": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "auspuff-edelstahl-abgasschelle",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Abgasschelle BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Abgasschelle",
"migration_Shopware5DB_product_bullet1": "komplett aus Edelstahl",
"migration_Shopware5DB_product_bullet2": "bestens geeignet f\u00fcr jede Leistung",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Abgasschelle BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "BAR-TEK\u00ae Exhaust clamp",
"migration_Shopware5DB_product_bullet1": "completely made of stainless steel",
"migration_Shopware5DB_product_bullet2": "ideally suited for any performance",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "exhaust-stainless-steel-reducing-cone",
"migration_Shopware5DB_product_dreisc_seo_title": "Auspuff Edelstahl Abgasschelle BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuff Edelstahl Abgasschelle BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Collier d'\u00e9chappement en acier inoxydable BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Stainless Steel Exhaust Clamp BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abgasschelle aus hochwertigem Edelstahl zum Verbinden von Rohren. Durch die inneren, verdrehten W\u00e4nde dichtet die Schelle optimal ab.\nFeatures:\n\nkomplett aus Edelstahl\nbestens geeignet f\u00fcr jede Leistung\n",
"5494b24b09d445ebace47112836b4458": "Collier de serrage des gaz d'\u00e9chappement en acier inoxydable de haute qualit\u00e9 pour les tuyaux de raccordement. Gr\u00e2ce \u00e0 ses parois int\u00e9rieures torsad\u00e9es, le collier de serrage assure une \u00e9tanch\u00e9it\u00e9 optimale.\nCaract\u00e9ristiques :\n\nenti\u00e8rement en acier inoxydable\nid\u00e9alement adapt\u00e9 \u00e0 toute performance\n",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust gas clamp made of high-quality stainless steel for connecting pipes. Due to the inner, twisted walls, the clamp seals optimally.\nFeatures:\n\ncompletely made of stainless steel\nbest suitable for any performance\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Stainless Steel Exhaust Clamp BAR-TEK\u00ae"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abgasschelle aus Edelstahl f\u00fcr optimale Haltbarkeit. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel exhaust clamp for optimum durability. \u2714 15 years motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 35.2835,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.65,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 28.739494,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.75,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 41.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 35.252098,
"shop-customer": "35.252098",
"b-dealer": "29.65",
"a-dealer": "28.739494",
"c-dealer": "29.2"
},
"fields": {
"displayGroup": [
"99ae07c824aca37717b19bd82e8e668c"
]
},
"sort": [
"true",
0,
"2a39d75a8e7f4038b37ca731c5e0a430"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "800b16ca1bfd4baaa46288af6ae0c492",
"_score": null,
"_source": {
"id": "800b16ca1bfd4baaa46288af6ae0c492",
"autoIncrement": 60895.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1026,
"productNumber": "31600034",
"ean": "4260630976755",
"displayGroup": "a5f688dbf21716ceabebf0b6e432500a",
"sales": 0,
"stock": 1026,
"weight": 0.2,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "Enzo 350105",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"356a4a2234f94af7b8ec77a57731335e",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
},
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "9e0b579a2ced41ce8a8c74d25fa51a5f",
"childCount": 0,
"categories": [
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bridas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flansche",
"5494b24b09d445ebace47112836b4458": " Brides",
"de44571ddc4e4d0095c01af6ee299351": "Flange"
}
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe"
}
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe",
"de44571ddc4e4d0095c01af6ee299351": "Downpipes"
}
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "76mm-3-v-band-schelle",
"migration_Shopware5DB_product_dreisc_seo_title": "76mm 3\" V-Band Schelle",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "76mm 3\" V-Band Schelle",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "V-band clamp 76 mm",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76mm 3\" V-Band Schelle",
"5494b24b09d445ebace47112836b4458": "Pince \u00e0 bande en V de 76mm 3",
"de44571ddc4e4d0095c01af6ee299351": "76mm 3\" V-Band Clamp"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-band Schelle f\u00fcr 76mm 3\" V-Band Flansch. Die Schelle ist aus Edelstahl und f\u00fcr 76mm V-Band Ringe geeignet.",
"5494b24b09d445ebace47112836b4458": "Pince pour bande en V pour bride en V de 76mm 3\". La pince est en acier inoxydable et convient aux anneaux de bande V de 76 mm.",
"de44571ddc4e4d0095c01af6ee299351": "3\" V-Band Clamp for 76mm V-Band flange stainless steel high quality"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76mm 3\" V-Band Schelle",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp 76 mm"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Clamp made of stainless steel for 76 mm V band rings. 15 years motorsport experience & worldwide shipping; BAR-TEK\u00ae proved \u27a4 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.82,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.333333333333,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.122501,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.75,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.65,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.512604,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.25,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 22.899158,
"shop-customer": "22.899158",
"c-dealer": "18.333333333333",
"b-dealer": "17.75",
"a-dealer": "16.512604"
},
"fields": {
"displayGroup": [
"a5f688dbf21716ceabebf0b6e432500a"
]
},
"sort": [
"true",
0,
"800b16ca1bfd4baaa46288af6ae0c492"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "c52b1d98093549139b3b7be302833280",
"_score": null,
"_source": {
"id": "c52b1d98093549139b3b7be302833280",
"autoIncrement": 47449.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1014,
"productNumber": "31600035",
"ean": "4260630976762",
"displayGroup": "d988dba5671dd5f8ffb1328925bc9324",
"sales": 0,
"stock": 1014,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "Enzo 350106",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"356a4a2234f94af7b8ec77a57731335e",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "356a4a2234f94af7b8ec77a57731335e",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
},
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "2fbf78f882ee4a489ed594a68cc108c0",
"childCount": 0,
"categories": [
{
"id": "55ae85fce7fc4d0f811e8aea1dc24fa6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bridas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flansche",
"5494b24b09d445ebace47112836b4458": " Brides",
"de44571ddc4e4d0095c01af6ee299351": "Flange"
}
},
{
"id": "55f5e05bf8f846a7ad4f101f18e062dd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe"
}
},
{
"id": "7cb1b78c070742d3ae56a32550cc13c5",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Bajantes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Downpipes",
"5494b24b09d445ebace47112836b4458": " Downpipe",
"de44571ddc4e4d0095c01af6ee299351": "Downpipes"
}
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268",
"55ae85fce7fc4d0f811e8aea1dc24fa6",
"55f5e05bf8f846a7ad4f101f18e062dd",
"74011241b25e4dc78ceba42dc45a4585",
"7cb1b78c070742d3ae56a32550cc13c5"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "63-5mm-vband-schelle-clamp",
"migration_Shopware5DB_product_dreisc_seo_title": "63.5mm 2.5\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "63.5mm 2.5\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr14": "908",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "63.5mm 2.5\" V-Band Schelle ",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "63.5mm 2.5\" V-Band Schelle",
"5494b24b09d445ebace47112836b4458": "63,5mm 2,5\" Pince pour bande V",
"de44571ddc4e4d0095c01af6ee299351": "63.5mm 2.5\" V-Band Clamp"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V-band Schelle f\u00fcr 63.5mm 2.5\" V-Band Flansch. Die Schelle ist aus Edelstahl und f\u00fcr 63.5mm V-Band Ringe geeignet.",
"5494b24b09d445ebace47112836b4458": "Pince pour bande en V pour bride en V de 63,5 mm 2,5\". La pince est en acier inoxydable et convient aux anneaux de bande V de 63,5 mm.",
"de44571ddc4e4d0095c01af6ee299351": "V-band clamp for 63.5mm 2.5\" V-band flangeThe clamp is made of stainless steel and suitable for 63.5mm V-band rings."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "63.5mm 2.5\" V-Band Schelle ",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": " 63.5mm 2.5\" V-Band Clamp"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.326,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.4,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.2,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.453781,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.7,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.714285714286,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 23.05,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.369747,
"shop-customer": "19.369747",
"b-dealer": "15.4",
"a-dealer": "14.453781",
"c-dealer": "15.714285714286"
},
"fields": {
"displayGroup": [
"d988dba5671dd5f8ffb1328925bc9324"
]
},
"sort": [
"true",
0,
"c52b1d98093549139b3b7be302833280"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "39a1f58dace34570adb03fc96a90fbbf",
"_score": null,
"_source": {
"id": "39a1f58dace34570adb03fc96a90fbbf",
"autoIncrement": 63221.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "5732.1",
"ean": null,
"displayGroup": "df2afa7fb5ba6a70994fb882e43c5a75",
"sales": 0,
"stock": 0,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "679575ce52ad4f6f8bbc62d71a4d4fa6",
"manufacturerNumber": "TZ 428310",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"12298808f73a4bf781a9dcc9b2800801",
"cc11fe134e7d416f935bd42f67cd8dad",
"8e600cbfb4ea4ed3b70f2092fd02feb4",
"19f788f18d0c4b26a3e6c44447742268",
"74011241b25e4dc78ceba42dc45a4585"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "12298808f73a4bf781a9dcc9b2800801",
"_count": 1
},
{
"id": "cc11fe134e7d416f935bd42f67cd8dad",
"_count": 1
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1
},
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "ff69c0aa1e174d3997fa0de35edd22f1",
"coverId": "041d69d3dc314d618eebe342c9bc8d53",
"childCount": 0,
"categories": [
{
"id": "19f788f18d0c4b26a3e6c44447742268",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "74011241b25e4dc78ceba42dc45a4585",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Abrazaderas de escape",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffschellen",
"5494b24b09d445ebace47112836b4458": "Colliers d'\u00e9chappement",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust clamps"
}
},
{
"id": "8e600cbfb4ea4ed3b70f2092fd02feb4",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tubos de escape y curvas",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auspuffrohre und B\u00f6gen",
"5494b24b09d445ebace47112836b4458": " Tuyaux d'\u00e9chappement et arcs",
"de44571ddc4e4d0095c01af6ee299351": "Exhaust Pipes and Bows"
}
}
],
"manufacturer": {
"id": "679575ce52ad4f6f8bbc62d71a4d4fa6",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FOX",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "FOX"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "3c2ae086f3f842e08e605efc34f7da67",
"_count": 1,
"groupId": "7b846261d30c4e268d7e8c7321242bfd",
"group": {
"id": "7b846261d30c4e268d7e8c7321242bfd",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76 mm",
"5494b24b09d445ebace47112836b4458": "76 mm",
"de44571ddc4e4d0095c01af6ee299351": "76 mm"
}
}
],
"categoryIds": [
"19f788f18d0c4b26a3e6c44447742268",
"74011241b25e4dc78ceba42dc45a4585",
"8e600cbfb4ea4ed3b70f2092fd02feb4"
],
"optionIds": [
"3c2ae086f3f842e08e605efc34f7da67"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "edelstahl-auspuffschelle",
"migration_Shopware5DB_product_dreisc_seo_title": "Edelstahl Auspuffschelle",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Edelstahl Auspuffschelle",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Stainless steel exhaust clip",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Auspuffschelle",
"5494b24b09d445ebace47112836b4458": "Collier d'\u00e9chappement en acier inoxydable",
"de44571ddc4e4d0095c01af6ee299351": "exhaust band-clamp stainless steel"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schellen und Klammern f\u00fcr die Erstellung von Abgasanlagen. Hochwertige Schellen und Klammern aus Edelstahl. Mit den Schellen und Klammern lassen sich Abgasanlagen individuell erstellen.\nAbbildung \u00e4hnlich",
"5494b24b09d445ebace47112836b4458": "Colliers et pinces pour la construction de syst\u00e8mes d'\u00e9chappement. Pinces et colliers de serrage de haute qualit\u00e9 en acier inoxydable. Gr\u00e2ce aux pinces et aux colliers, des syst\u00e8mes d'\u00e9chappement peuvent \u00eatre cr\u00e9\u00e9s individuellement.\nImage similaire",
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel exhaust clamps. The size refers to the outside diameter."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Auspuffschelle",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stainless steel exhaust clip"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "High quality clamps and clips for the creation of exhaust systems. ✓ 15 years motorsport experience ✓ worldwide shipping ✓ BAR-TEK® proved ➔ buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.04,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.7,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.551724137931,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.4,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.142857142857,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 22.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 19.285714285714,
"shop-customer": "19.285714285714",
"a-dealer": "16",
"b-dealer": "16.551724137931",
"c-dealer": "17.142857142857"
},
"fields": {
"displayGroup": [
"df2afa7fb5ba6a70994fb882e43c5a75"
]
},
"sort": [
"",
0,
"39a1f58dace34570adb03fc96a90fbbf"
]
}
]
},
"aggregations": {
"total-count": {
"value": 6
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.18 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"19f788f18d0c4b26a3e6c44447742268"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "19f788f18d0c4b26a3e6c44447742268"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|