AI Matrx Logo

Pool service

Saltmeadow Grove Pool Care · Pool service · Tucson, AZ

Umar Rosenquist manages the routes at Saltmeadow Grove Pool Care, a four-truck weekly pool service, and he uses this to see what sits on every shelf, reorder before a bucket runs empty and load the Monday truck count without retyping it.

Home servicesInventoryImports4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 checklist · 1 document · 1 notification · 2 stage rule sets · 1 agent
Use this template

Stock board

Supplies
In stock17
Liquid chlorine 12.5%, 1-gal jugSG-101Sanitizer
Trichlor 3-inch tablets, 50 lb bucketSG-102Sanitizer
Calcium hypochlorite shock, case of 12 one-pound bagsSG-104Sanitizer
Pool salt for chlorine generators, 40 lb bagSG-106Sanitizer
Muriatic acid 31.45%, 1-gal jugSG-201Balancer
12 more
Low8
Dichlor granules, 25 lb bucketSG-103Sanitizer
Stabilizer (cyanuric acid), 50 lb bucketSG-105Sanitizer
Calcium hardness increaser, 25 lb bucketSG-204Balancer
Water clarifier, 1-gal jugSG-303Algae control
DPD chlorine reagent, 2 oz bottleSG-502Test supplies
3 more
On order4
Alkalinity increaser (baking soda), 50 lb bagSG-203Balancer
Sodium bisulfate pH decreaser, 25 lb bucketSG-205Balancer
Cartridge filter, 50 sq ftSG-404Filter media
Chlorinator check valveSG-605Pump and plumbing parts
Out1
Total alkalinity titration refillSG-504Test supplies

Tables

Supplies

30 sample rows · 16 columns

Every chemical, filter part and test kit the routes use, with how many are on the shelf and when to reorder.

SupplySKUCategoryUsual supplierUnitOn handReorder at
Algaecide 60%, 1-gal jugSG-301Algae controlOcotillo Basin Pool SupplyGallon jug118
Phosphate remover, 1-gal jugSG-302Algae controlIronwood Aquatic SupplyGallon jug64
Water clarifier, 1-gal jugSG-303Algae controlIronwood Aquatic SupplyGallon jug34
Metal sequestrant, 1-gal jugSG-304Algae controlIronwood Aquatic SupplyGallon jug73
Muriatic acid 31.45%, 1-gal jugSG-201BalancerSaguaro Chemical WholesaleGallon jug2824
pH increaser (soda ash), 25 lb bucketSG-202BalancerOcotillo Basin Pool Supply25 lb bucket43
Alkalinity increaser (baking soda), 50 lb bagSG-203BalancerOcotillo Basin Pool Supply50 lb bag02
Calcium hardness increaser, 25 lb bucketSG-204BalancerOcotillo Basin Pool Supply25 lb bucket22
Sodium bisulfate pH decreaser, 25 lb bucketSG-205BalancerSaguaro Chemical Wholesale25 lb bucket12
DE filter powder, 25 lb bagSG-401Filter mediaArroyo Pump and Filter Parts25 lb bag96
Filter sand grade 20, 50 lb bagSG-402Filter mediaArroyo Pump and Filter Parts50 lb bag1410
Cartridge filter, 100 sq ftSG-403Filter mediaArroyo Pump and Filter PartsEach64

18 more rows

Restock orders

12 sample rows · 10 columns

Every order placed with a supplier, from the day it goes out to the day it lands on the shelf.

Order numberSupplyQuantityOrder totalOrder statusOrdered onExpected on
PO-2408Sodium bisulfate pH decreaser, 25 lb bucket4$232PlacedOct 3, 2026Oct 6, 2026
PO-2407Chlorinator check valve4$190PlacedOct 2, 2026Oct 8, 2026
PO-2406Cartridge filter, 50 sq ft6$444PlacedOct 1, 2026Oct 7, 2026
PO-2409Alkalinity increaser (baking soda), 50 lb bag5$182.50PlacedSep 30, 2026Oct 5, 2026
PO-2404Algaecide 60%, 1-gal jug16$358.40DeliveredSep 26, 2026Sep 29, 2026
PO-2402Six-way test strips, tub of 10020$295DeliveredSep 24, 2026Sep 27, 2026
PO-2405Telescoping pole, 8 to 16 ft4$156CancelledSep 22, 2026Sep 26, 2026
PO-2400Muriatic acid 31.45%, 1-gal jug48$220.80DeliveredSep 21, 2026Sep 25, 2026
PO-2398Liquid chlorine 12.5%, 1-gal jug96$369.60DeliveredSep 19, 2026Sep 23, 2026
PO-2399Pool salt for chlorine generators, 40 lb bag80$512DeliveredSep 17, 2026Sep 22, 2026
PO-2401DE filter powder, 25 lb bag12$414DeliveredSep 15, 2026Sep 20, 2026
PO-2403Pump lid O-ring, 2-inch30$96DeliveredSep 13, 2026Sep 18, 2026

Suppliers

6 sample rows · 8 columns

The wholesalers the shop buys from, with the rep, the delivery day and what ships free.

SupplierSales repRep phoneRep emailAccount numberDelivery leadFree delivery over
Arroyo Pump and Filter PartsTobias Wennerstrom(520) 555-0173tobias.wennerstrom@arroyopumpfilter.netAPF-88314$300
Cholla Lab and Test SupplyWilhelmina Eklund(520) 555-0174wilhelmina.eklund@chollalabsupply.comCL-55202$150
Ironwood Aquatic SupplyCalliope Brandvold(520) 555-0176calliope.brandvold@ironwoodaquatic.comIA-704153$200
Ocotillo Basin Pool SupplyMarisela Quintrell(520) 555-0172marisela.quintrell@ocotillobasinpool.comOB-227643$250
Palo Verde Equipment DistributingEmeka Thornquist(520) 555-0175emeka.thornquist@paloverdeequip.netPVE-312075$350
Saguaro Chemical WholesaleBenedikt Alvarsson(520) 555-0171benedikt.alvarsson@saguaro-chem-wholesale.comSCW-409182$400

Views

Deliveries due

Restock orders
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5PO-2409
6PO-2408
7PO-2406
8PO-2407
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Forms and booking

Add a new supply

Form
Add a new supplyUsed by the warehouse lead when a new product comes onto the trucks.
What is the product called, with its size? *
Which shelf code does it get? *
What kind of supply is it? *SanitizerBalancerAlgae controlFilter mediaTest suppliesPump and plumbing parts
Who do we buy it from?
How is it counted?Gallon jug50 lb bucket25 lb bucket25 lb bag40 lb bag50 lb bagCaseEach
At what count do we reorder?
How many do we reorder at a time?
What does one cost us?
Where will it be kept?Warehouse shelfChemical cageTruck stock
Add the supply

Dashboards

Supply room

Supplies
Cost to reorder0
Supplies by level
  • In stock17
  • Low8
  • On order4
  • Out1
Stock value by category
  • Sanitizer0
  • Balancer0
  • Algae control0
  • Filter media0
  • Test supplies0
  • Pump and plumbing parts0
Supplies by supplier30

Also included

  • Stock levelStage rules
  • Restock orderStage rules
  • Low supplies each morningDigest
  • Monday shelf countChecklist
  • Order confirmation to supplierDocumentThe note sent with a restock order so the supplier can confirm the quantity and delivery day.
  • Supply is lowNotificationTells the warehouse lead the moment a supply drops to its reorder count.

Related templates