SleekView for WooCommerce Low Stock Alerts: alerts & thresholds as tables
Read per-product thresholds from postmeta._low_stock_amount and current stock from postmeta._stock. Surface every product below threshold as one filterable view instead of a flat email digest.
♾️ Lifetime License available
Replace flat alert emails with a sortable list
WooCommerce ships with built-in low-stock alerts: a global threshold under WooCommerce settings, an optional per-product override on postmeta._low_stock_amount, and an email when stock drops below the threshold. Standalone low-stock plugins (Low Stock Notifications, Stock Notifier for WooCommerce, ATUM's notification module) add richer features: customer waitlist subscriptions on out-of-stock products, supplier notification routing, daily digest emails, and an alert log.
What none of these consistently provide is a list view of the current low-stock situation: every product with stock at or below threshold, sortable by units-remaining, filterable by supplier, category, or warehouse, with a per-product threshold column you can edit inline. The data is there, postmeta._stock for current stock, postmeta._low_stock_amount for the threshold, postmeta._backorders for the backorder setting. SleekView turns them into one filterable table.
Inline edits to _low_stock_amount or _stock route through WooCommerce CRUD so stock-change hooks (woocommerce_product_set_stock, woocommerce_low_stock) fire and stock-cache transients clear. Bulk-adjust thresholds across a supplier's product list or bulk-receive stock during a stocktake, all from the same saved view.
Workflow
How SleekView reads low-stock data
Pick the source
wp_posts (post_type=product) joined to postmeta (or the indexed wc_product_meta_lookup where available) for current stock plus per-product threshold.
Compose columns
postmeta), and last-sold date from wc_order_product_lookup. Filter to rows at or below threshold.
Save and scope per role
Edit inline or bulk-receive
wc_update_product_stock so cache transients clear and low-stock hooks fire.
Sample columns
Current low-stock list
wp_posts (post_type=product) to rows where _stock is at or below _low_stock_amount (or the global threshold).
wp_postmeta (_stock + _low_stock_amount + _backorders) on wp_posts (post_type=product) + alert-log table where present
| Product | SKU | Stock | Threshold | Backorder | Last sold |
|---|---|---|---|---|---|
| Studio Lamp | SL-014 | 4 | 5 | no | Apr 24 |
| Drafting Table | DT-022 | 0 | 3 | notify | Apr 24 |
| Aluminium Tripod | AT-105 | 2 | 5 | no | Apr 23 |
| Walnut Shelf | WS-301 | 0 | 2 | yes | Apr 22 |
Comparison
Default low-stock alerts vs SleekView
Default low-stock alerts
- Alerts arrive as flat emails, not as a queryable list with filters and sort
-
Per-product threshold (
_low_stock_amount) is editable only on each product's edit screen - No view that compares current stock against threshold across the whole catalogue at once
-
Backorder setting (
_backorders) lives inpostmetabut isn't part of any list view -
Last-sold date requires joining to
wc_order_product_lookupmanually
SleekView
- Current low-stock list as a filterable, sortable table instead of an email digest
-
Inline-edit
_low_stock_amountper product or bulk-update across a supplier list -
Filter by category, supplier (from
postmeta), backorder setting, and last-sold date -
Join to
wc_order_product_lookupfor last-sold timestamp and 30-day units sold - Bulk-receive stock with the WooCommerce stock hook firing as on a manual edit
Features
What SleekView gives you for WooCommerce Low Stock Alerts
Live low-stock table
Read postmeta._stock and _low_stock_amount, filter to rows below threshold, sort by units-remaining. Replaces the daily email digest with a queryable list the team can act on.
Inline-edit thresholds
Update _low_stock_amount for one product or bulk-update across a supplier's list. Writes go through WooCommerce CRUD so stock-cache transients clear and plugin hooks fire.
Filter by supplier and category
Combine supplier (custom postmeta), category, backorder setting, and last-sold date. Save a view per supplier so each replenishment-meeting opens to its own filtered list.
Audience
Who uses SleekView for WooCommerce Low Stock Alerts
Inventory ops
Replenishment list sorted by units-remaining, filtered to a supplier's products. Bulk-receive stock during a goods-in session with WooCommerce stock hooks firing per row.
Buyers
Combine current stock with 30-day units sold from wc_order_product_lookup to find products that need an urgent reorder versus products that can wait.
Customer support
Customer asks when a product will be back. Pull the product row with stock, threshold, and backorder setting on one line and answer without opening the product edit screen.
The bigger picture
Why low-stock alerts need to be a view
Low-stock alerts arrive as emails because that is what WooCommerce shipped with: one global threshold, one email per breach, one daily digest if the merchant turned it on. Five years ago that was enough. A store with two hundred SKUs across three suppliers, a fluctuating per-product threshold, and a goods-in process that runs three days a week cannot live on emails.
The inventory lead needs a queryable list: current stock at or below threshold, sortable by units-remaining, filterable by supplier, augmented with the last 30 days of sales velocity. The buyer needs the same list filtered to their supplier and grouped by category. Support needs to look up one SKU and see stock plus backorder setting on one row.
The data sits in postmeta._stock, _low_stock_amount, and the indexed wc_product_meta_lookup. SleekView turns it into the filterable, inline-editable, bulk-updatable table that every ops team running real inventory wants. Same WooCommerce CRUD, same stock hooks, dramatically less inbox-scrolling for the people responsible for never running out.
Questions
Common questions about SleekView for WooCommerce Low Stock Alerts
Yes. Core WooCommerce stores stock on postmeta._stock and an optional per-product threshold on _low_stock_amount, with a global fallback under WooCommerce settings. SleekView reads both, applies the right fallback per row, and surfaces the current low-stock list without requiring an extra plugin.
Yes. Plugins like Low Stock Notifications and ATUM's notification module add richer features (waitlist subscriptions, supplier routing, alert logs). SleekView reads the plugin's alert-log table where present and joins it to the products view, giving an audit history alongside the live state.
Yes. Variation-level stock and thresholds live on variation posts (product_variation post type) with the same postmeta keys. SleekView targets either the parent product or variation level depending on how you manage stock.
Yes. The alert fires from WooCommerce core on the next stock-change hook, not directly from a threshold edit. SleekView routes stock edits through wc_update_product_stock which fires woocommerce_product_set_stock, and the low-stock comparison re-runs as on a normal CRUD update.
Yes. Join to wc_order_product_lookup (HPOS) or aggregate wp_woocommerce_order_items on legacy. SleekView surfaces a 30-day units-sold column for replenishment decisions, useful for separating fast-movers from slow-movers when both are below threshold.
If your plugin tracks waitlist subscriptions, those are usually stored in a custom table (wp_stock_notifier_subs, wp_waitlist) or as a per-product meta count. SleekView surfaces the count as a column so high-demand out-of-stock products surface above low-demand ones.
Yes. Filter the products list to a supplier (assuming you tag supplier in a custom postmeta key), select rows, edit the threshold column. Writes route through WooCommerce CRUD so stock-cache transients clear and plugin hooks fire per row.
The filter (_stock at or below _low_stock_amount) is a postmeta comparison that needs careful indexing on busy stores. WooCommerce maintains the wc_product_meta_lookup table which exposes stock_quantity as an indexed column; SleekView prefers this when available for fast low-stock queries on catalogues with hundreds of thousands of products.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Ti Woocommerce Wishlist
- Payu Money Woocommerce
- Woocommerce Shipping Canada Post
- Woocommerce Advanced Product Labels
- Aelia Eu Vat Assistant
- Edd Software Licenses
- Woocommerce Pricing Deals
- Wholesale Suite
- Yith Woocommerce Subscription
- Yith Woocommerce Product Image Gallery Slider
- Yith Woocommerce Quick View
- Woocommerce Hermes Shipping
- Woocommerce 2checkout
- Woocommerce Quick Order
- Woocommerce Facebook Feed