This is here for discussion and as a place to exchange ideas.
History - OFN-Canada has a funded project to build specialty cut flower hubs on the OFN platform. There are 7 hubs now. Our funding includes development of 5 features that address cut flower farm/hub needs. This document describes the priorities (as per discussions with the hubs last year.)
One of the top priorities is the ability for buyers to place ‘advance orders’ or ‘pre-orders’ or also called ‘pre-books’.
Use Case: A wholesale flower buyer (usually an event planner or floral design firm) has a wedding booked for 3 months in the future. (often longer) The buyer has a wishlist of local cut flowers and wants to procure as much as possible from small scale, sustainable farmers. The buyer wants to be able to visit a hub store (supplied by multiple suppliers to maximize the possibility of finding the products she wants) and reserve the product she needs. Later, this reservation becomes an order and payment/delivery… is made.
Initial thoughts/Issues doing this using the OFN app:
Technically, all OFN orders are ‘preorders’. So a hub could set any number of order cycles into the future, suppliers could stock the stores, payment method could be set to ‘pay once order is confirmed’ so payment is not made until product is available. Suppliers would run reports weekly to see whats been ordered for upcoming weeks…
So - we are almost there! A few things need to be developed/modified for this to work:
-
Date picker - a list of 20 or more order cycles in the drop down is not useable. So maybe there could be a date picker interface, that links to pre-set order cycles. When the buyer selects the date, the store for that date opens. The store is stocked with the suppliers ‘best guess’ at what products they expect to be available.
-
Setting stock by date: Right now all order cycles count down from a shared pool of stock. So imagine a supplier sells daffodils and will take prebooks for weeks 14, 15, 16 and 18. They have 100 bunches - but the bunhes aren’t all available at once. Living things grow gradually, so its not like an existing set inventory. If a buyer reserves 100 bunches in week 18, that leaves no daffodils for week 14. But really, there are, for example, 50 bunches in week 14, 25 in week 15… There is no way in OFN at present for a supplier to link on hand amounts to specific order cycles.
As an aside - I’ve experimented with using a spreadsheet (which could be an OFN integration) to forecast stock by order cycle, and then every few days, remove items from the incoming section of order cycles if they have been ordered in a different order cycle. Its VERY tedious and time consuming. I can’t imagine many producers doing it, unless someone can imagine an amazing integration. -
Notifications need to change: We don’t really want the buyer to receive an order ‘confirmation’ at the reservation stage. No supplier can ‘confirm’ a product 3 or more months out. We want the buyer to get a ‘reservation notice’ perhaps - something that tells them the producer knows about this and is reserving the product for them, and that the buyer will get an order confirmation when we are 2 weeks out from the event/delivery date. (Possibly we could find a way to translate the current order confirmation…?)
-
Communications between hub and supplier: 2 weeks (or something) ahead of the delivery date, suppliers need to confirm availability of the reserved materials, and confirm pricing and order quantity. Who do they confirm this to? Ideally this is done through the hub (since the hub is legally the seller). So somehow we need suppliers to confirm to the hub, and then the hub prepares a back office order for the buyer. But right now there are no in-app supplier-hub coms. So maybe this is something created outside of OFN - like a set of google sheets where suppliers confirm the availability of preordered stock and a system of integrated email reminders.
Its preliminary thinking I realize. Maybe others see better ways to do this. maybe the entire process happens outside of OFN, maybe in a separate app designed for this, and then orders can be put into OFN? That would have the advantage of building a UI specifically for product reservation.
Finally - while the use case above is wholesale flower buyers with scheduled events, I think other procurement scenerios could be very similar. A restaurant might want to set holiday features well in advance and reserve local product (especially if its local, organic product that is always in short supply like berries …). A food box supplier might want to line up the contents of the box for each week of the season. A caterer also works to specific event dates in the future and will want to procure product for future dates …
Apologies for the non-tech nature of this - I’ve written this from a user perspective. Love to hear thoughts on moving forward.