Shopify Purchase Order Management

A purchase order (PO) is the document that turns a reorder decision into a delivery. This guide covers what a PO should contain, the stages it moves through, how to size an order, how to track suppliers, and which parts of the process can run on written rules.

What a purchase order is and why it matters

A purchase order is a document you send a supplier that lists the products, quantities, prices and delivery terms you are asking for. Whether you build it in a spreadsheet, an accounting system or an inventory tool, it does three jobs:

• Record. It documents what you asked for and at what price, so a dispute about quantity or cost has something to refer to. Check your supplier terms for what it legally commits either side to.
• Reconciliation. It gives you something to compare received stock against.
• Cash visibility. Every open PO is committed spend, so the list of open POs is a forecast of upcoming payments.

A complete PO has: a sequential PO number, the supplier's name and contact, line items (SKU, description, quantity, unit cost), the expected delivery date, the ship-to location, and the shipping and payment terms. If you hold stock in several places, the ship-to field matters. See multi-location inventory management.

The six stages of a purchase order

1. Demand identification. Decide what to reorder and how much. Compare stock with reorder points, recent sales velocity, planned promotions or seasonal peaks, and the supplier's lead time.
2. PO creation. Fill in the fields above and send it.
3. Supplier confirmation. Treat a PO as unconfirmed until the supplier acknowledges it. Agree a response window, such as two business days, and chase anything unacknowledged.
4. In transit. Track the shipment against the expected date. If it slips, recompute days of supply against the new arrival date to see whether you will stock out.
5. Receiving and reconciliation. Count what arrived against the PO. Check for short shipments, damaged items, wrong products or variants, and price differences. Add units to your sellable inventory only after the count, or you can sell units that are not there.
6. Closure and analysis. Close the PO and record the supplier's performance on it, as described below.

How much to order

Reorder point and lead-time demand

Compare the reorder point with your inventory position, which is physical on hand plus on order minus any units already owed to customers. Using on hand alone makes you reorder a product that already has a PO open. See the reorder point formula and the safety stock formula.

That second figure is why a reorder point set once and never revisited goes stale when demand moves.

Economic order quantity

The economic order quantity (EOQ) balances the cost of placing orders against the cost of holding stock.

D is annual demand in units, S is the cost of placing one order, and H is the holding cost per unit per year. EOQ assumes steady demand and a fixed cost per order. See the EOQ formula and the carrying cost formula.

Minimums, consolidation and timing

• Minimum order values and quantities. If a supplier requires an order value of $500 and your unit cost is $6, an order for 50 units ($300) and a later order for 75 units ($450) both fall short. One order for 125 units ($750) meets the minimum and pays one freight charge instead of two. The trade-off is holding the last 75 units earlier than you need them.
• Volume discounts. Order above the EOQ when the per-unit saving across the year is larger than the extra holding cost.
• Seasonal peaks. Order date = date you need the stock − lead time − buffer. With an 8-week lead time and a one-week buffer, the order goes in nine weeks before demand rises. See seasonal inventory planning.
• Lead time variability. A supplier whose delivery time swings needs more safety stock than one whose time is steady, even if the averages match.

Managing suppliers

Keep a profile for each supplier

Record contacts, the products supplied, minimum order quantity, price breaks, quoted lead time, actual lead times, payment terms, freight terms and order cut-off days. These are the inputs your reorder calculations use, so keep them current. Update lead times whenever a supplier warns of a delay and review them regularly.

Track performance with simple formulas

• On-time delivery rate = POs received by the promised date ÷ POs received.
• Fill rate = units received ÷ units ordered.
• Actual lead time = receipt date − PO date. Track both the average and the spread.
• Order accuracy = POs received with no quantity, variant or price discrepancy ÷ POs received.
• PO cycle time = days from PO creation to PO closure (receipt, reconciliation and any supplier credit settled).

Use a rolling average of recent deliveries rather than the supplier's quote when you plan, and judge suppliers on trends, not on one bad shipment.

Compare suppliers on more than unit price

Landed cost per unit = (total product cost + freight + duties + handling) ÷ units received. Freight, duties and handling are totals for the whole order, not per-unit amounts. A supplier with a lower unit price but late deliveries can cost more once stockouts are counted. Favor reliability on fast, high-margin items and price on slow, low-margin ones.

Dependence on one supplier is a risk. For your A items (see ABC analysis), qualify a backup and keep the relationship alive with occasional test orders.

What can run on rules

Several PO steps are mechanical enough to run on written rules, whether those live in spreadsheet formulas or in software: calculating reorder points, comparing them with inventory position, drafting PO lines and flagging late POs. Negotiation, supplier relationships and unusual demand still need a person. A sensible order of work:

1. Clean the data first. Count your top SKUs. A rule applied to wrong counts makes wrong decisions faster.
2. Start with A items. The top sellers by revenue deserve the first rules.
3. Record lead times. For each supplier, note the average and the longest of the last several orders.
4. Write the alerts as rules. A reorder alert fires when inventory position is at or below the reorder point. A stockout warning fires when days of supply is below the lead time. An overstock alert fires when days of supply exceeds a limit you choose. A velocity alert fires when the sales rate moves outside a band you choose.
5. Keep a person approving POs until the rules have proven themselves.

Review the outputs weekly. Give slow movers their own rules: longer review cycles, minimum quantities and a flag for possible discontinuation (see dead stock management). For bundles and kits, add component demand from every bundle. If a bundle selling 10 a day contains 2 units of a component that also sells 5 a day on its own, the component's demand is 10 × 2 + 5 = 25 a day.

Common purchase order mistakes

• Ordering on feel. Set reorder points from sales, lead time and safety stock, and revisit them monthly.
• Trusting static lead times. Lead times drift with seasons, shortages and shipping disruption, so use recent actuals.
• Updating inventory before counting. A shipment notice is not stock on the shelf.
• Single-supplier dependence. One late delivery then has no fallback.
• Choosing on price alone. See landed cost and reliability above.
• No central record. At minimum keep a sheet with PO number, supplier, status, expected date and received date. See preventing stockouts for how late POs turn into empty shelves.

A 30-day plan

Week 1: audit. List suppliers and their lead times, identify your top SKUs by revenue, and calculate reorder points for them.

Week 2: tracking. Choose a tracker, create a PO template per supplier with standard terms, and set reorder alerts for your top SKUs.

Week 3: process. Write a receiving checklist, tell suppliers how you now issue and confirm POs, and set a weekly PO review.

Week 4: measure. Review the first POs for accuracy, adjust reorder points using actual lead times, and fix the biggest bottleneck. Then add the supplier metrics above to your inventory KPIs, and check your inventory turnover by supplier to spot over-ordering.