Formula recipe

Tag low-stock products automatically

=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.

FormulaIF
Shopify fieldTags
Tested resultlow-stock tag added
4.9/5 on Shopify App Store
Built for Shopify
20 formula cells free
How it works

A tag Shopify can act on

Tags drive smart collections, storefront filters and Shopify Flow. Let your stock level set the tag.

  • Build a Last chance collection
  • Trigger a Flow reorder alert
  • Filter low stock in Shopify Admin
Copy and paste

Ready-to-use variations

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

=IF(W2<10,"low-stock","")

Low stock

Tag anything under 10 units.

=IF(W2=0,"sold-out",IF(W2<10,"low-stock","in-stock"))

Three stock levels

One tag per product, based on stock.

=IF(W2<5,"last-chance","")

Last chance

Feed a smart collection for urgency.

Good to know

Tips before you start

One tag per formula

Each formula writes the Tags cell. Keep any other tags you need inside the formula result.

Use the tag in Flow

Create a Shopify Flow trigger on product tag added to send reorder alerts.

Refresh after stock changes

Fill the Tags formula down again after updating stock.

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.

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.

Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.