hi guys, i’m looking at a potential of using typesense but had a question about how to handle commerce applications where you might have a sale price active between 2 dates… how might you approach that using typesense. to complicate matters - often the sale price triggers no events at the time of a product going on sale - its set up in advanced based on dates, which somewhat limits the possibility of updating the index at the start and end of the sale period

👋 Are you saying that the price field of the document will be different between a given set of dates (sale duration)?

well, the price of the product would be different, so that could be that it uses a single price field - but that would require updating it at the start and end of the sale period right?

Can this be done during display? Store a "sale_price" field, "sale_start" and "sale_end" dates. Then during display you can check if current date falls between start and end dates and display price accordingly.

the problem with that is when it comes to filtering isnt it?

What type of filtering you would like to do?

eg show all products less then £5

Got it.

indeed - its something we have with other search solutions too 🙂

To do this within a search engine, that engine need to support some kind of dynamic field selection support using a specific condition, like date in this example. But a very interesting use case!

i think elasticsearch can handle it with function scoring - although ive not dug too deeply in to it

Will need something like:

filter_by=field_select(start_date, end_date, now(), sale_price, regular_price):<5

yup, that would be lovely 😛

where

field_select

is a special expression for resolving the actual field based on the dates inside.

yup, would be fantastic - as currently i dont see a good way to handle flash sales in pretty much any search solution

Can you add this use case to that issue also please? We will prioritize it.

will do, cheers

Looks perfect. 👍