=Compare_at*0.85
Set every sale price as a percent of the original. Fill it down once and Shopify updates every product.
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.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=Q2*0.85
The simplest sale price.
=ROUNDUP(Q2*0.8,-2)-1
20% off, rounded to end in 99. Tested: 13,300 became 10,699.
=Q2
Set Price back to the compare-at price.
Shopify only shows a strike-through price when Compare at is higher than Price.
Price can't reference itself. Base the formula on Compare at or a cost column.
FlexSync sends a formula result when the formula is entered or filled down.
In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.
Add it to the first row of the yellow column you want to change.
Drag it down the column. FlexSync sends each result to Shopify.
=IF(On_hand=0,"DRAFT","ACTIVE")
Explore →
=IMPORTRANGE(supplier_url,"Sheet1!B2")
Explore →
=VLOOKUP(SKU,Costs,3,0)*1.6
Explore →
=IF(Available<10,"low-stock","")
Explore →
=PROPER(raw_title)
Explore →
="FB-"&RIGHT(Variant_id,6)
Explore →
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.
Free plan includes 500 SKUs and 20 formula cells.