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.

FormulaMultiply
Shopify fieldPrice
Tested result13,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
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.

Questions

Frequently asked questions

Still have questions? Our support team is available 24/7 at support@flexsync.app.

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

No. Only the Price column changes.

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.