I want to use elasticsearch for e-commerce project and have no idea how to model data of personalized products.
There is list of base products and every user can personalize each product. What is the best choice how to store data? Im thinking about parend-child relation, but problem is I need to store every product for every user. It means, if I have 10 000 products and 1 000 users I need to created 10 000 000 documents.
So I need something like LEFT JOIN and IF ELSE in SQL to not to need store every product for every user, but only products, which some user personalized it. If there is 1 user and he personalized 1 000 products (from 10 000 base products), I want to store only 1000 user products, but when I want to search products, I need something like IF EXISTS user_product USE user_product ELSE base_product and need to recieve all 10 000 base products, but if user personalized some, use user product, not base product.
Is it possible? Thanks for any clue.