Description
Driftclear turns invisible dead stock into a recovery opportunity.
Most WooCommerce stores have products sitting untouched for 30, 60, even 90+ days. That’s cash tied up in warehouse space, quietly bleeding carrying costs. Driftclear scans your catalog, flags the offenders, and tells you exactly how much capital is at risk — and what price would move them without sacrificing your margin.
How it works
- Scan — Driftclear queries your WooCommerce order history to find products with no sales in the past N days.
- Calculate — A three-tier discount engine (Warn Act Deep) suggests prices that respect your cost floor.
- Report — A weekly digest email shows your capital-at-risk, recoverable revenue, and which products need attention most.
- Simulate mode (default) — No prices are changed until you’re ready. Preview everything first.
- Auto-apply — With one setting, discounts run automatically on the weekly cron. Restore to original price is always one click away.
Features
- Dead stock detection with configurable day thresholds (Tier 1 / 2 / 3)
- Capital-at-risk dashboard — total inventory value idle in your store
- Three-tier tiered discount calculator
- Margin floor: percentage-of-price or COGS-based (works with WC Cost of Goods, Profit & Loss, Cost of Goods Sold, and others)
- Simulate mode — preview prices without touching WooCommerce
- Auto-apply — run discounts automatically on the weekly cron scan
- Manual per-product apply & restore from the admin dashboard and product edit screen
- One-click restore — return any product to its original price instantly
- Weekly email digest — capital at risk, recoverable revenue, top 20 products
- Demand-signal gating — skips products with active pending/on-hold orders
- New-arrival filter — exclude products listed within the past N days
- Per-product exclude flag — protect seasonal items and bundles from scanning
- WooCommerce HPOS compatible
Compatibility
- WooCommerce 8.0+
- HPOS (High-Performance Order Storage) compatible
- Works alongside WC Cost of Goods, Profit & Loss by WooCommerce, Iconic WooCommerce Cost of Goods, and similar cost plugins
Installation
- Upload the
driftclear-dead-stock-for-woocommercefolder to/wp-content/plugins/. - Activate the plugin through the Plugins menu in WordPress.
- Go to Driftclear Settings and configure your thresholds.
- Visit Driftclear Dead Stock to run your first scan.
FAQ
-
Will this change my prices automatically?
-
No — Simulate mode is ON by default. Prices are only changed when you manually click Apply on a product, or when you explicitly enable Auto-apply in Settings.
-
How does the margin floor work?
-
Driftclear never suggests a price below your floor. In percentage mode the floor is a percentage of the current list price (default 50%). In COGS mode the floor is calculated as
cost ÷ (1 − minimum_margin%), identical to the industry-standard formula. -
Which cost plugins are supported?
-
Driftclear reads cost data from
_wc_cog_cost,_wc_cogs_cost,_alg_wc_cog_cost,_cost,_product_cost, and_cpsm_product_costmeta keys. If your cost plugin uses a different key, use thedriftclear_product_cost_meta_keysfilter to add it. -
What is HPOS?
-
High-Performance Order Storage is WooCommerce’s modern database schema. Driftclear detects at runtime which schema your store uses and queries accordingly.
-
Does it work with variable products?
-
Driftclear operates at the parent product level for scanning. Prices are applied to the parent’s regular price.
Reviews
There are no reviews for this plugin.
Contributors & Developers
“Driftclear — Dead Stock Autopilot for WooCommerce” is open source software. The following people have contributed to this plugin.
Contributors
Translate “Driftclear — Dead Stock Autopilot for WooCommerce” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.2.2
- Fix: HPOS query used wrong column names (
date_created_gmt,order_status) fromwc_order_product_lookup; scanner returned 0 results on all stores with HPOS enabled. Query now correctly joinswc_ordersfor status filtering. - Fix: products with WooCommerce stock management disabled (digital products, services, unlimited-stock items) were silently excluded from the dead stock scan.
- Design: sales velocity (days since last sale) is now the primary detection signal; stock quantity is a secondary modifier affecting capital-at-risk calculation.
- New setting: “Include untracked products” (Scan Filters) — enabled by default; lets merchants opt out of scanning products without stock tracking.
- Dashboard: stock column now shows “—” for products without inventory tracking.
- Capital at risk for untracked products is estimated as the unit list price.
1.2.1
- WordPress.org compliance: remove all Pro/freemium references — plugin is 100% free.
- Add license.txt.
- Fix: weekly cron schedule not registered during plugin activation on fresh install.
- Fix: orphaned docblock in DB layer.
- Remove .gitignore from distribution (hidden files not permitted by WP.org policy).
1.2.0
- Product metabox: Driftclear status panel on the WooCommerce product edit screen.
- Per-product “Exclude from scan” flag — protect seasonal items, bundles, and new arrivals.
- Apply / Restore buttons directly from the product edit screen.
- Scan writes per-product status to post meta for instant metabox reads (no on-demand queries).
- Fix: stock quantity now correctly displayed in the dead stock table.
- WPCS / Plugin Check compliance improvements.
1.1.2
- Fix: simulate mode and auto-apply could both be enabled simultaneously.
1.1.1
- Fix: settings keys were inconsistent, causing saved settings to be silently ignored.
1.1.0
- Simulate mode instrumentation: track which simulated discounts were acted on vs. ignored.
- Dashboard: “Simulated & ignored (30d)” metric.
- Scan log: Outcome column.
1.0.0
- Initial release.