---
title: "Sitewide sale pricing"
id: "1113"
type: "page"
slug: "shopify-sale-pricing-formula"
published_at: "2026-11-15T03:05:27+00:00"
modified_at: "2026-11-15T03:05:27+00:00"
url: "https://flexsync.app/formulas/shopify-sale-pricing-formula/"
markdown_url: "https://flexsync.app/formulas/shopify-sale-pricing-formula.md"
---

Formula recipe# Run a sitewide sale from one formula

`=Compare_at*0.85`Set every sale price as a percent of the original. Fill it down once and Shopify updates every product.

[Start for Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-sale-pricing-formula)
[See how it works](#how)

[#](#)

Formula**Multiply**

Shopify field**Price**

Tested result**13,300 became 11,305**

4.9/5 on Shopify App Store

Built for Shopify

20 formula cells free

How it works## Change one number, reprice the whole store

Write the discount once, fill it down the Price column and FlexSync sends every new price to Shopify. Compare-at stays put, so shoppers see the strike-through.

- 15% off, 30% off, any percent
- Prices round the way you want
- End the sale by pointing Price back at Compare at

Sale prices · FlexSync**Synced**

fx`=Q2*0.85`

| 1 | Product | Compare at | Price |
| --- | --- | --- | --- |
| 2 | Soft Surfboard 4'6 | 13,300 | 11,305 |
| 3 | Soft Surfboard 5'7 | 13,300 | 11,305 |
| 4 | Hooded Wetsuit | 13,300 | 11,305 |
| 5 | Black Swimsuit | 13,300 | 11,305 |

Shopify admin

### Soft Surfboard 4'6

Price**11,305.00 *Updated***

Compare-at**13,300.00 *Kept***

Copy and paste## Ready-to-use variations

Native Google Sheets formulas. Paste one in the yellow column and fill down.

`=Q2*0.85`### Straight 15% off

The simplest sale price.

`=ROUNDUP(Q2*0.8,-2)-1`### Charm pricing

20% off, rounded to end in 99. Tested: 13,300 became 10,699.

`=Q2`### End the sale

Set Price back to the compare-at price.

Good to know## Tips before you start

### Keep compare-at higher

Shopify only shows a strike-through price when Compare at is higher than Price.

### Reference another cell

Price can't reference itself. Base the formula on Compare at or a cost column.

### Fill down to apply

FlexSync sends a formula result when the formula is entered or filled down.

Setup## Up and running in three steps

1### Turn on formulas

In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.

2### Paste the formula

Add it to the first row of the yellow column you want to change.

3### Fill down

Drag it down the column. FlexSync sends each result to Shopify.

[Read the formula guide](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/)

More recipes## More formulas that change your store

[Auto-draft sold-out products =IF(On_hand=0,"DRAFT","ACTIVE") Explore →](/formulas/shopify-auto-draft-out-of-stock/)
[Supplier price sync =IMPORTRANGE(supplier_url,"Sheet1!B2") Explore →](/formulas/shopify-supplier-price-sync/)
[Cost-plus pricing =VLOOKUP(SKU,Costs,3,0)*1.6 Explore →](/formulas/shopify-cost-plus-pricing/)
[Auto-tag low stock =IF(Available<10,"low-stock","") Explore →](/formulas/shopify-low-stock-tags/)
[Clean up product titles =PROPER(raw_title) Explore →](/formulas/shopify-clean-product-titles/)
[Generate SKUs ="FB-"&RIGHT(Variant_id,6) Explore →](/formulas/shopify-auto-generate-skus/)

Questions## Frequently asked questions

Still have questions? Our support team is available 24/7 at [support@flexsync.app](mailto:support@flexsync.app)
.

### Can I run a sale on one collection only?

    Yes. Filter the Sheet to that collection and fill the formula down the visible rows.

### Does this change my compare-at price?

    No. Only the Price column changes.

### How do I end the sale?

    Fill =Q2 down the Price column, or paste your original prices back.

## Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.

[Install FlexSync Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-sale-pricing-formula)
[See pricing](/pricing)

×
