SafeSale · Blog

Sale prices in collection sort, price filters and search

Does a Shopify sale change where products land when shoppers sort by price or filter under a budget? It depends on the sale mechanism. What each one does.

A shopper opens your sale collection, sorts by price from low to high, and the most heavily discounted item sits two thirds of the way down the page, surrounded by things that cost more than it does. Another shopper ticks the under 50 box in the price filter and never sees the jacket that would be 45 in their cart. Neither of them is doing anything wrong. The collection is sorting and filtering by the price Shopify has on file for each variant, and whether your sale changed that price depends entirely on how the sale was built.

This post walks through what sort by price, storefront price filters and search do during a sale run with SafeSale, in each of its two sale mechanisms. The short version is that one of them changes the price Shopify sorts and filters on and the other does not, and that difference is worth knowing before the sale goes live rather than after a shopper tells you about it.

What Shopify sorts and filters on

Shopify's help page on collection layout is unusually direct about this: sorting a collection by price on the online store uses products' base prices. It goes on to say that market and B2B catalog prices are not used to determine the sort order, so if catalog prices differ from base prices, products might not be displayed in the order of the prices customers see. The same base price feeds the price filter in the Shopify Search & Discovery app, the price shown on collection cards, and the price returned in search results and predictive search.

The base price is the number in the Price field of the variant. Not the compare-at price, not a discount that will apply later, not a market adjustment. When a shopper sorts or filters, Shopify looks at that one field. So the question for any sale is simply: did the sale change the Price field, or did it leave it alone and arrange the saving somewhere else?

Automatic discount mode: nothing moves

In automatic discount mode SafeSale creates a Shopify discount that applies to the chosen products when they reach the cart. The variant Price field stays exactly as it was. That is the point of the mode: prices in the catalogue are never touched, so there is nothing to restore when the sale ends and nothing to drift while it runs.

The consequence for sorting and filtering follows directly. A product priced at 60 with a 25% automatic discount is still a 60 product to the collection page. Sort by price places it among the 60 items. The price filter puts it in the 50 to 100 band. Search results show 60. The shopper sees the 45 only when the item is in the cart, or on the product page if your theme has been set up to display the sale there; the sale badges post covers what SafeSale publishes for themes to read. For shoppers browsing by price, though, the sale is invisible until the cart.

Whether that matters depends on the sale. A storewide 20% off where everything moves down together leaves the relative order unchanged, and a shopper sorting low to high still sees the cheapest things first. A sale that cuts one collection by 40% while the rest of the store stays at full price is a different matter: those items should now be sorting among much cheaper products and are not, and anyone filtering by budget is being shown the wrong set.

Price rewrite mode: everything moves

In price rewrite mode SafeSale writes the sale price into the variant's Price field and moves the original price into Compare-at, after taking a snapshot of both so they can be restored later. From Shopify's point of view the product now costs 45. Sort by price places it with the other 45 items, the price filter puts it in the under 50 band, search results show 45 with 60 struck through on themes that render compare-at, and collection cards show the same.

This is the mode to use when the sale is meant to be browsable: a clearance collection sorted low to high, a "gifts under 50" campaign that depends on a price filter, a search-heavy store where shoppers type a product name and expect to see the sale price in the results. The mechanism comparison lists the other trade-offs; this is one of the larger ones in favour of rewrite, and it is easy to overlook because it only shows up on collection pages, not in the admin.

When the sale ends, SafeSale restores the snapshot prices and the products return to their original places in the sort order and their original filter bands. The restore is as much a part of the sale as the markdown, which is why SafeSale keeps the snapshot rather than trusting the compare-at field to remember what the price was.

A worked collection

Suppose a collection of outerwear with five products and a 40% sale on two of them. The table shows how a low-to-high sort orders the collection in each mode. The numbers are illustrative; the ordering is the point.

ProductBase priceIn sale?Low to high, automatic discountLow to high, price rewrite
Rain shell80No2nd3rd
Fleece60No1st2nd
Wool coat150Yes, 90 in cart4th4th
Down jacket200Yes, 120 in cart5th5th
Puffer vest95Yes, 57 in cart3rd1st

The puffer vest is the one to notice. At 57 it is the cheapest thing in the collection, and a shopper sorting low to high should see it first. In automatic discount mode it sits third, behind two full-price items, because Shopify is sorting on 95. In rewrite mode it leads. A shopper with an under 60 filter sees the fleece and the vest in rewrite mode and the fleece alone in automatic mode.

Filters have their own limits

Even in rewrite mode, the Search & Discovery filter has rules of its own that a sale can bump into. Shopify's help notes that collections containing more than 5,000 products do not display filters at all, and that filter values and their counts on search results are based on the first 1,000 results. A large sale collection built by tag can cross the first limit without anyone noticing until the filter sidebar disappears. If your sale page relies on filtering, keep the sale collection under that size, or split it.

The price filter itself is generated from the actual prices in the collection, so when a rewrite moves 300 products down a band, the filter's ranges and counts update once Shopify has reindexed. For a catalogue of a few thousand variants SafeSale applies the rewrite in batches, which means for a few minutes some products are in their new band and some are still in the old one. The progress post covers how long that takes. Announce the sale once the status reads Active, not when you press Start.

Markets and the base price

The help page's remark about market prices cuts the other way too. If you sell in several markets with percentage adjustments or a separate catalog, Shopify still sorts by the base price, so a Canadian shopper seeing a 10% uplift sorts by prices 10% lower than the ones on screen. The order is usually still right because the uplift is uniform. A SafeSale rewrite changes the base price itself, so the sale order is correct in every market, and the markets post explains how each market's displayed price is derived from the new base.

Choosing with browsing in mind

If the sale is a uniform percentage across the store, or shoppers arrive through campaigns and product links rather than browsing collections, automatic discount mode's indifference to sort order costs you little, and its other properties, no catalogue writes and no restore, may be worth more. If the sale is concentrated on part of the range, if you are building a budget-led landing page, or if your store's shoppers habitually sort low to high, rewrite mode is the one that puts the discounted products where those shoppers will look.

SafeSale shows the mode on each sale, and you choose it when the sale is created. Before confirming, open the sale collection on your storefront, sort it by price, and ask whether the result after the markdown should look different. If the answer is yes, that is a rewrite sale.

Frequently asked questions

Does a Shopify automatic discount change the order when a collection is sorted by price?

No. Shopify sorts collections by the base price stored on the variant, and an automatic discount leaves that price untouched. A product discounted to 45 at checkout still sorts as if it cost 60 and still fails a shopper's under 50 filter. Only a sale that rewrites the variant price moves the product in sort order and filters.

Which SafeSale mode makes sale prices show up in price filters and sorting?

Price rewrite mode. It writes the sale price into the variant's price field and moves the original into compare-at, so sort by price, the Search and Discovery price filter and search results all reflect the sale. Automatic discount mode keeps the catalogue price as it was and applies the saving in the cart and at checkout.

Do price filters update as soon as the sale starts?

Within the time Shopify takes to reindex the storefront after the variant prices change. For a large catalogue SafeSale applies prices in batches, so the first products move into their new price bands before the last ones do. Expect the collection to settle within a short while of the sale reaching Active, and check a filtered page before announcing the sale.

Do Shopify Markets prices affect sort order the same way?

No. Shopify's help states that sorting by price uses products' base prices, not market or B2B catalog prices. A market with a 10% uplift shows higher prices to those shoppers but sorts by the base price. A SafeSale rewrite changes the base price itself, which is why it does affect sort order everywhere.