Formula recipe

Hide sold-out products with one formula

=IF(On_hand=0,"DRAFT","ACTIVE")

Put the formula in the Status column. Products at zero stock move to Draft in Shopify. The rest stay Active.

FormulaIF
Shopify fieldStatus
Tested resultProduct moved to Draft
4.9/5 on Shopify App Store
Built for Shopify
20 formula cells free
How it works

Zero stock in the Sheet, Draft in Shopify

FlexSync reads the formula result, not the formula. Shopify sees DRAFT and hides the product from your store.

  • No more sold-out products on collection pages
  • One formula, filled down the whole column
  • Works on every product in the Sheet
Copy and paste

Ready-to-use variations

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

=IF(T2=0,"DRAFT","ACTIVE")

Draft at zero

Hide a product the moment it sells out.

=IF(T2<=2,"DRAFT","ACTIVE")

Draft before you run out

Pull products at two units left to avoid overselling.

=IF(AND(T2=0,Z2="DENY"),"DRAFT","ACTIVE")

Respect backorders

Only draft products that can't sell when out of stock.

Good to know

Tips before you start

Use the right words

Shopify status accepts ACTIVE, DRAFT or ARCHIVED. Any other word is rejected and the cell resets.

After a restock

Fill the Status formula down again after you update stock. FlexSync then sends Active back to Shopify.

Counts toward your plan

Each formula cell counts as one formula-driven cell. Free includes 20.

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. Draft products are hidden from all sales channels until you set them back to Active.

Use On hand or Available. Available is On hand minus committed orders.

Yes. Replace "DRAFT" with "ARCHIVED" in the formula.

Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.