I’m working on a specification work for a local food coop, Alterconso, who has a pretty achieved and complex model. The coop gathers 50 producers, 8 employees and 750 customers. They deliver subscription based baskets of fruits, vegetables, dairy, bread, etc. each in three sizes in 14 distribution points in Lyon (big city in southern France). On top of baskets they also have “grocery dried products” that people buy on demand (jams, juices, beer, etc.) so they are going to embed with iframe the “grocery shop” to start with.
They want their own website so that their customers can choose their subscription plan, modify it, set up a “holiday period” to stop momentary the baskets, etc. And also buy online their dried products.
They have a social pricing, they take 0% margin for low income people, 10% for students and unemployed people and 20% for the others so the users will need to be tagged and we are working on a new tag rule to apply or not entreprise fees.
Any user who has a subscription plan today is registered in a home made database.
We are super value aligned, and they don’t have the money to build their own super efficient custom platform, so we are going to partner and work together, they are a super reference for us, and we can co-finance some of the features they need.
The first step of our cooperation will be around the integration of the “grocery management” part, they will keep managing the subscription on their current home made system until we can test with them the subscription feature v1 and specify what they need for v2.
For the grocery shop, they want the user to see the shop with the good price depending on their tag, so we are going to embed with iframe the shop in their website, and the customer will need to be logged in ofn. For the moment we will start with only an OFN login so no need for Single Sign On.
BUT we would like to understand how we can integrate the existing home made database (or any wordpress database if the front end is based on wordpress and that’s were the client choose his subscription plan): when a new subscription is added to their home made database…
- the corresponding user is created into OFN if not already existing
- +the relevant tag is added depending on the category he is classified in in the existing home made database
- +the user is added to the customer list of the corresponding private shop
To start with I guess they might have to set up manually the users in OFNby inviting them through the customer list and adding them a tag. But we need to know how later on we can avoid double entries…
On a step 2 we will need to build a similar integration to create in OFN the subscription plan chosen on their wordpress website.
@Augustin @pierredelacroix @Lory @balessan I let you share your views on that, I think it can be an interesting case to share with the community in the “standalone websites reflexion”, so I suggest we discuss that here.
Maybe also @oeoeaio @maikel and @lin_d_hop @Kirsten would have some ideas, maybe you have already faced this case and have found some solution you can share ?