Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: 30 Checkout Operations per Minute A job for Odoo or not ?

by "Raphaël Valyi" <rvalyi@akretion.com> - 30/04/2021 16:23:18
Hello Frederik, may be you could consider this module from Akretion for a RESTFul asynchronous import bus:
It is using the OCA/queue module.
At the moment it is for sale orders but the same could be done with invoices directly.
Good luck.

On Thu, Apr 29, 2021, 7:47 AM Frederik Kramer <frederik.kramer@initos.com> wrote:
Hi Joe, 

thanks for the valuable feedback. Indeed i wasn't too specific on the
scenario but its quite unlikely that an order in that business case is 
more than 10 items (standard only 1-2 is guess). However all
considerations with decoupling checkout from logisics and financial
fail in our case (a least without further design changes) because the
entire physical / financial transaction needs to be accomplished and
book in less than 10min. But of course a solid message broker
architektur would be something that would be really helpful for the
Odoo ecosystem. Which Message bus do you prefer in your scenarios and
for what reason, if i may ask

Best Frederik

Am Donnerstag, den 29.04.2021, 10:37 +0000 schrieb Joerg Lorenz:


> Hi Fred: 


> 


> instead of looking into the amount of orders, I would rather look


> into the amount of lines per order containing items (excluding the


> one lines that are just informational), first.


> This is the key performance measure.


> If the order line volume is resonable (1-3 on average on an online


> order), then die 30 to 50 a minute is a hands down job, because,


> there is no posting involved, just stock reservation. Question still


> is, what the response time shall be for each order?


> 


> Also a question would be for your scenario, if those really need to


> be put as ORDERs, instead of QUOTEs - which are even simpler to


> consume. 


> 


> If you like we can talk more on your requirements by phone. 


> 


> N.B.


> In very high volume sceanrios we did, like with some 20000 orders a


> minute, we usually just consumed, the orders with an message broker


> first, then preprocessed there, confirmed (if no error), queued and


> batched in the the ERP for processing (we did this for DHL for all


> barcode scanners of Deutsche Post service men in Germany, rond trip


> was supposed to be less than 5 seconds to get confirmation to the


> barcode scanner). 


> 


> Best Joe


> 


> Von: "frederik kramer" <frederik.kramer@initos.com>


> An: "Odoo Community Association, (OCA) Contributors" <


> contributors@odoo-community.org>


> Gesendet: Donnerstag, 29. April 2021 09:52:11


> Betreff: Re: 30 Checkout Operations per Minute A job for Odoo or not


> ?


> 


> Hi Joel, hi Jordi, 


> 


> thanks for your valuable answers. For the time being we don't really


> know about the real scenarios as this is a bolt pitch claim of a VC


> driven startup for now. But from the business model it seems


> reasonably


> realistic for me to ask before claiming something that doesn't hold


> true if it materialized. 


> 


> I am pretty sure that - given the business model - there will be rush


> hours. So yes, i could even conceive 50 instead of 30 orders a


> minute. 


> 


> In similar use cases that you just explained, we have been applying


> both of the strategies you mention


> 


> 1.) Decoupling stock moves


> 2.) Batch processing in off-peak times


> 


> In the use case at stake both does not really work as the entire


> transaction from Checkout to Delivery (incl. Picking) is supposed to


> take less then 10 min incl. pyhsical transport. 


> 


> Nevertheless i think all of that may be doable but, i will certainly


> not claim "without hassle and much invest".


> 


> Thanks for your answers


> 


> Am Donnerstag, den 29.04.2021, 07:32 +0000 schrieb Joël Grand-


> Guillaume:


> 


> 


> > Hi Frederik,


> 


> 


> > 


> 


> 


> > 


> 


> 


> > Yes this is a big number ! Look, first before anything else, how


> many


> 


> 


> > lines on average for those orders ? According to my XP, this


> matters


> 


> 


> > a lot.


> 


> 


> > 


> 


> 


> > Second question is: Are there rushing hours and more calm hours ? 


> 


> 


> > 


> 


> 


> > In our XP we could not record more than 10 orders per minute. Was


> on


> 


> 


> > V 12 though, so it might have improved a bit by now. In our case,


> we


> 


> 


> > had a rush and calm hour. So the jobs could be recorded during rush


> 


> 


> > hours and processed during calm ones. It worked well, but that was


> 


> 


> > for not that many numbers...


> 


> 


> > 


> 


> 


> > An idea would be to decoule the order confirmation from the stock


> 


> 


> > move generation and do this in two different times. You could


> ensure


> 


> 


> > the reservation using our stock allocation module.


> 


> 


> > 


> 


> 


> > Cannot really help much at this stage,


> 


> 


> > 


> 


> 


> > Joël


> 


> 


> > 


> 


> 


> > 


> 


> 


> > On Thu, Apr 29, 2021 at 1:32 AM Jordi Ballester Alomar <


> 


> 


> > jordi.ballester@forgeflow.com> wrote:


> 


> 


> > > We have a use case with approx 5000/day. I can see how 50000/day


> 


> 


> > > can become a hell. Imagine recomputing a field, or migrating


> 


> 


> > > between versions.


> 


> 


> > > 


> 


> 


> > > It's a challenge, I give you that.


> 


> 


> > > 


> 


> 


