Your supplier's spreadsheet, flowing straight into your store.
Suppliers send stock and price updates as spreadsheets. Instead of downloading, cleaning and importing CSVs, link the supplier's Google Sheet to your FlexStock Sheet with IMPORTRANGE, add your markup with a formula, and let FlexStock sync it to WooCommerce.
=ROUND('Supplier feed'!D2*1.4, 2)| SKU | Product | Supplier stock | Your price | |
|---|---|---|---|---|
| 2 | HX-2201 | Desk Lamp Pro | 120 | $55.86 |
| 3 | HX-2207 | Monitor Arm | 34 | $83.86 |
| 4 | HX-2215 | Cable Tray | 4 | $27.86 |
| 5 | HX-2230 | Footrest | 0 | $41.86 |
Overselling is the real cost of stale supplier data.
Our supplier updates their stock sheet daily. We find out it's sold out after the customer orders.
Every price change from a supplier means a new CSV import and an hour of cleanup.
We apply different markups per brand, and doing it by hand causes mistakes.
Supplier sheet β your Sheet β your store
This is the flow FlexStock's own formula guide describes: a supplier sheet, an intermediate tab, then the FlexStock tab.
Connect the supplier's sheet
Use IMPORTRANGE in an intermediate tab of your FlexStock Sheet. Google asks for permission once.
Map it with formulas
In the FlexStock tab, reference the supplier tab for stock and apply your markup to their prices.
FlexStock syncs it to WooCommerce
Results sync on your schedule, from every 10 minutes upward.
Link a supplier's sheet, not a CSV
If your supplier shares a Google Sheet, IMPORTRANGE brings its stock and prices into a tab of your FlexStock Sheet. Your store reflects their latest numbers without a single import.
- IMPORTRANGE from any Google Sheet you can access
- Supplier data lands in an intermediate tab
- FlexStock tab references it with formulas
=IMPORTRANGE("supplier-sheet-url", "Stock!A2:D500")| SKU | Product | Cost | Stock | |
|---|---|---|---|---|
| 2 | HX-2201 | Desk Lamp Pro | $39.90 | 120 |
| 3 | HX-2207 | Monitor Arm | $59.90 | 34 |
| 4 | HX-2215 | Cable Tray | $19.90 | 4 |
Your margins, applied automatically
Turn supplier cost into your selling price with a formula: a flat markup, a per-brand rule or a rounded price ending. When the supplier changes cost, your price follows.
- Any Google Sheets formula
- Per-brand or per-category markups
- Sale prices from a promo tab
=CEILING(C2*1.4, 1)-0.01| Product | Brand | Cost | Price | |
|---|---|---|---|---|
| 2 | Desk Lamp Pro | Hexa | $39.90 | $55.99 |
| 3 | Monitor Arm | Hexa | $59.90 | $83.99 |
| 4 | Cable Tray | Hexa | $19.90 | $27.99 |
Sold out at the supplier, sold out in your store
When the supplier's stock hits zero, your WooCommerce product follows on the next sync. Switch items to backorder from the Sheet if you'd rather keep taking orders.
- Stock and stock status sync
- Backorder control from the Sheet
- Variations supported
| Product | Stock | Price |
|---|---|---|
| Desk Lamp Pro | In stock (120) | $55.99 |
| Monitor Arm | In stock (34) | $83.99 |
| Cable Tray | Low stock (4) | $27.99 |
| Footrest | Out of stock | $41.99 |
What supplier-fed stores rely on
Formula support Pro
Any valid Google Sheets formula, including references to other tabs.
Scheduled sync
From every 10 minutes (free) to 30 minutes, hourly, daily or weekly (paid).
Add new products Pro
New supplier items can be added to your store from the Sheet.
Images and categories Pro
Bring product images, categories and attributes in the same Sheet.
Unlimited products
No product or SKU cap, even on the free plan.
No accidental deletions
Products can't be removed from your store via the Sheet.
Formulas are on every paid plan.
Supplier feeds rely on formulas, so a paid plan is the right fit. Catalog size is never the reason: even the free plan syncs unlimited products.
FlexStock Personal or Business
- Personal: $119 one-time or $69/year, 1 site
- Business: $249 one-time or $109/year, 5 sites
- Formula sync, images and new products from the Sheet
- 30-day money-back guarantee
Frequently asked questions
Can FlexStock sync stock from my supplier?
Yes, if your supplier's data is in a Google Sheet you can access. Use IMPORTRANGE to bring it into your FlexStock Sheet, then reference it with formulas. FlexStock syncs the results to WooCommerce.
What if my supplier sends CSV or Excel files?
Import the file into a tab of your Google Sheet and reference it the same way. Live links work best when the supplier shares a Google Sheet.
How quickly do supplier changes reach my store?
Formula results update in Google Sheets right away and sync to WooCommerce on your chosen schedule.
Is FlexStock free?
Yes. The free version syncs unlimited products both ways, including variable products, with real-time updates from the store and scheduled sync every 10 minutes. Paid plans start at $69 a year or $119 one-time and add formulas, images, categories, attributes and new products from the Sheet.
Do I need to know how to code?
No. A setup wizard walks you through connecting your Google Sheet: creating a Google Cloud project, enabling the Sheets API, sharing the Sheet and pasting the Apps Script. No coding required.
More ways stores use FlexStock
Stop overselling items your supplier ran out of yesterday.
Link your supplier's sheet to WooCommerce with FlexStock.