A spreadsheet of subscribers
You started a weekly flower subscription for local customers: a seasonal bouquet delivered every Friday. It was popular. Now there is a spreadsheet with subscribers, their frequency (weekly, fortnightly, monthly), address, delivery notes and payment method.
Every week, someone checks the spreadsheet. A subscriber is on holiday for two weeks. Another asked by email to skip this Friday. A gift subscription ended last month but nobody noticed. One subscriber's card payment failed, and she has had three bouquets without paying.
Most weeks, the list is nearly right. Nearly is where the complaints come from.
Why subscriptions are harder than they look
Recurring orders carry a stream of small changes, and each arrives by a different route: email, phone, a note at the counter. They all have to reach the spreadsheet before the weekly list is made.
Payments often run separately from the list. A card payment that fails does not automatically take the subscriber off the delivery list.
Gift subscriptions have fixed ends, and the person paying is different from the person receiving. Both need to hear different things at different times.
What a spreadsheet subscription costs
| Problem | Effect |
|---|---|
| Skips and pauses missed | Flowers delivered to empty homes |
| Failed payments not linked | Bouquets delivered unpaid |
| Gift subscriptions not ended | Deliveries nobody paid for |
| Changes by email and phone | Staff time and missed updates |
| No simple view of subscriber numbers | Hard to plan stems and deliveries |
Subscriptions can give a florist a steady base of weekly work. They only stay worthwhile if running them does not eat that value.
The timing of changes matters as much as the changes themselves. A skip request that arrives on Thursday evening, after the Friday bouquets are already made, is not really a skip. Without a clear cut-off that subscribers can see, every late change becomes a judgement call at the counter, and different staff make different calls.
Delivery days add another layer. Some subscribers are on the Friday run, some take a Tuesday collection from the shop, and some are just outside your usual area and share a run with contract work. A spreadsheet can hold that, but it cannot tell the driver which subscribers moved this week.
Buying for subscriptions depends on the list being right. If the weekly count is uncertain until Thursday, you order stems on Monday for a number you are guessing, and either buy too many or run short. An accurate list, known early, lets subscription work sit in the regular order rather than being topped up from the shop buckets.
How we run subscriptions
- Subscribers sign up on your website, choosing frequency, size and start date, with recurring payments through a provider such as Stripe or your website platform's subscription tools.
- Each subscriber has a simple account page to skip a delivery, pause for a holiday, change address or update their card, without emailing you.
- Gift subscriptions have a fixed number of deliveries, with the gift giver told when it is ending and invited to renew.
- Failed payments trigger a message to the subscriber and, after a set time, a hold on deliveries until it is resolved.
- Each week, a make list and a delivery list are produced from active subscriptions, taking every skip, pause and change into account.
- The stem requirement for subscriptions feeds your weekly wholesale order, so buying for them is planned.
If your website platform has subscription tools that fit, we set them up and add only what is missing, such as the weekly lists.
Friday without the spreadsheet
On Wednesday, the week's subscription list is ready: every active subscriber, with skips and pauses removed, and addresses up to date. The florist knows how many bouquets to make. The driver has the run. Payments are already collected.
- Subscribers make their own changes
- Payments linked to deliveries
- Gift subscriptions ended and renewed properly
- Accurate weekly make and delivery lists
Signs your subscriptions have outgrown the spreadsheet
- Subscription changes arrive by email and phone.
- Flowers have been delivered to subscribers who asked to skip.
- Failed payments are not linked to deliveries.
- Gift subscriptions have run past their end.
- Building the weekly list takes a long time.