Inventory management for Shopify plumbing supply stores

The inventory problems plumbing supply stores run into

• Huge SKU counts across sizes and materials. A single fitting type can have a dozen variants for pipe diameter, thread type, and material (PVC, copper, PEX, brass), and each one sells at a different pace.
• Mixed supplier types with different speeds. You might buy brass valves from an overseas manufacturer and copper fittings from a regional wholesaler down the road, so lead times vary a lot SKU to SKU.
• Case packs and box minimums. Fittings and fasteners often ship in bulk packs of 25, 50, or 100, so your reorder quantity has to round up to a full case, not just match forecasted demand.
• Bulky and heavy items tie up cash and shelf space. Items like PVC pipe lengths or cast iron fittings cost more to hold and reorder in bulk, so overordering is expensive and underordering stalls sales.
• Contractor-driven demand spikes. A single commercial job can wipe out your stock of a specific fitting size overnight, which looks like a sales spike rather than steady demand.

Seasonality and demand

Plumbing supply demand often rises in spring and early summer as renovation and new-build projects ramp up, and again before winter when customers stock up on pipe insulation, heat tape, and freeze-prevention parts ahead of cold snaps. Repair parts like valves, washers, and basic fittings tend to sell at a steady pace year round since pipes break regardless of season. Plan ahead of both peaks by placing orders earlier than usual, since suppliers also see higher demand at the same time and may run behind on fulfillment.

Suppliers, lead times and minimums

Plumbing supply stores typically buy from a mix of domestic wholesale distributors, regional manufacturers, and some overseas factories for commodity items like basic fittings and valves. Domestic wholesalers often turn orders around in a week or two, while overseas suppliers often take several weeks and may require larger minimum order quantities to make the shipment worthwhile. Case packs are common, especially for small parts like fittings, washers, and fasteners, which often ship in boxes of 25, 50, or 100 rather than as single units.

Worked example

Say you sell a 1/2 inch brass ball valve averaging 4 units a day. Your supplier's lead time is 10 days and you keep 4 days of safety stock, so your reorder point is 4 x (10 + 4) = 56 units. You currently have 30 on hand and 20 on order, and you want 15 days of cover, so your order quantity is 4 x (10 + 15) - (30 + 20) = 100 - 50 = 50 units. If the valve ships in case packs of 25, SteadyShelf rounds that order up to 50, which already fits evenly, so no adjustment is needed.

Try it with your own numbers in the reorder point calculator, or size your buffer with the safety stock calculator.

A simple system to start this week

1. List every variant separately in Shopify, including pipe size, material, and thread type, so forecasts are accurate per SKU.
2. Enter each supplier's lead time and case pack size into SteadyShelf so order quantities round correctly.
3. Set safety days higher for your fastest-moving repair parts like basic valves and washers, since running out of those stalls customer jobs.
4. Review the weekly reorder email before big seasonal pushes like spring renovation season and pre-winter freeze prep, and place orders earlier than normal.
5. Watch for one-time contractor bulk orders that spike sales data, and manually adjust forecasts if a sale was a one-off rather than a trend.
6. Confirm received shipments in Shopify right away, including partial deliveries, so your on-hand counts stay accurate for the next forecast.

How SteadyShelf fits plumbing supply stores

SteadyShelf fits plumbing supply stores well because it handles the core problem of per-variant forecasting and reorder timing across many SKUs and suppliers with different lead times. It does not track lot numbers or expiry dates, which matters for items like chemical treatments or adhesives with shelf life, so you'll need to manage those manually or with a separate system. It also does not handle multi-location transfers, so if you stock the same item across more than one warehouse or store location, you'll need another tool for moving stock between them.

$29/month flat, unlimited products and suppliers, 30-day free trial.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

More: inventory management by store type · inventory glossary · Stocky alternatives

FAQ