How to Set Up Automated Purchase Orders That Fire When Stock Hits Reorder Point.

You know the feeling. You open your inventory dashboard on a Monday morning and your best-selling SKU shows 4 units left. Your supplier needs 14 days to deliver. You needed to reorder 2 weeks ago. Now you are facing a stockout, a scramble to find an alternative supplier, and 10-14 days of lost sales on a product that does $200/day.

This happens because purchase orders are still manual for 73% of e-commerce sellers. Someone has to notice the stock is low. Someone has to create the PO. Someone has to send it to the supplier. Someone has to follow up. And when that someone is also the person packing orders, managing listings, and answering customer emails, things fall through the cracks.

The fix is not hiring a procurement person. The fix is making the entire PO process automatic. When stock hits the reorder point, the PO creates itself, sends itself to the supplier, and tracks itself through delivery. Your involvement: reviewing a dashboard once a day to confirm everything is on track.

Here is the technical walkthrough.

Step 1: Calculate Reorder Point Per SKU

The reorder point is the inventory level at which a new purchase order should be created. Set it too high and you overstock. Set it too low and you run out. The formula is straightforward:

Reorder Point = (Average Daily Sales x Supplier Lead Time) + Safety Stock

Breaking Down Each Variable

Average Daily Sales: Use the last 30-60 days of actual sales data. Not last year's data (too stale). Not last week's data (too volatile). Thirty to sixty days gives you a reliable velocity figure that accounts for recent trends without overreacting to daily noise.

Pull this data across all channels, not just one. If you sell 8 units per day on Amazon and 4 per day on Shopify, your average daily sales for reorder point calculation is 12, the total across all channels.

Supplier Lead Time: This is the number of days from when you send the PO to when the inventory is received, inspected, and available for sale. It includes:

• Supplier processing time (typically 1-5 days)
• Manufacturing or picking time (varies widely)
• Shipping time (2-5 days domestic, 15-45 days international)
• Receiving and inspection time at your warehouse (1-2 days)

Use your 90th percentile lead time, not your average. If your supplier has delivered in 10, 12, 14, 14, 15, 16, 17, 18, 20, and 21 days over your last 10 orders, your 90th percentile is 20 days. Use 20.

Safety Stock: This is your cushion for when things go wrong: supplier delays, demand spikes, shipping problems. A common formula:

Safety Stock = (Maximum Daily Sales - Average Daily Sales) x Maximum Lead Time

If your average daily sales are 12 but your peak day was 25, and your maximum lead time is 21 days:

Safety Stock = (25 - 12) x 21 = 273 units

That might seem like a lot. It is. For high-value items, you might accept a lower service level (85-90% instead of 99%) and carry less safety stock. For your top sellers, carry the full amount. A stockout on your #1 SKU is catastrophically more expensive than storing an extra few weeks of inventory.

Worked Example

Variable	Value	Source
Average Daily Sales	12 units	Last 45 days, all channels
Supplier Lead Time (90th percentile)	20 days	Last 10 PO receipts
Safety Stock	168 units	(25 peak - 12 avg) x (21 max lead time) x 0.615 for 95% service level
Reorder Point	408 units	(12 x 20) + 168

When this SKU hits 408 units in stock, an automated PO fires. That gives you 20 days of lead time coverage plus a safety cushion for demand spikes or supplier delays.

Step 2: Calculate Reorder Quantity

Knowing when to order is half the equation. Knowing how much to order is the other half.

The simplest approach: order enough to cover your lead time plus a replenishment period, typically 30-60 days of supply.

Reorder Quantity = Average Daily Sales x (Lead Time + Replenishment Period) - Current Stock at Reorder Point + Safety Stock

But in practice, three constraints modify this number:

Constraint 1: Minimum Order Quantities (MOQs)

Most suppliers have MOQs. If your calculated reorder quantity is 200 units but the MOQ is 500, you order 500. Build this into your automation logic so the PO always meets or exceeds the supplier's minimum.

Constraint 2: Case Pack Quantities

If your supplier ships in cases of 24, and your reorder quantity is 200, round up to 216 (9 cases). Odd quantities cause shipping problems, receiving confusion, and sometimes price penalties.

Constraint 3: Container Economics (For International Suppliers)

If you import by sea, partial containers are expensive per unit. A 20-foot container holds roughly 800-1,200 small cartons. If your reorder quantity fills half a container, consider bumping up to a full container, the per-unit shipping cost drops by 30-40%. Your automated system should flag when a PO is between 50-80% of a container and suggest adding quantity.

