AI Matrx Logo

Plumbing contractor

Vineholt Green Plumbing · Plumbing contractor · Duluth, MN

Bram Cavanagh is the office manager at Vineholt Green Plumbing, a five-truck plumbing company in Duluth, and he uses this to keep every pipe, valve and water heater counted, reordered on time and never out of stock when a truck rolls.

Construction and tradesInventoryImports4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

Stock board

Supplies
In stock17
Copper pipe, 3/4-inch Type L, 10 ftVG-1101Pipe and fittings
Copper 90-degree elbow, 3/4-inchVG-1118Pipe and fittings
Copper coupling, 1/2-inchVG-1119Pipe and fittings
PEX crimp rings, 1/2-inchVG-1131Pipe and fittings
Ball valve, 1/2-inch brassVG-1206Valves
12 more
Reorder soon5
PEX-A tubing, 1/2-inch, 100 ft coilVG-1130Pipe and fittings
Push-to-connect coupling, 3/4-inchVG-1142Pipe and fittings
Ball valve, 3/4-inch brassVG-1205Valves
Pressure-reducing valve, 3/4-inchVG-1230Valves
Flux paste, 8 ozVG-1602Solder and flux
Reorder now4
Copper pipe, 1/2-inch Type L, 10 ftVG-1102Pipe and fittings
Gate valve, 1-inchVG-1214Valves
Water heater, 40-gallon gasVG-1301Water heaters
Toilet, elongated whiteVG-1410Fixtures
Back-ordered2
Flange gasket, 3-inchVG-1802Pipe and fittings
Recirculating pump, 1/25 hpVG-1330Water heaters
Discontinued2
Brass compression stop, 3/8-inch, old patternVG-1900Valves
Galvanized nipple, 1-inchVG-1905Pipe and fittings

Tables

Supplies

30 sample rows · 15 columns

Everything on the shelves and trucks: how many are on hand, when to reorder and when it is next counted.

SupplySKUCategoryUnitOn handReorder pointReorder quantity
Ball valve, 1/2-inch brassVG-1206Valveseach482440
Ball valve, 3/4-inch brassVG-1205Valveseach262040
Brass compression stop, 3/8-inch, old patternVG-1900Valveseach40—
Copper 90-degree elbow, 3/4-inchVG-1118Pipe and fittingseach210120200
Copper coupling, 1/2-inchVG-1119Pipe and fittingseach185100200
Copper pipe, 1/2-inch Type L, 10 ftVG-1102Pipe and fittings10-foot length224060
Copper pipe, 3/4-inch Type L, 10 ftVG-1101Pipe and fittings10-foot length644060
Drain cleaning cable, 50 ftVG-1511Drain and sewereach323
Expansion tank, 2-gallonVG-1315Water heaterseach968
Flange gasket, 3-inchVG-1802Pipe and fittingseach01040
Flux paste, 8 ozVG-1602Solder and fluxeach7612
Galvanized nipple, 1-inchVG-1905Pipe and fittingseach120—

18 more rows

Suppliers

8 sample rows · 12 columns

The supply houses the shop buys from, with the rep to call and how fast each delivers.

SupplierSales repRep phoneRep emailAccount numberPayment termsLead time (days)
Cascade Seals and GasketsIgnatius Valdivia(218) 555-0108ignatius.valdivia@cascadesealsgaskets.comVG-71369Net 156
Copperline Solder and Flux Co.Alaric Bessette(218) 555-0106alaric.bessette@copperlinesolder.comVG-71095Prepaid4
Eastgate Plumbing SupplyKatarzyna Mbeki(218) 555-0101katarzyna.mbeki@eastgateplumbingsupply.comVG-70410Net 302
Harbor View FixturesTeodor Rasmussen-Lee(218) 555-0104teodor.rasmussenlee@harborviewfixtures.comVG-70821Net 307
Ironrange Drain SupplyGiselle Onyango(218) 555-0105giselle.onyango@ironrangedrainsupply.comVG-70958Due on receipt2
Lakehead Pipe and ValveOsvaldo Frisk(218) 555-0102osvaldo.frisk@lakeheadpipeandvalve.comVG-70547Net 303
Northern Heater WholesalePhilomena Ardizzone(218) 555-0103philomena.ardizzone@northernheaterwholesale.comVG-70684Net 155
Superior Tool SalesMarisela Thornbury(218) 555-0107marisela.thornbury@superiortoolsales.comVG-71232Net 301

Purchase orders

12 sample rows · 9 columns