> > > On Wed, Apr 28, 2021 at 10:35 PM Frederik Kramer <


> 


> 


> > > frederik.kramer@initos.com> wrote:


> 


> 


> > > > Hi Folks, 


> 


> 


> > > > 


> 


> 


> > > > i have a project proposal on my desk that will ultimately end


> up


> 


> 


> > > > in


> 


> 


> > > > approx. 30 checkout transactions per minute. Has anybody got a


> 


> 


> > > > project


> 


> 


> > > > with that order volume done with a relatively recent version of


> 


> 


> > > > Odoo


> 


> 


> > > > and provide a good reference. Please bear in mind that the


> 


> 


> > > > project


> 


> 


> > > > ahead involves a similarly high volume of stock moves.


> 


> 


> > > > 


> 


> 


> > > > Any suggestion / comment like (but not limited to) 


> 


> 


> > > > 


> 


> 


> > > > Odoo is the wrong technology for that, forget it, because....


> 


> 


> > > > 


> 


> 


> > > > over


> 


> 


> > > > 


> 


> 


> > > > You can do it but, a), b), c) ....


> 


> 


> > > > 


> 


> 


> > > > to


> 


> 


> > > > 


> 


> 


> > > > If you really want that beast flying involve us over here


> because


> 


> 


> > > > we


> 


> 


> > > > are among the few ones that already did soemthing similar


> 


> 


> > > > 


> 


> 


> > > > would be appreciated. 


> 


> 


> > > > 


> 


> 


> > > > From our load intensive projects at initOS i know that 10000


> 


> 


> > > > orders a


> 


> 


> > > > day can be handled but almost 50000 is a different story and


> 


> 


> > > > thats why


> 


> 


> > > > i am asking the most experienced resource out there ;-)


> 


> 


> > > > 


> 


> 


> > > > Thanks in advance for your replay


> 


> 


> > > > 


> 


> 


> > > > Cheers Frederik


> 


> 


> > > > 


> 


> 


> > > > 


> 


> 


> > > > 


> 


> 


> > > > -- 


> 


> 


> > > > Dr.-Ing. Frederik Kramer


> 


> 


> > > > Geschäftsführer


> 


> 


> > > >         


> 


> 


> > > > initOS GmbH


> 


> 


> > > > An der Eisenbahn 1


> 


> 


> > > > 21224 Rosengarten


> 


> 


> > > >         


> 


> 


> > > > Phone:  +49 4105 56156-12


> 


> 


> > > > Fax:    +49 4105 56156-10


> 


> 


> > > > Mobil:  +49 179 3901819


> 


> 


> > > >         


> 


> 


> > > > Email: frederik.kramer@initos.com


> 


> 


> > > > Web:   www.initos.com


> 


> 


> > > >         


> 


> 


> > > > Geschäftsführung:


> 


> 


> > > > Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke


> 


> 


> > > > 


> 


> 


> > > > Sitz der Gesellschaft: Rosengarten – Klecken


> 


> 


> > > > Amtsgericht Tostedt, HRB 205226


> 


> 


> > > > Steuer-Nr: 15/200/53247


> 


> 


> > > > USt-IdNr.: DE815580155


> 


> 


> > > > 


> 


> 


> > > > _______________________________________________


> 


> 


> > > > Mailing-List: https://odoo-community.org/groups/contributors-15


> 


> 


> > > > Post to: mailto:contributors@odoo-community.org


> 


> 


> > > > Unsubscribe: https://odoo-community.org/groups?unsubscribe


> 


> 


> > > 


> 


> 


> > > 


> 


> 


> > > -- 


> 


> 


> > > Jordi Ballester Alomar


> 


> 


> > > CEO & Founder | ForgeFlow


> 


> 


> > > (+34) 629530707 | jordi.ballester@forgeflow.com | 


> 


> 


> > > https://www.forgeflow.com


> 


> 


> > > Twitter: https://twitter.com/jordibforgeflow | Linkedin: 


> 


> 


> > > https://www.linkedin.com/in/jordiballesteralomar


> 


> 


> > > _______________________________________________


> 


> 


> > > Mailing-List: https://odoo-community.org/groups/contributors-15


> 


> 


> > > Post to: mailto:contributors@odoo-community.org


> 


> 


> > > Unsubscribe: https://odoo-community.org/groups?unsubscribe


> 


> 


> > 


> 


> 


> > 


> 


> 


> -- 


> Dr.-Ing. Frederik Kramer


> Geschäftsführer


>         


> initOS GmbH


> An der Eisenbahn 1


> 21224 Rosengarten


>         


> Phone:  +49 4105 56156-12


> Fax:    +49 4105 56156-10


> Mobil:  +49 179 3901819


>         


> Email: frederik.kramer@initos.com


> Web:   www.initos.com


>         


> Geschäftsführung:


> Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke


> 


> Sitz der Gesellschaft: Rosengarten – Klecken


> Amtsgericht Tostedt, HRB 205226


> Steuer-Nr: 15/200/53247


> USt-IdNr.: DE815580155


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe


-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer
        
initOS GmbH
An der Eisenbahn 1
21224 Rosengarten
        
Phone:  +49 4105 56156-12
Fax:    +49 4105 56156-10
Mobil:  +49 179 3901819
        
Email: frederik.kramer@initos.com
Web:   www.initos.com
        
Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference