Dahlia Tuber Inventory & Preorder Tracker for Google Sheets & Excel
Division batches, storage bins, waitlists and pick slips · by Unelify
$19USD · one-time payment
Buy nowInstant download after payment. You get a PDF with your Google Sheets links (a blank copy and an example farm) and the Excel files. A free Google account is enough.
- Instant digital download, nothing is shipped
- Works in Google Sheets and Microsoft Excel
- When tubers are lost, promised lines in fill order turn Short and Today names the customer to contact
- Varieties with a short code: what you own, what is promised and what you can still sell, after your planting stock and presale holdback
- Division batches in storage bins, with dated bin checks, printable bin labels and count sheets
- A Tuber Log for every loss by reason (rot, dried out, no viable eye, broken or damaged, disease concern, other), move, recount, seconds and planted tuber, and a season check that adds up
- A waitlist that shows when you can offer tubers, and offers that remind you to follow up
- Pickup day: printable pick lists with suggested bins, bag tags and order summaries with your terms, on US Letter or A4; longer orders may take more pages
- Deposits, payments and refunds with each customer's balance; an agreed total turns red if the order changes later
- Dated price changes, your currency, 4 color sets and your own words for the labels
- Check and update it on a phone; print from a computer
Every tuber, from division to pickup
When you divide, type one row per batch: the variety, the bin, the good tubers and seconds. Print a label for each bin. Through the winter, date each bin check and log every loss with its reason. Reservations are filled in a fixed order: packed lines first, then reserved lines and offers by their date. When stock drops, the last lines show Short, and Today tells you whom to contact. When tubers free up, the first waitlist line shows Can offer. On pickup day, print the pick list, bag tags and order summary. Record the batches pulled, update any Short lines after agreeing a change with the customer, and mark fully packed lines Packed.
How it works
- Set it upOn Settings: farm name, contact line, currency, season and batch number prefix. On Bins: one row for each bin, crate, box or shelf. In Google Sheets, first set your Locale (country) and Time zone (File > Settings).
- Add your varietiesA short code you write on the tubers (CAL), the name, the price and how many you keep for planting.
- Record batches as you divideVariety, bin, good tubers, seconds and the date. On Bin Label, choose a bin and print its label or count sheet.
- Through the winterDate each bin check on Bins. Log every loss, move, recount and planted tuber on the Tuber Log.
- Take reservationsThe customer on Customers, then one row per variety on Reservations. Money goes on Payments.
- Pickup dayPrint the pick list and bag tags from Pick Slip, pack from the suggested bins and record the batch used. If a line is Short, agree the change with the customer and update the reservation before marking it Packed.
What's inside
At a glance (tubers in your bins, available to sell, short tubers, waitlist you can offer, offers to follow up, bins due a check, handovers this week, still to collect), who to contact first, the season check and customers to see by date.
Up to 400 varieties: price, planting stock, presale holdback, and every count from divided to handed over, with Available and a status.
Up to 1,000 division batches with their variety, bin, good tubers, seconds and what is in the bin now.
Up to 100 bins, crates, boxes or shelves: place, storage medium, last and next check, tubers now and losses.
Up to 3,000 rows: losses by reason (rot, dried out, no viable eye, broken or damaged, disease concern, other loss), moves between batches, recounts, seconds promoted or downgraded, planted tubers.
Up to 500 customers: pickup, shipping or local delivery, planned date, shipping, discount, optional tax, agreed total and balance.
Up to 3,000 lines: reserved, waitlist, offer pending, packed, handed over, with the fill, Short lines and what to do next.
Up to 2,000 deposits, payments and refunds, each with its customer and method.
For one customer: a pick list with suggested bins, bag tags or an order summary with your terms.
For one bin: a printable label or count sheet showing up to 50 batches, with a warning if there are more.
Your farm, currency, season, batch prefix, follow-up days, dated price changes, payment methods, colors and your own words.
The first steps inside the file, and an example farm (Meadow Lane Dahlias) to look around first.
Questions
Does it text or email my customers?
No. It shows whom to contact and why, and it prints pick lists, bag tags and order summaries. You contact your customers yourself.
Does it take payments or deposits?
No. You take payments the way you do now and record each deposit, payment or refund. The file keeps every customer's balance.
What happens when tubers rot over the winter?
Log the loss on the Tuber Log. Promised tubers are filled in order (packed lines first, then reserved lines and offers by date), so the last lines of that variety show Short, and Today names the customer to contact. The file never decides a refund or a replacement: you do.
How does the waitlist work?
When tubers free up, the first waitlist line of that variety shows Can offer. Add an Offer pending line: it holds the tubers until the customer answers and reminds you to follow up after the number of days you set. It never releases them by itself.
Does it judge which tubers are healthy?
No. Tubers are living things and counts change over the winter. The file counts what you record; it is not plant-health advice.
My prices are changing. What do I do?
Add the new price on Settings > Price changes, dated the day it starts. If a customer's confirmed total changes later, their Agreed total turns red so you can check it before you print.
Does it calculate sales tax?
Yes, a simple tax amount from the optional Sales tax % on Settings. You choose whether shipping is included, or type a different tax amount for a customer. You decide which rates and rules apply. The file does not determine tax obligations, collect taxes or file tax returns, and it is not tax, legal or accounting advice.
Do I need Microsoft Excel?
No. Google Sheets is free with a Google account; on a phone, use the free Google Sheets app. If you prefer Excel, the Excel files are included too: a blank file and the example.
How do I get my copy in Google Sheets?
Open the PDF you download and tap a button: a blank copy or the example. Then tap "Use template". A copy is saved in your own Google Drive.
Can I print from my phone?
Check and update your records on a phone; print from a computer, because the phone apps cannot print a selected range. The printouts are for US Letter and A4. Short orders can fit on one page; longer orders may take more pages. Pick Slip shows up to 60 reservation lines and 20 payments per customer, with a warning if there are more. In Google Sheets, enter the range shown above the slip in the Name box, then choose File > Print > Selected cells.
What about a new season?
Start a new copy with a new batch number prefix and keep the old file as your record. There is room for 400 varieties, 1,000 batches, 100 bins and 3,000 reservation lines.