WooCommerce reorder alerts based on supplier lead time

Published Updated 3 min read

WooCommerce's low stock threshold is one number, set once in Settings > Products and applied to every product. A product selling two a day and one selling thirty get the same rule: alert at two. That works for shelf items your supplier ships overnight and fails for anything with a four-week delivery window.

The failure is predictable. The alert fires on a Tuesday, the product sells out by Thursday, and the shipment lands early next month. Customers keep ordering and the backlog builds, while the alert did exactly what it was configured to do.

What you want is a reorder point: average daily sales multiplied by the days stock takes to arrive. It is standard inventory arithmetic, and WooCommerce already holds the data. A small plugin adds one field per product, reads the last thirty days of orders, and tells you to order before you run out.

Why a fixed threshold fails when lead times are long

The built-in alert lives at Settings > Products > Low Stock Threshold and covers every product. In most setups it is two, and if you never changed it, every product shares that trigger however fast it sells or slowly it restocks.

For a fast seller with a four-week lead time, the reorder should have happened weeks before stock reached two. The alert is mathematically correct and practically useless.

Volume makes it worse. Thirty orders a day over twenty-eight days of lead time means 840 units should be in the pipeline before current stock hits the trigger. A threshold of two is noise; the number that matters comes from this product's sales rate and this supplier's delivery window.

How a reorder point is calculated

A reorder point is the stock level at which you order so new stock arrives before the old runs out: average daily sales multiplied by lead time in days. No external service, no forecasting model.

Sell 180 units in thirty days and that is six a day. With a three-week supplier, the reorder point is 6 times 21, or 126. Order when stock drops to 126; if it falls below 126 with nothing ordered, you are already behind.

Safety stock is optional. Some operations pad with extra days against unreliable deliveries. The basic version without a buffer catches the problem for most stores and is where to start.

A lead time field, a status column and a report

Each product's Inventory tab gets a Lead time (days) field: 7 for next-week delivery, 28 for a four-week supplier. Leave it blank where you do not manage stock or the built-in threshold is enough.

The Products list gains a Reorder status column showing OK in green or Reorder needed in red, worked out from the last thirty days of completed orders. Products without a lead time show a dash, and so do products with no completed orders in that window, since a zero sales rate makes any threshold meaningless; leave slow sellers on WooCommerce's own low stock threshold.

A Reorder Report page in the WooCommerce menu lists every stock-managed product with a lead time, alongside current stock, reorder point, average daily sales and estimated days left. That is the screen to open before ordering from a supplier.

Once a week the admin gets an email listing every product below its reorder point, and only when there is something to list. Stock is read live, so a flag clears as soon as you update the quantity past the reorder point.

When Inventory Planner or ATUM is the better answer

This answers one question: what needs reordering now. It does not raise purchase orders, track them, contact suppliers, handle products with several suppliers, or forecast seasonal demand.

Inventory Planner connects to WooCommerce and forecasts from full order history, adjusting for seasonality, promotions and growth. ATUM's inventory module adds purchase orders and supplier management on top of a reorder trigger. Both are justified where a reorder miscalculation is a real business risk.

A store with thirty steadily selling products and one supplier each does not need that machinery. It needs to know when to order, from data it already has, and for most stores still on WooCommerce's default of two, that closes the gap.

What you get

Included

  • A per-product Lead time (days) field on the WooCommerce Inventory tab
  • Reorder point calculation from the last thirty days of completed orders
  • A Reorder status column in the WooCommerce Products admin list
  • A Reorder Report page showing stock, daily sales rate, reorder point, and days remaining per product
  • A weekly admin email listing every product currently below its reorder point

Not included

  • Variable products per variation: the calculation runs at the parent product level with all variations combined
  • Safety stock: no buffer beyond the lead time calculation is included
  • Purchase order creation or supplier contact integration
  • Products with no recent sales history: items with zero completed orders in the last thirty days show no reorder status
  • Seasonal forecasting: the thirty-day average reflects recent sales only, not peak season projections

Inventory Planner does the things on the right. This build covers the part most sites use.

Questions

Does this work for variable products?

The lead time field sits on the parent product, sales across all variations are combined into one daily average, and the reorder point is calculated for the parent. Per-variation lead times are not supported.

My supplier's lead time changes with the season. How do I handle that?

The field holds one number. Set it to the longest realistic lead time to stay safe, and update it when the supplier's schedule changes, such as before a peak season.

Build it in Steem

The button opens the builder with this guide's prompt filled in, so you can change anything before it runs. Nothing is built, and nothing is charged, until you send it.

Build this pluginAbout 55 credits. The free plan includes enough for one.
Read the prompt (401 words)

Build a WooCommerce plugin called Reorder Point Manager. Plugin Name: Reorder Point Manager. Description: Per-product reorder alerts based on supplier lead time and 30-day sales velocity. Single PHP file. No dependencies beyond WooCommerce. Add a Lead time (days) number field to the WooCommerce product Inventory tab. Use the woocommerce_product_options_inventory_product_data action with woocommerce_wp_text_input. Field id and name: _reorder_lead_time, label: Lead time (days), type: number, custom_attributes min 1. Save on woocommerce_process_product_meta: cast to absint and store with update_post_meta. Only save if the product's manage_stock is enabled. Add a column Reorder status to the WooCommerce Products admin list using manage_edit-product_columns (add key rrm_status after the stock column) and manage_product_posts_custom_column. In the column callback, get the WC_Product object with wc_get_product. If manage_stock is not enabled or _reorder_lead_time is not set or is zero, output a dash. Otherwise query the database: count total quantity sold for this product_id from wp_woocommerce_order_items joined with wp_woocommerce_order_itemmeta for meta_key _product_id and wp_posts where post_status is wc-completed and post_date >= DATE_SUB(NOW(), INTERVAL 30 DAY). Divide total qty by 30 to get average_daily_sales. Calculate reorder_point as ceil(average_daily_sales * lead_time). Get current get_stock_quantity(). If stock_quantity <= reorder_point output a span with style color:#d63638 and text Reorder needed. If stock_quantity > reorder_point output a span with style color:#46b450 and text OK. Wrap all dynamic values in esc_html. Add a submenu page Reorder Report under WooCommerce using add_submenu_page, parent_slug woocommerce, capability manage_woocommerce, slug wc-reorder-report. On the page output a WP admin table. Query all published simple and variable products with manage_stock on and _reorder_lead_time set and greater than zero. For each product show: product name as a link to the edit screen, current stock, lead time in days, 30-day average daily sales to one decimal, calculated reorder point, estimated days of stock remaining (floor of stock divided by daily_sales, or the string Unlimited if daily_sales is zero), and status (Reorder needed in #d63638 or OK in #46b450). Escape all output. On plugin activation register a weekly cron event with wp_schedule_event(time(), weekly, rrm_weekly_report). On deactivation call wp_clear_scheduled_hook(rrm_weekly_report). In the rrm_weekly_report callback build the list of products below their reorder point using the same calculation as above. If the list is empty return without sending. Otherwise send a wp_mail to get_option(admin_email) with subject [site_name] Weekly reorder report and an HTML body containing a table listing product name, current stock, reorder point, and days remaining for each flagged product. Set content-type to text/html via the wp_mail headers argument.