Step 3: Configure Supplier Details

Every automated PO needs to know where to go. For each supplier in your system, configure:

• Contact information: Email address for PO transmission (or EDI endpoint if your supplier supports it)
• Lead time: Default lead time for this supplier (overridden by per-SKU lead time if available)
• MOQs: Minimum order quantity, both per-SKU and per-order total
• Payment terms: Net-30, Net-60, prepaid, this affects your cash flow forecasting
• Shipping method: Air, sea, ground, determines lead time and cost
• Currency: USD, EUR, CNY, for international suppliers
• Preferred PO format: PDF attachment, CSV, or EDI, your system should generate the PO in the format the supplier expects

Multi-Supplier Strategy

For critical SKUs, configure a primary and secondary supplier. If the primary supplier cannot fulfill (out of stock, factory shutdown, lead time exceeds threshold), the automated PO routes to the secondary supplier automatically. This costs you nothing during normal operations and saves you during disruptions.

The price difference between primary and secondary suppliers is usually 5-15%. That premium is worth it when your primary supplier goes dark for 3 weeks during Chinese New Year and your #1 SKU is about to stock out.

Step 4: Set Up Automated PO Triggers

Now you connect the pieces. For each SKU, the system monitors current inventory level and compares it to the reorder point. When inventory drops at or below the reorder point, the PO trigger fires.

Trigger Logic

The basic trigger is simple: IF current_stock <= reorder_point AND no_open_PO_exists THEN create_PO

That second condition is critical. Without it, the system creates a new PO every time it checks inventory, once every few minutes or hours, resulting in dozens of duplicate POs. The system must check for existing open POs for the same SKU/supplier combination before creating a new one.

Trigger Configuration Example

SKU	Reorder Point	Reorder Qty	Supplier	Auto-Send	Review Hold
WIDGET-BLK-M	408	500	Zheng Manufacturing	Yes	4 hours
WIDGET-BLK-L	312	500	Zheng Manufacturing	Yes	4 hours
GADGET-RED-S	85	200	Ohio Parts Co.	Yes	4 hours
BUNDLE-GIFT-01	45	100	Multiple (components)	No	Manual review

Notice the "Review Hold" column. When a PO is created, it sits in "Created" status for 4 hours before being automatically sent to the supplier. This is your safety window. If the trigger fired incorrectly, a data entry error, a returned batch that temporarily dropped inventory, a seasonal slowdown that makes the order premature, you can catch it and cancel during the hold period.

After 2-3 months of running, most sellers reduce the hold period to 1 hour or eliminate it entirely for high-confidence SKUs. Trust builds with data.

Step 5: The PO Lifecycle: 6 Stages

An automated PO is not "set it and forget it." It flows through a lifecycle, and each stage matters:

Stage 1: Created

The system detected that inventory is at or below the reorder point and generated a PO. The PO includes: SKU(s), quantities, unit prices, shipping terms, expected delivery date, and supplier details. It sits in your system waiting for the review hold period to expire.

Stage 2: Sent

After the review hold, the system transmits the PO to the supplier. Transmission method depends on supplier configuration, email with PDF attachment is most common, followed by EDI for larger suppliers. The system logs the send timestamp and starts a response timer.

Automation tip: Set a 48-hour alert for unacknowledged POs. If the supplier has not responded within 48 hours of receipt, the system flags the PO for manual follow-up. Suppliers lose PO emails. It happens more often than you think.

Stage 3: Acknowledged

The supplier confirms they received the PO and provides an expected ship date. This is the most important data point in the entire lifecycle, the supplier's confirmed delivery date feeds back into your inventory forecasting. If the supplier says delivery will take 25 days instead of your expected 20, your system should recalculate whether you need to expedite shipping or adjust channel-level inventory allocation to stretch remaining stock.

Stage 4: Shipped

The supplier has dispatched the order and provided tracking information. For domestic shipments, this gives you a 2-5 day window to prepare for receiving. For international shipments, this starts the customs and logistics clock, typically 15-30 days by sea.

Stage 5: Partially Received

This stage exists because reality is messy. Suppliers short-ship. Containers arrive with damage. Quality inspection rejects a portion of the order. Your system needs to handle partial receipts gracefully:

• Add received units to available inventory immediately
• Track remaining units on the same PO (do not create a new PO for the shortage)
• Recalculate whether the partial receipt is sufficient to cover demand until the remaining units arrive
• If the remaining units will not arrive in time, consider triggering a supplementary PO to the secondary supplier

