# E-commerce products with prices per customer **URL:** \ **Category:** Elasticsearch\ **Created:** [August 20, 2020, 11:18pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832 "2020-08-20T23:18:03Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dndeus](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@dndeus](https://discuss.elastic.co/u/dndeus)\ **Post date:** [August 20, 2020, 11:18pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/1 "2020-08-20T23:18:03Z")
Hello there! Let me give you the use case. I need to build this b2b commerce where the prices for each product is different for every logged in customer. One of the functionalities is, the customer should be able to filter and sort the list of products by price. From what I've read so far, storing the prices into the product index could be quite a performance penalty. Generally speaking in the context of a e-commerce site and especially with price scenarios like the one I mentioned before or discounts per customer etc where the data shouldn't be in the same index is quite difficult and honestly I couldn't find much around the internet. How would you go about this on how I should tackle this kind of scenarios? I would appreciate a hint on this. Thanks ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 21, 2020, 1:03am UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/2 "2020-08-21T01:03:54Z")
Welcome to our community! 😃 Is it safe to say that there's a base price for each item, and then you change that based on the customer's discount level? ---
**Author:** ![dndeus](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@dndeus](https://discuss.elastic.co/u/dndeus)\ **Post date:** [August 21, 2020, 2:26pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/3 "2020-08-21T14:26:07Z")
Wow, thank you for the greetings! That could be a use case, sure. In my particular use case the price for each customer comes from an ERP so there is no base price for the products hence base price is 0. If it helps the prices come in the following format: `customer_id - product_id - price - percentage_discount` ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 21, 2020, 2:56pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/4 "2020-08-21T14:56:02Z")
How many products and customers do you have? ---
**Author:** ![dndeus](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@dndeus](https://discuss.elastic.co/u/dndeus)\ **Post date:** [August 21, 2020, 3:13pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/5 "2020-08-21T15:13:31Z")
The products are about 50.000 and the customers I think would be between 100 and 200. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 21, 2020, 3:19pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/6 "2020-08-21T15:19:46Z")
Then I would probably flatten the data and store product information with price for each customer. It will be easy to update and query and should not take up much space even if data this way is duplicated. ---
**Author:** ![dndeus](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@dndeus](https://discuss.elastic.co/u/dndeus)\ **Post date:** [August 21, 2020, 3:50pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/7 "2020-08-21T15:50:37Z")
So you mean by using nested objects something like this: ```auto { "name": "Product 1", "Description": "Product description", "prices": { [ "customer_id": 1, "price": 1000, "percentage_discount": 19 ], [ "customer_id": 2, "price": 1300, "percentage_discount": 10 ], } } ``` That would make sense given that I need to sort using the price. What if I had 1000 customers? That would be a lot of data and would be more difficult to update all these prices for a given customer. I know of course the answer would come by testing a variety of solutions and then compare the search performance but since I am new to ES I'm trying to find what would be the thinking process with those kind of relationships. I found a very [good article](https://rockset.com/blog/can-i-do-sql-style-joins-in-elasticsearch/) explaining the pros and cons regarding the right data modeling when we are dealing with relationships but it would be nice to chat about it. Unfortunately there aren't many real world example out there from what I have seen. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [August 21, 2020, 4:01pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/8 "2020-08-21T16:01:56Z")
No, I mean a document per product and customer without nested documents. This means that you will have 200 documents for each product if you have 200 customers but it aligns well with the feed you get from the ERP system. ---
**Author:** ![dndeus](https://avatars.discourse-cdn.com/v4/letter/d/5f8ce5/32.png) [@dndeus](https://discuss.elastic.co/u/dndeus)\ **Post date:** [August 21, 2020, 4:15pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/9 "2020-08-21T16:15:19Z")
Hm, yes that looks interesting. Performance wise it would be pretty fast since each document would be completely flat and using the customer id as a filter would also cache the results. Sorting by price would be pretty easy since the price attribute would be level 0 in the document. Thanks for your suggestions. I'll mark this as a solution to this thread. Please for anyone else feel free to share your opinions on this! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 18, 2020, 4:15pm UTC](https://discuss.elastic.co/t/e-commerce-products-with-prices-per-customer/245832/10 "2020-09-18T16:15:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.