Inventory management for Shopify aquarium and fish supply stores

The inventory problems aquarium and fish supply stores run into

• Livestock is not stock in the normal sense. fish, plants, and inverts are not reorderable the way a filter cartridge is, and SteadyShelf's forecasting is built for the latter, not live animals with mortality risk.
• Water chemistry and medications have expiry dates. test kit reagents, conditioners, and treatments degrade or expire, and selling old stock risks bad results or refunds.
• Variant sprawl on hardware. a single filter model can have a dozen SKUs for replacement cartridges, media types, and pump sizes, and each needs its own reorder math.
• Tank and equipment sizing creates huge SKU counts. heaters, lights, and pumps are sold by tank size and wattage, so one product line can quietly become 40 variants.
• Bulky, heavy freight. substrate, rock, and large tanks ship slow and cost more, so lead times and order quantities need bigger safety margins than small dry goods.

Seasonality and demand

Demand usually rises in spring and early summer as people start new tanks, and again around the holidays when aquariums are a common gift. Heating equipment sells more in winter in colder climates, and algae and summer-stress products pick up when tank temperatures rise. New tank season also pulls through water conditioners, test kits, and starter substrate together, so a spike in one often signals a spike in the others. Plan by building extra safety days into your reorder points before these windows, since most suppliers will not speed up to match a sudden spring rush.

Suppliers, lead times and minimums

Dry goods (filters, heaters, lights, food, chemicals) usually come from a handful of aquarium-specific distributors with set case packs and moderate minimums, often arriving within a week or two domestically. Specialty or import gear (certain European or Asian brands) can take several weeks from overseas suppliers and may have higher MOQs to justify the shipping cost. Livestock and live plants come from separate wholesalers or local breeders on their own delivery schedules, usually weekly or biweekly, and are bought to order rather than kept as backstock. Bulky items like substrate, rock, and large tanks often ship freight rather than parcel, which can mean longer lead times and minimum order quantities tied to pallet or case counts.

Worked example

Say you sell a canister filter replacement media cartridge, selling about 3 units a day. Your supplier's lead time is 10 days and you keep 4 safety days, so your reorder point is 3 x (10 + 4) = 42 units. You want 21 days of cover on top of lead time, so target stock is 3 x (10 + 21) = 93 units. If you currently have 30 on hand and 10 already on order, your order quantity is 93 - (30 + 10) = 53 units, which SteadyShelf would round up to the supplier's case pack, say 60.

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 hardware variant separately (tank size, wattage, media type) so forecasting is accurate per SKU.
2. Set supplier lead times in SteadyShelf for each distributor, including longer ones for overseas or specialty brands.
3. Add safety days based on how bulky or freight-dependent the item is, not a flat number across the board.
4. Keep livestock, live plants, and anything expiry-dated out of SteadyShelf's automated reorder flow and manage those manually.
5. Review the weekly reorder email before approving, especially around spring and holiday ramp-up.
6. Record partial deliveries as they arrive, since freight shipments on substrate and tanks often come in split.

How SteadyShelf fits aquarium and fish supply stores

SteadyShelf works well for the hardware and consumables side of an aquarium store: filters, heaters, lights, food, and chemical supplies with stable, forecastable demand. It does not track expiry dates, so you still need a manual process for rotating dated chemistry and medications. It also will not manage livestock or live plants, since those are not standard orderable, non-perishable inventory, so keep those purchasing decisions outside the app.

$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