RFC: Enable Filtering Orders by Total Price

[adevinwild]

In this RFC, I propose adding a new filter to the Admin UI and API that allows filtering orders by total price, utilizing the order_summary

Current implementation

Currently, the API does not support filtering orders by their total amount. Due to this, the Admin UI lacks this capability, which is a highly requested feature by e-commerce managers for workflow optimization

Proposed implementation

We can leverage the existing order_summary table as the reference point for filtering. The order_summary is generated upon order creation and automatically updated when the order state changes from what I understood (e.g., refunds, cancellations, or edits)

Backend Changes
We'll extend the current validator (AdminGetOrdersParams) with a new key : total. This input will be mapped to the summary interface: summary.totals.current_order_total. This specific field (current_order_total) is ideal as it remains synchronized with the computed total

Frontend Changes
We'll introduce a new filter to the Admin UI Orders table. This can be achieved by leveraging the existing NumberFilter component, which supports standard operators (e.g., gt, lt, eq)

A PR containing the implementation is available here 🙌
#14146

Admin UI example

[MicahBCode]

This might be confusing if there are multiple currencies used. Since medusa doesn't work with conversion rates for currencies out of the box this is not very straight forward. Otherwise I would suggest to combine this filter with a currency selection.

[adevinwild]

Yes I agree, but perhaps users could select the currency first and then filter by total amount? Or we could create a new filter based on the NumberFilter, where you can select a currency supported by the store 🤔
Sending both total[<operator>] in the query + currency_code