Each order placed with a supplier, what it covers and when it arrived.

PO numberSupplierOrder statusOrderedExpectedReceivedItems ordered
PO-4144Harbor View FixturesSentOct 4, 2026Oct 11, 2026—Toilet, elongated white
PO-4138Lakehead Pipe and ValveSentOct 3, 2026Oct 6, 2026—Copper pipe, 1/2-inch Type L, 10 ft, Gate valve, 1-inch
PO-4141Northern Heater WholesaleSentOct 2, 2026Oct 7, 2026—Water heater, 40-gallon gas
PO-4135Eastgate Plumbing SupplyPartly receivedSep 29, 2026Oct 2, 2026—PEX-A tubing, 1/2-inch, 100 ft coil, PEX crimp rings, 1/2-inch, Push-to-connect coupling, 3/4-inch
PO-4153Superior Tool SalesCancelledSep 26, 2026Sep 28, 2026—Pipe cutter, 1/2 to 1-1/4 inch
PO-4132Ironrange Drain SupplyReceivedSep 20, 2026Sep 22, 2026Sep 22, 2026PVC pipe, 3-inch, 10 ft, PVC sanitary tee, 3-inch
PO-4129Harbor View FixturesReceivedSep 16, 2026Sep 23, 2026Sep 23, 2026Toilet fill valve, Wax ring with bolts
PO-4126Northern Heater WholesaleReceivedSep 14, 2026Sep 21, 2026Sep 22, 2026Water heater, 50-gallon electric, Expansion tank, 2-gallon
PO-4123Lakehead Pipe and ValveReceivedSep 7, 2026Sep 11, 2026Sep 12, 2026Copper pipe, 3/4-inch Type L, 10 ft
PO-4120Eastgate Plumbing SupplyReceivedSep 1, 2026Sep 4, 2026Sep 4, 2026Copper 90-degree elbow, 3/4-inch, Copper coupling, 1/2-inch
PO-4147Copperline Solder and Flux Co.Draft———Flux paste, 8 oz
PO-4150Cascade Seals and GasketsDraft———Flange gasket, 3-inch

Views

Count calendar

Supplies
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6Copper pipe, 3/4-inch Type L, 10 ftBrass compression stop, 3/8-inch, old pattern
7PEX-A tubing, 1/2-inch, 100 ft coil
8Ball valve, 1/2-inch brass
9Water heater, 50-gallon electric
10Toilet, elongated white
11PVC sanitary tee, 3-inch
12Thread seal tape
13Copper pipe, 1/2-inch Type L, 10 ftRecirculating pump, 1/25 hp
14PEX crimp rings, 1/2-inch
15Gate valve, 1-inch
16Expansion tank, 2-gallon
17Toilet fill valve
18Drain cleaning cable, 50 ft
19Pipe cutter, 1/2 to 1-1/4 inch
20Copper 90-degree elbow, 3/4-inchGalvanized nipple, 1-inch
21Push-to-connect coupling, 3/4-inch
22Pressure-reducing valve, 3/4-inch
23Water heater flex connector, 18-inch
24Wax ring with bolts
25Lead-free solder, 1 lb roll
26Flange gasket, 3-inch
27Copper coupling, 1/2-inch
28Ball valve, 3/4-inch brass
29Water heater, 40-gallon gas
30Kitchen faucet, single handle chrome
31PVC pipe, 3-inch, 10 ft

Forms and booking

Truck stock request

Form
Truck stock requestThe form a plumber fills in from the truck to ask the office for a part that has run low.
Which part do you need more of? *
What is the SKU on the bin label? *
Which kind of part is it? *Pipe and fittingsValvesWater heatersFixturesDrain and sewerSolder and fluxTools and consumables
How does the shop count it? *eachbox of 2510-foot lengthrollcase of 12
How many are left on the truck?
Send to the office

Dashboards

Stock health

Supplies
Supplies by stock status
  • In stock17
  • Reorder now4
  • Reorder soon5
  • Back-ordered2
  • Discontinued2
Supplies by category
  • Pipe and fittings9
  • Valves5
  • Water heaters5
  • Fixtures4
  • Drain and sewer3
  • Solder and flux2
  • Tools and consumables2
Counts due by week
  • Oct 4, 20266
  • Oct 11, 20268
  • Oct 18, 20268
  • Oct 25, 20267
  • Nov 1, 20261

Also included

  • Monday reorder listDigest
  • Count coming dueNotificationReminds the office two days before a supply is due for its next count.

Related templates