OK, we are simulating for a French pilote user an international buying group, CORTO. They are interested in experimenting OFN in France, if that can make them save time. It’s a consumer-run non-profit volunteer organisation that gets organic citrus fruits directly from a group of Sicilian farmers all the way to Paris. (Anselm was part of this group while living in Paris and says their fruit are just yummy!)
Here is their website for more info (translate with google): http://www.corto.ouvaton.org/wordpress/a-propos-de-corto/
Here is how they are organized:
Here is the process today:
Every SMALL BUYING GROUP (SBG) sends a spreadsheet with the list of products to their members, the members fill in.
The responsible of each SBG sends the aggregated spreadsheet to the manager of their BIG BUYING GROUP, who aggregate the spreadsheets from each SBG
The responsible of the IMPORT ASSO (this is CORTO, of which each final consumer is a paying member) receives and aggregates the spreadsheets (or Google docs) from each BIG BUYING GROUP and sends one single order (without sub-totals) to the EXPORT ASSO in Sicilia, who gathers the products from the producers and ships them.
The products are received in a warehouse near Paris, separated per BIG BUYING GROUP, members of which then come with a small truck to pick up the whole volume for their group and take it to their pick-up point.
Then the members of each SBG come to that pick-up point, separate out the total into the orders of the SBGs, then again into their individual orders and go home with their fresh and delicious-smelling fruit, pasta etc.
Voilà - Here we are!
We have set it up in OFN this way:
- We create one enterprise for IMPORT ASSO: this entity will be the order cycle coordinator. This enterprise charges the import fee for shipping from Sicily to France (10cts per kg).
- We create one enterprise for each producer and make up some products.
- We create one enterprise for each BIG BUYING GROUP (ex: Paris South). In each of those enterprises, we create one shipping method per SBG (because we can’t add another layer of hubs here) - for example: one per neighbourhood in Paris South, so we manage them as different shipment methods, though they essentially have the same geographic pick-up point
- In the order cycle, we propose various distributors, one per BIG BUYING GROUP. So each BIG BUYING GROUP has its own shop and sends the link to their members (would be great to have a login only shop ;-))
As a result:
- When a member orders on the shop of his BIG BUYING GROUP, he chooses the shipping method corresponding to his SBG
- The orders can directly be aggregated at the IMPORT ASSO level (great!) and can be dispatched easily by BIG BUYING GROUP (SBGs are a bit more problematic), so the IMPORT ASSO can send the global order to the EXPORT ASSO in Sicily via email.
We are lacking enough levels to simulate this correctly. The EXPORT ASSO in Sicily is not part of this simulation. We would like the supply chain to be transparent, so we would like to be able to add this intermediate in the chain.
While working on this use case, we realize that basically Open Food Network can only have max 4 layers: producers - coordinator - distributor - shipping method (we used the shipping method to be able to materialize the different sub-groups)
The EXPORT ASSO in Sicily is actually also selling the products to other IMPORT ASSO-type groups like the one I just described (CORTO is just the one for the Paris region, there are around a dozen other such IMPORT ASSOs in France, buying from the same group of farmers in Sicily).
Of course then they can create their own order cycle where the various IMPORT ASSOS (hubs) put the aggregated quantities, but then we have a problem with the stock management, because the stock of each producer has already been purchased at the group level, so it would be a double order for the same products…
How can we do that?
Also we have another issue with having used the shipping methods for the SBGs:
The SBGs take the total of their order at the pick-up point before separating it out to their individual members. Until now the found this total easily in the TOTALs line on their spreadsheet. But in the OFN reports, there is no way to show the aggregated quantity by products filtered by shipping method?
Actually in the “order cycle by distributor”, we have the info for dispatching what the IMPORT ASSO dispatches to the different BIG BUYING GROUPs, but in this report, in the column “shipping method” it’s only written “shipping method”… wouldn’t it be possible to display the info of which shipping method is used, which would allow then each group to filter by sub-group… I know we can use the Customer totals to see the pick-up point displayed but then there is no more aggregation per product…
How can we do that? How can we aggregate infos per products and per shipping method?
I’m not sure everything is clear, it’s a big complex. Please ask if any question.
@sstead if you have any idea on those points that would be awesome