=IF(Available<10,"low-stock","")
One IF formula in the Tags column. Shopify gets a low-stock tag you can use in collections, filters and Flow.
Tags drive smart collections, storefront filters and Shopify Flow. Let your stock level set the tag.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=IF(W2<10,"low-stock","")
Tag anything under 10 units.
=IF(W2=0,"sold-out",IF(W2<10,"low-stock","in-stock"))
One tag per product, based on stock.
=IF(W2<5,"last-chance","")
Feed a smart collection for urgency.
Each formula writes the Tags cell. Keep any other tags you need inside the formula result.
Create a Shopify Flow trigger on product tag added to send reorder alerts.
Fill the Tags formula down again after updating stock.
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 →
=Compare_at*0.85
Explore →
=IMPORTRANGE(supplier_url,"Sheet1!B2")
Explore →
=VLOOKUP(SKU,Costs,3,0)*1.6
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.
The Tags cell is replaced by the formula result. Include existing tags in the formula if you need them.
Yes. Create a smart collection with the condition Product tag is equal to low-stock.
Available is best. It already subtracts committed orders.
Free plan includes 500 SKUs and 20 formula cells.