Hi everyone,
I’m using the Dawn theme with the Search & Discovery app for sorting and filters.
In my store, prices are dynamic based on user location:
-
If the Solr price > 0, I use that.
-
If not, I check the SQL Server price > 0.
-
If neither is available, I fall back to the static Shopify product price.
The dynamic price displays correctly on the collection and product pages.
However, the issue is with sorting and filters:
-
When I apply Price: High to Low, the products are not ordered correctly based on the dynamic price.
-
Even though the correct dynamic price is displayed, Shopify still sorts using the static price stored in Shopify Admin.
-
Because of this, the actual highest dynamic price product might appear on the 5th page, instead of the first page.
-
The same issue happens with price filters and the price slider — they rely on Shopify’s indexed price, not the dynamic price.
So basically:
The UI shows the correct dynamic price, but the sorting order and pagination are based on Shopify’s original price.
Has anyone successfully handled dynamic location-based pricing while keeping Shopify’s native sorting and filtering working properly?
Is there any way to override Shopify’s internal price indexing so sorting and filters use external API pricing instead?
Or is the only solution to completely replace Shopify’s collection sorting with a fully custom solution?
Any guidance or architecture suggestions would be greatly appreciated.