A hydroponic farm runs on a short list of supplies, and it stops when any one of them does. No nutrient, nothing grows. No cubes, nothing is sown, and the gap shows up as an empty channel five weeks later. No clamshells, nothing ships. So the inventory is a list of everything the crop uses up, with a level to reorder at, and one more column that a plain list doesn't have: how many weeks each supply will last at the rate the farm uses it. That column is what shows the nutrient problem every two-part grower meets sooner or later, which is plenty of one part and none of the other. Below is a list for a made-up lettuce and basil farm, the weeks-of-cover sum, lots, and the file.
The short version
- List what the crop uses up: nutrients, pH adjuster, cubes, pots, seed, packaging, sanitizer.
- Count in the unit you buy: bags, sheets, cases.
- Weeks of cover = on hand ÷ used a week.
- Two-part nutrients last as long as the part that runs out first.
- Set each reorder level from weeks of use and the supplier's lead time.
- Write the lot of seed, cubes and nutrient at delivery.
- TaroStack keeps a reorder list in days of cover. More below.
An example list
Counted in mid November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Nutrient concentrate, part A, 25 lb bag | bag | 5 | 3 | $46.00 | $230.00 | OK |
| Nutrient concentrate, part B, 25 lb bag | bag | 2 | 3 | $41.00 | $82.00 | REORDER |
| pH down, 1 gal | jug | 3 | 2 | $24.00 | $72.00 | OK |
| Calibration solution, pH 4 and 7, EC | set | 2 | 1 | $32.00 | $64.00 | OK |
| Rockwool cubes, 1 in, sheet of 200 | sheet | 22 | 30 | $9.50 | $209.00 | REORDER |
| Net pot, 2 in, case of 1,000 | case | 2 | 1 | $68.00 | $136.00 | OK |
Twelve rows in all, $1,839.00 at cost, with three to reorder: nutrient part B, rockwool cubes and clamshells. The other six rows are lettuce and basil seed, clamshells, sleeves for living lettuce, labels and sanitizer.
Weeks of cover
| Supply | Used a week | On hand | Weeks of cover |
|---|---|---|---|
| Nutrient part A | 0.5 bag | 5 bags | 10.0 |
| Nutrient part B | 0.5 bag | 2 bags | 4.0 |
| Rockwool cubes | 12 sheets | 22 sheets | 1.8 |
| Clamshells | 1.4 cases | 3 cases | 2.1 |
| Lettuce seed | 0.4 pack | 3 packs | 7.5 |
The use figures are this farm's own: it sows 2,400 cubes a week, 2,000 of them lettuce, packs about 700 clamshells of basil, and goes through a bag of each nutrient part every two weeks.
The nutrient is good for four weeks, not ten. Part A and part B go into the reservoir together. Five bags of A are no use once B is gone, so the pair lasts as long as B does. The $230 of part A on the shelf looks like cover and isn't. Order the parts as a pair and count them as a pair.
Cubes are the urgent one. Under two weeks. A missed sowing doesn't hurt this week. It's a channel with nothing to harvest about five weeks from now, on this farm's lettuce, and nothing done then can fill it.
Clamshells are the one that stops a truck. Two weeks of cover, and printed or sized packaging isn't on a shelf at the supplier.
Setting the level. Weeks of use while you wait for a delivery, plus a cushion. If cubes take a week to arrive and the farm wants a week and a half in hand, the level is 2.5 weeks: 30 sheets, which is what the list has. The sum is in reorder point example, and the cushion in safety stock formula.
Deliveries, with their lots
| Received | Item | Lot or batch | Quantity | Use by | Note |
|---|---|---|---|---|---|
| Nov 4 | Lettuce seed, pelleted, 5,000 count | Lot L-70442 | 3 | Oct 31, 2027 | Germination tested 2026-09: 96% |
| Nov 10 | Nutrient concentrate, part A, 25 lb bag | Batch NA-26-118 | 4 | Nov 30, 2028 | Batch from the bag's seam |
| Nov 13 | Rockwool cubes, 1 in, sheet of 200 | Lot RW-5521 | 20 |
When a sowing comes up patchy, there are three suspects: the seed, the cubes, and the water. With the lot of each written at delivery, and the sowing date on the tray, the farm can see whether every tray from one seed lot is patchy or only the ones sown on a certain day. Without them it's a guess, and the supplier will say so.
Write the germination figure and date for seed, and keep seed cold and dry. A list for seed alone is in seed inventory spreadsheet.
Counting
Count every week, on the same day, before the order goes in. It takes ten minutes for twelve rows. Count opened bags and sheets as fractions. The file's count sheet takes what the list said and what you found, and works out the difference at cost. A plan for what to count when is in cycle count form. The business around the list is in hydroponic farm business plan and is hydroponic farming profitable.
Get the template
Download the hydroponic farm inventory template. The supply list with values and a status for each row, a deliveries sheet with lots and dates, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The weeks-of-cover table is as good as its "used a week" column, and that's an average typed in once. A farm that adds a rack, or switches a channel from lettuce to basil, uses different amounts the next week and the table doesn't know. The list is also only right on counting day. By Thursday it's Monday's numbers less whatever went into the reservoir.
How TaroStack does it
TaroStack works out the cover from what's actually used.
A reorder list in days of cover, on every plan, from how stock really moves.
Reorder points suggested from use, so the level follows the farm when it grows.
Suppliers with lead times and minimums, and what each promises checked against how long deliveries really take.
Receiving records the lot and its dates for seed, cubes and nutrient.
Counting on a phone, with no signal in the grow room, sent later.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Weeks of cover | An average, typed in | Days of cover, from real use |
| When to reorder | A fixed level | Suggested from use and lead time |
| Which seed lot was sown | A note on the tray | The lot on the stock |
| What's on hand today | Monday's count | Stock as it moves |
Stock, lots, receiving and the reorder list are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