Stage 6: Received

All units are counted, inspected, and added to available inventory. The PO is closed. The system updates the supplier's actual lead time data, which feeds into future reorder point calculations. Over time, your reorder points become more accurate because they are based on actual performance, not estimates.

Step 6: Handle Edge Cases

Automated systems are great until reality throws a curveball. Plan for these scenarios in advance:

Seasonal Demand Shifts

Your reorder points are based on trailing 30-60 day averages. When demand is climbing (approaching Q4, product going viral), those averages lag behind reality. Solution: apply a seasonal multiplier. If historical data shows Q4 sales are 2.5x Q3, multiply your reorder point by 2.5 starting October 1. Build these multipliers into your system with start/end dates so they activate and deactivate automatically.

New Product Launches

New products have no sales history. You cannot calculate a reorder point from zero data. For new SKUs, set the reorder point manually based on your demand forecast for the first 60-90 days. After you have 30+ days of actual sales data, switch to automated calculation.

Supplier Disruptions

When your primary supplier is unable to fulfill, factory fire, port closure, bankruptcy, the system should automatically route to your secondary supplier. Configure fallback rules: if primary supplier does not acknowledge within 72 hours, or if primary supplier's confirmed lead time exceeds a threshold, auto-route to secondary.

Bundled Products

If you sell a bundle containing 3 different SKUs, the reorder logic must track component-level inventory, not bundle-level. You need 10 of each component to make 10 bundles. If Component A hits its reorder point but Components B and C are well stocked, you only need to reorder Component A. Your PO system needs to understand product composition to avoid over-ordering components that are not actually needed.

Step 7: Build Your PO Dashboard

You should be able to answer these questions in under 60 seconds by looking at a single screen:

• How many POs are open right now?
• Which POs are overdue (past expected delivery date)?
• Which SKUs are within 7 days of stockout based on current velocity and incoming POs?
• What is the total value of open POs (your committed spend)?
• Which suppliers have the worst on-time delivery rates?

Key Metrics to Track

Metric	Target	Why It Matters
Stockout Rate	<2%	Percentage of time a SKU is out of stock across all channels
PO Accuracy	>95%	Percentage of automated POs that did not require manual modification
Supplier On-Time Rate	>85%	Percentage of POs delivered within the confirmed delivery window
Average Lead Time Variance	<3 days	Difference between expected and actual lead time
Procurement Time per PO	<5 minutes	Your time spent per PO (review only, system does the rest)

The Before and After

Here is what the numbers look like for a seller managing 200 SKUs across 4 channels:

Metric	Manual POs	Automated POs
Weekly procurement time	6 hours	35 minutes
Stockout rate	8-12%	1-2%
Average PO creation-to-send time	2-3 days	4 hours (review hold)
Missed reorder points	5-8 per month	0
Revenue lost to stockouts (est.)	$8,000-$15,000/month	$500-$1,500/month

That is an 80%+ reduction in stockouts and a 90% reduction in procurement time. The system does not forget to reorder. It does not get distracted by a customer email. It does not go on vacation without setting reminders. It runs continuously, monitoring every SKU against its reorder point, every hour of every day.

Getting Started This Week

You do not need to automate 200 SKUs overnight. Here is the progression:

1. Day 1: Export your sales data for the last 60 days. Calculate average daily sales per SKU.
2. Day 2: Document supplier lead times from your last 5-10 POs per supplier. Use the 90th percentile.
3. Day 3: Calculate reorder points and reorder quantities for your top 10 SKUs.
4. Day 4: Enter supplier details and configure automated triggers in your inventory management system. Nventory supports automated PO triggers with configurable reorder points, supplier routing, and the full 6-stage lifecycle tracking.
5. Day 5: Activate triggers for your top 10 SKUs with a 4-hour review hold.
6. Week 2-4: Monitor, tune, and expand. Adjust reorder points based on actual results. Add the next 20 SKUs.
7. Month 2: Automate remaining SKUs that sell at least 1 unit per week.

By the end of month 2, you will never manually create a PO again. Your stock levels will stay healthy because the system catches every reorder point, every time. And you will spend your freed-up 6 hours per week on things that actually grow the business, not filling out purchase order forms.

The goal is not to remove humans from procurement. It is to remove humans from the repetitive, time-sensitive, error-prone parts of procurement. Let the system handle the triggers and the math. You handle the strategy and the relationships.