---
title: "Auto-tag low stock"
id: "1116"
type: "page"
slug: "shopify-low-stock-tags"
published_at: "2026-11-15T03:05:29+00:00"
modified_at: "2026-11-15T03:05:29+00:00"
url: "https://flexsync.app/formulas/shopify-low-stock-tags/"
markdown_url: "https://flexsync.app/formulas/shopify-low-stock-tags.md"
---

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.

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

[#](#)

Formula**IF**

Shopify field**Tags**

Tested result**low-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

Stock tags · FlexSync**Synced**

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

| 1 | Product | Available | Tags |
| --- | --- | --- | --- |
| 2 | Soft Surfboard 4'6 | 4 | low-stock |
| 3 | Soft Surfboard 5'7 | 2 | low-stock |
| 4 | Hooded Wetsuit | 10 |  |
| 5 | Fullsuit 2XS | 10 |  |

Shopify admin

### Soft Surfboard 4'6

Tags**low-stock *Added***

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.

[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/)
[Sitewide sale pricing =Compare_at*0.85 Explore →](/formulas/shopify-sale-pricing-formula/)
[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/)
[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)
.

### Will this remove my existing tags?

    The Tags cell is replaced by the formula result. Include existing tags in the formula if you need them.

### Can I build a collection from this tag?

    Yes. Create a smart collection with the condition Product tag is equal to low-stock.

### Which stock column should I use?

    Available is best. It already subtracts committed orders.

## 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-low-stock-tags)
[See pricing](/pricing)

×
