Index with products without SKU

[hasibaakterss3309]

Elasticsearch found "evening" in various word forms from different categories of the catalog. Just what you need!

How to Store a Catalog in Elasticsearch
It all depends on the structure and the data kazakhstan telegram number database you need to search.

One index with goods - if there is no SKU (or there is, but they are not included in the selection for the catalog).


One index with SKU and product information.

Index with SKU and product information.png

Index with products + index with SKU and Parent-Child Relationship. Nested entities can be made, but with a large amount of data and a large number of requests (a busy online store) it will work very slowly.

Index with products + index with SKU.png

We store everything in one index — Nested objects. There is a limit of 1000 unique properties per index, but it can be exceeded if we really have a lot of properties for products. And this, of course, will affect performance.

All in one index.png

How to create a smart filter
This filter is implemented using the aggregation mechanism and it is already possible to obtain the necessary data without a separate query to the DB. However, because of this, the query in ES becomes approximately 10% slower.

In the mapping for text fields, add raw with the <keyword> type.

UF1.png

We add the aggs node to the search query.

UV2.png

In response to the request, a new node will appear, which will contain all the information we need.

For the "Article" property.

UF3.png

For the "Manufacturer" property