=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.
FlexSync reads the formula result, not the formula. Shopify sees DRAFT and hides the product from your store.
Native Google Sheets formulas. Paste one in the yellow column and fill down.
=IF(T2=0,"DRAFT","ACTIVE")
Hide a product the moment it sells out.
=IF(T2<=2,"DRAFT","ACTIVE")
Pull products at two units left to avoid overselling.
=IF(AND(T2=0,Z2="DENY"),"DRAFT","ACTIVE")
Only draft products that can't sell when out of stock.
Shopify status accepts ACTIVE, DRAFT or ARCHIVED. Any other word is rejected and the cell resets.
Fill the Status formula down again after you update stock. FlexSync then sends Active back to Shopify.
Each formula cell counts as one formula-driven cell. Free includes 20.
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.
=Compare_at*0.85
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. 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.
Free plan includes 500 SKUs and 20 formula cells.