Archives
Contributors
-
Shipping Costs
Hello,
I found this requirement that I don't see existing features to support it.
Target version is Odoo 14.
A Sales order has a shipping costs line.
There is a shipping price charged to the customer, that is zero in most cases.
And there is an actual cost, that should depend on the delivery method we end up using.
The first gap is that the "Update Shipping Cost" button on the Sales Order updates the *price*, and not the cost.
The second gap is that, if you do set an amount on the SO line cost field, it is not carried over to the invoice.
The account_invoice_margin module solves this, but then, when posting the invoice this cost information is not used for the posting, and is not recorded in the accounting entries.
I'm ready to create a module to support this case, but I'm wondering if I am missing something here.
Am I thinking through this right?
Thanks!
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal 
by Daniel Reis - 05:01 - 29 Apr 2021-
Re: Shipping Costs
to add shipping as cost in accounting, you need to have a vendor bill. a cost must have a contra in the balance sheet (e.g payable or cash)the sales module only look at the revenue side.--On Fri, 30 Apr 2021 at 5:12 PM, Daniel Reis <dreis@opensourceintegrators.com> wrote:This is is concerned with outgoing stock and COGS.
I could be wrong, but I think that landing costs is for incoming stock, and their stock valuation.
Correct?
On 30/04/2021 08:57, Antonio M. Vigliotti (gmail) wrote:
Did you see the landing cost module?
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Dominique KON-SUN-TACK [Project Manager]Odoo Gold Partner, best Odoo Partner 2014 for APACMobile: + 65 8502 2399Skype: dominique_elicoWebsite: www.elico-corp.com
by dominique.k - 03:50 - 30 Apr 2021 -
Re: Shipping Costs
Yes it is correct but I think the concept should be used to evaluate actual value in documents.
We wrote an experimental module that lands costs in every line of document, so any module can use this value per it own purpose.
Give mi some time and i write an pratical example
Antonio M. Vigliotti
Mobile (+39) 342.8740910
Il 30/04/21 11:12, Daniel Reis ha scritto:
This is is concerned with outgoing stock and COGS.
I could be wrong, but I think that landing costs is for incoming stock, and their stock valuation.
Correct?
On 30/04/2021 08:57, Antonio M. Vigliotti (gmail) wrote:
Did you see the landing cost module?
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Antonio M. Vigliotti - 03:36 - 30 Apr 2021 -
Re: Shipping Costs
This is is concerned with outgoing stock and COGS.
I could be wrong, but I think that landing costs is for incoming stock, and their stock valuation.
Correct?
On 30/04/2021 08:57, Antonio M. Vigliotti (gmail) wrote:
Did you see the landing cost module?
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
by Daniel Reis - 11:11 - 30 Apr 2021 -
Re: Shipping Costs
Did you see the landing cost module?
Antonio M. Vigliotti
Mobile (+39) 342.8740910
Il 29/04/21 17:02, Daniel Reis ha scritto:
Hello,
I found this requirement that I don't see existing features to support it.
Target version is Odoo 14.
A Sales order has a shipping costs line.
There is a shipping price charged to the customer, that is zero in most cases.
And there is an actual cost, that should depend on the delivery method we end up using.
The first gap is that the "Update Shipping Cost" button on the Sales Order updates the *price*, and not the cost.
The second gap is that, if you do set an amount on the SO line cost field, it is not carried over to the invoice.
The account_invoice_margin module solves this, but then, when posting the invoice this cost information is not used for the posting, and is not recorded in the accounting entries.
I'm ready to create a module to support this case, but I'm wondering if I am missing something here.
Am I thinking through this right?
Thanks!
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Antonio M. Vigliotti - 09:56 - 30 Apr 2021 -
Re: Shipping Costs
Cost of 1. Use quantity. Would be my simple workaround.On Fri, 30 Apr 2021, 3:02 am Daniel Reis, <dreis@opensourceintegrators.com> wrote:Hello,
I found this requirement that I don't see existing features to support it.
Target version is Odoo 14.
A Sales order has a shipping costs line.
There is a shipping price charged to the customer, that is zero in most cases.
And there is an actual cost, that should depend on the delivery method we end up using.
The first gap is that the "Update Shipping Cost" button on the Sales Order updates the *price*, and not the cost.
The second gap is that, if you do set an amount on the SO line cost field, it is not carried over to the invoice.
The account_invoice_margin module solves this, but then, when posting the invoice this cost information is not used for the posting, and is not recorded in the accounting entries.
I'm ready to create a module to support this case, but I'm wondering if I am missing something here.
Am I thinking through this right?
Thanks!
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Graeme Gellatly - 09:06 - 29 Apr 2021
-
-
Confirm unsubscription to Contributors
Your Channel
Contributors
Hello,
You have requested to be unsubscribed to the mailing list Contributors.
To confirm, please visit the following link: https://odoo-community.org/groups/unsubscribe/15/16398/2eb67cc745fb1534875df5daebaf9183.
If this was a mistake or you did not requested this action, please ignore this message.
Odoo Community Association (OCA) info@odoo-community.org | http://odoo-community.org Powered by Odoo _______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by info@odoo-community.org - 09:51 - 29 Apr 2021 -
30 Checkout Operations per Minute A job for Odoo or not ?
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
by Frederik Kramer - 10:16 - 28 Apr 2021-
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
El jue, 6 may 2021 a las 5:02, Frederik Kramer (<frederik.kramer@initos.com>) escribió:Hi Moises, Am Freitag, den 30.04.2021, 16:02 +0000 schrieb Moises Lopez: > Hi Frederik > > A customer requested to support 5k concurrent sale.order (1 or 2 > lines of products) in Odoo. > The process that we followed were: test, measure, fix, test... haha, yes thats what works well if you have a customer that well endorses this "agile" and "pivoting" style of work. Apart from all economic considerations this is probably also something that isolated leads to quite solid solutions
Well, we are talking about 5k concurrent VUs in this special case.The cost vs benefit demands this.> > The first time that we tested the checkout process supported 15 > concurrent virtual users (VUs) > The measure said that it had heavy custom functions in the same > transaction of checkout but it could be executed in background (cron, > queue) > and there were slow queries because of indexes issues or too many > queries executed because of python code did you use any specific profiling tools here? Or the ones that rcollet often proposes in his talks about the matter ?
Watch my talk in SFOI used the same tools> > Note: Be careful with the base_automation if you can migrate them to > code it is better. Thanks for the hint, i think we experienced that also quite some times in the past and learned that lesson already ;-) > > After fix them the next iteration supported 400 VUs > So good but so far from the focus. > > The next iteration we found that there were methods that could be > using LRU-cache (e.g. prices, website that don't change) > Now we needed to check where the cache was clearing too frequently > and fix it. How did you measure LRU cache hit rates vs. code parts in a good way. Any tooling suggestion here ?
For the case of the price in the website our reasoning was:- The value don't change in a long time for this customer (each 6 months)- It couldn't be a stored field in the database because it depends on:- date- quantity- currency rate (if your have multi-currency)- partner- Supplier price (if your price depends on it)- product category- Adding LRU-Cache with these keys will work fine and fasterEven the website the most of request came from public userI share you the output of the following command in production:- kill -SIGUSR1 WORKER-PIDIt shows the hit rates:- 19715 hit 91.5% ratio for website._get_cached_values- 3507 hit 75.8% ratio for website.get_pricelist_available_cached> > We implemented CDN > e.g. The sentence "/web/image/company.logo" runs 10 queries > (prefetching fields, translating fields...) for each user opening the > page > After using CDN 0 queries are executed. But you just used Odoos standard CDN function or any specific measure here ?
> > We removed soft process that running with many users it is heavy > e.g. the random image that odoo assign when you create a res.partner > e.g. computed fields moved to cron Also here which analysis tools do you prefer to do so ? > > After that we detected concurrent update issues > It is hell for performance matter. > e.g. updating the same record at the same time from many users, > e.g. allowing pressing the same button too many times > e.g. sequences using no-gap in the main process, and so on > > After finishing all the hints of performance issues in the code and > database the next steps were to improve the hardware. > > Now, It supports 5k concurrent VUs doing checkout process (choose 2 > products, type address, payment card info and confirm) In what time frame ? > > So, Odoo will support those users but you will need to test, measure, > fix, test... > Stress testing tools helps us a lot here > python profilers and query analyzers too > > Maybe you are interest to watch our talk in SFO about: > - https://youtu.be/kiREZqg3JQg I will definitely have a look at this Thanks a lot for your extensive insight. Cheers from rainy Germany to sunny Mexico ;-) Frederik > > El mié, 28 abr 2021 a las 15:35, Frederik Kramer (< > frederik.kramer@initos.com>) escribió: > > 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 > > -- 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
--Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo
by Moisés López Calderón - 05:21 - 14 May 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
El jue, 6 de may. de 2021 a la(s) 05:02, Frederik Kramer (frederik.kramer@initos.com) escribió:Hi Moises, Am Freitag, den 30.04.2021, 16:02 +0000 schrieb Moises Lopez: > Hi Frederik > > A customer requested to support 5k concurrent sale.order (1 or 2 > lines of products) in Odoo. > The process that we followed were: test, measure, fix, test... haha, yes thats what works well if you have a customer that well endorses this "agile" and "pivoting" style of work. Apart from all economic considerations this is probably also something that isolated leads to quite solid solutions
That was our biggest measured customer (a recovered project) they know their KPI very well, on simpler customers, we try from a commercial perspective to explain exactly what Moises does (in a more extensive/commercial way) to try to teach them how to buy technology.At the end if you try let's say Shopify (the king of marketed e-commerce) with those numbers you mentioned or this ones they will offer you more **Enterprise** services (note the services not the software) because almost everybody works on this way even the order on which your usual customers make click on the website can change the outcome and bring performance/consistency problems, i.e: click twice a button in an slow process that by mistake land an specific day on your code).Then what's important IMHO is to clarify to the customer that set technically solid e-commerce is 30% software product 50% the right team.If this was not the case, we would have millions of amazon stores, Don't you think?> > The first time that we tested the checkout process supported 15 > concurrent virtual users (VUs) > The measure said that it had heavy custom functions in the same > transaction of checkout but it could be executed in background (cron, > queue) > and there were slow queries because of indexes issues or too many > queries executed because of python code did you use any specific profiling tools here? Or the ones that rcollet often proposes in his talks about the matter ?
Be careful here, they are a lot, and in my honest experience that's more the person using the tool than the tool itself.> > Note: Be careful with the base_automation if you can migrate them to > code it is better. Thanks for the hint, i think we experienced that also quite some times in the past and learned that lesson already ;-) > > After fix them the next iteration supported 400 VUs > So good but so far from the focus. > > The next iteration we found that there were methods that could be > using LRU-cache (e.g. prices, website that don't change) > Now we needed to check where the cache was clearing too frequently > and fix it. How did you measure LRU cache hit rates vs. code parts in a good way. Any tooling suggestion here ?
1. log-sql and a strong test setup that emulates the production environment is required.2. We use some SQL analyzer tools as well.But again, it is a matter of having the right team doing the job because it is not theoretical work, it is practice, test, read, practice, learn, fix, start again. and a little bit of good luck on some cases and being stubborn to solve the issues ;-)> > We implemented CDN > e.g. The sentence "/web/image/company.logo" runs 10 queries > (prefetching fields, translating fields...) for each user opening the > page > After using CDN 0 queries are executed. But you just used Odoos standard CDN function or any specific measure here ?
Standard! we simply use Odoo's CDN functionality.> > We removed soft process that running with many users it is heavy > e.g. the random image that odoo assign when you create a res.partner > e.g. computed fields moved to cron Also here which analysis tools do you prefer to do so ? > > After that we detected concurrent update issues > It is hell for performance matter. > e.g. updating the same record at the same time from many users, > e.g. allowing pressing the same button too many times > e.g. sequences using no-gap in the main process, and so on > > After finishing all the hints of performance issues in the code and > database the next steps were to improve the hardware. > > Now, It supports 5k concurrent VUs doing checkout process (choose 2 > products, type address, payment card info and confirm) In what time frame ?
With the real use case and in a production environment giving the problems more or less 60 days between First work and release into production ready for the action.> > So, Odoo will support those users but you will need to test, measure, > fix, test... > Stress testing tools helps us a lot here > python profilers and query analyzers too > > Maybe you are interest to watch our talk in SFO about: > - https://youtu.be/kiREZqg3JQg I will definitely have a look at this Thanks a lot for your extensive insight.
I summarize with:The team is the key to success here, every single piece in any e-commerce on this use case was given by different persons and led by Moisés because problems are in all layers: BD, Server, Sizing, Odoo, JS, OCA....It is not just one single pill!Cheers from rainy Germany to sunny Mexico ;-) Frederik > > El mié, 28 abr 2021 a las 15:35, Frederik Kramer (< > frederik.kramer@initos.com>) escribió: > > 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 > > -- 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
--Nhomar G Hernández
Vauxoo | CEO
¡Construyamos algo genial!
Cel: +52 (477) 393.3942 | Telegram: nhomar | Twitter: @nhomarMéxico · Venezuela · Costa Rica · Perú
by Nhomar Hernández - 08:01 - 10 May 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
Hi Moises, Am Freitag, den 30.04.2021, 16:02 +0000 schrieb Moises Lopez: > Hi Frederik > > A customer requested to support 5k concurrent sale.order (1 or 2 > lines of products) in Odoo. > The process that we followed were: test, measure, fix, test... haha, yes thats what works well if you have a customer that well endorses this "agile" and "pivoting" style of work. Apart from all economic considerations this is probably also something that isolated leads to quite solid solutions > > The first time that we tested the checkout process supported 15 > concurrent virtual users (VUs) > The measure said that it had heavy custom functions in the same > transaction of checkout but it could be executed in background (cron, > queue) > and there were slow queries because of indexes issues or too many > queries executed because of python code did you use any specific profiling tools here? Or the ones that rcollet often proposes in his talks about the matter ? > > Note: Be careful with the base_automation if you can migrate them to > code it is better. Thanks for the hint, i think we experienced that also quite some times in the past and learned that lesson already ;-) > > After fix them the next iteration supported 400 VUs > So good but so far from the focus. > > The next iteration we found that there were methods that could be > using LRU-cache (e.g. prices, website that don't change) > Now we needed to check where the cache was clearing too frequently > and fix it. How did you measure LRU cache hit rates vs. code parts in a good way. Any tooling suggestion here ? > > We implemented CDN > e.g. The sentence "/web/image/company.logo" runs 10 queries > (prefetching fields, translating fields...) for each user opening the > page > After using CDN 0 queries are executed. But you just used Odoos standard CDN function or any specific measure here ? > > We removed soft process that running with many users it is heavy > e.g. the random image that odoo assign when you create a res.partner > e.g. computed fields moved to cron Also here which analysis tools do you prefer to do so ? > > After that we detected concurrent update issues > It is hell for performance matter. > e.g. updating the same record at the same time from many users, > e.g. allowing pressing the same button too many times > e.g. sequences using no-gap in the main process, and so on > > After finishing all the hints of performance issues in the code and > database the next steps were to improve the hardware. > > Now, It supports 5k concurrent VUs doing checkout process (choose 2 > products, type address, payment card info and confirm) In what time frame ? > > So, Odoo will support those users but you will need to test, measure, > fix, test... > Stress testing tools helps us a lot here > python profilers and query analyzers too > > Maybe you are interest to watch our talk in SFO about: > - https://youtu.be/kiREZqg3JQg I will definitely have a look at this Thanks a lot for your extensive insight. Cheers from rainy Germany to sunny Mexico ;-) Frederik > > El mié, 28 abr 2021 a las 15:35, Frederik Kramer (< > frederik.kramer@initos.com>) escribió: > > 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 > > -- 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
by Frederik Kramer - 12:01 - 6 May 2021 -
Re: 30 Checkout Operations per Minute A job for Odoo or not ?
Hi FrederikA customer requested to support 5k concurrent sale.order (1 or 2 lines of products) in Odoo.The process that we followed were: test, measure, fix, test...The first time that we tested the checkout process supported 15 concurrent virtual users (VUs)The measure said that it had heavy custom functions in the same transaction of checkout but it could be executed in background (cron, queue)and there were slow queries because of indexes issues or too many queries executed because of python codeNote: Be careful with the base_automation if you can migrate them to code it is better.After fix them the next iteration supported 400 VUsSo good but so far from the focus.The next iteration we found that there were methods that could be using LRU-cache (e.g. prices, website that don't change)Now we needed to check where the cache was clearing too frequently and fix it.We implemented CDNe.g. The sentence "/web/image/company.logo" runs 10 queries (prefetching fields, translating fields...) for each user opening the pageAfter using CDN 0 queries are executed.We removed soft process that running with many users it is heavye.g. the random image that odoo assign when you create a res.partnere.g. computed fields moved to cronAfter that we detected concurrent update issuesIt is hell for performance matter.e.g. updating the same record at the same time from many users,e.g. allowing pressing the same button too many timese.g. sequences using no-gap in the main process, and so onAfter finishing all the hints of performance issues in the code and database the next steps were to improve the hardware.Now, It supports 5k concurrent VUs doing checkout process (choose 2 products, type address, payment card info and confirm)So, Odoo will support those users but you will need to test, measure, fix, test...Stress testing tools helps us a lot herepython profilers and query analyzers tooMaybe you are interest to watch our talk in SFO about:El mié, 28 abr 2021 a las 15:35, Frederik Kramer (<frederik.kramer@initos.com>) escribió:
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
--Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo
by Moisés López Calderón - 06:00 - 30 Apr 2021
-
-
Rename a module with migration script
Hello all! We are trying to rename a module. The main purpose is to change the name of the module itself, as well as xmlids, models and tables. Preliminary step: - Add a pre-migrate script like this one in new_name_module (bumping the version number): https://github.com/OCA/l10n-italy/pull/2220/commits/d6c790525e1892be1d04391054ccb779092c354c#diff-a86bc87cb07b27f04908e90baeb089a9182ad568d8e7205f40f3e689272bb76c Test steps: 1) old_name module installation 2) add/change some data in Odoo 3) checkout to commit containing new_name module, migration script and version bumped 4) launch old_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u old_name_module --stop-after-init Output: old_name_module: not installable, skipped In fact pre-migrate script is not triggered. As an alternative to 4), we tried this: 4) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init But it didn't work as well. The only way (we have found so far) to trigger pre-migrate script is this: 1) old_name module installation 2) add/change some data 3) checkout to commit containing new_name module, migration script and version bumped 4) execute odoo shell >>> from openupgradelib import openupgrade >>> openupgrade.update_module_names(env.cr, [('old_name_module', 'new_name_module'),], merge_modules=False,) >>> env.cr.commit() 5) launch new_name_module update: ./odoo-bin -c etc/odoo14.cfg -d testdb -u new_name_module --stop-after-init Do you know a way to trigger the migration script without using odoo shell? Thanks in advance. S.
by Sergio Zanchetta - 10:16 - 28 Apr 2021-
Re: Rename a module with migration script
You can't do the operation from the migrations scripts of the module with the new name itself, as they are not going to be ever triggered.You need to add the rename in the file https://github.com/OCA/OpenUpgrade/blob/13.0/odoo/addons/openupgrade_records/lib/apriori.py (or https://github.com/OCA/OpenUpgrade/blob/14.0/openupgrade_scripts/apriori.py for v14) for taking effect.Regards.
by Pedro M. Baeza - 08:15 - 29 Apr 2021
-
-
RFQ - OCA Communication Strategy Expert
Dear Contributors,
I hope your week's have started well.
Late last week we shared through our social media our latest RFQ. To share further please find the information below.The OCA is looking for a Communication Strategy Expert to help define our Communication Strategy for the next 3 years.
To find out about the work schedule and deliverables please see here: https://drive.google.com/file/d/19EL646MjjpI4lN47v4P18tHMk2q_1ktR/viewIf you have any questions please email: rfq@odoo-community.orgWarmest regards,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 10:15 - 28 Apr 2021-
RFQ - OCA Communication Strategy Expert
Dear OCA Contributors,
I hope your week's have started well.
Late last week we shared through our social media our latest RFQ. To share further please find the information below.The OCA is looking for a Communication Strategy Expert to help define our Communication Strategy for the next 3 years.
To find out about the work schedule and deliverables please see here: https://drive.google.com/file/d/19EL646MjjpI4lN47v4P18tHMk2q_1ktR/viewIf you have any questions please email: rfq@odoo-community.orgWarmest regards,Rebecca--Rebecca GellatlyGeneral SecretaryOdoo Community Association
by Rebecca Gellatly - 10:15 - 28 Apr 2021
-
-
Enable Github Discussions for l10n-brazil
HiSomeone with permission to configure OCA´s projects, could kindly activate the github discussions of the Brazilian Localization project?Thanks in advanceLuis Felipe Miléo
CEOphone: +55 11 3090-9303
mobile: +55 35 988 763 663
R. Coronel Renó, 07 - Sala PC.2.3.01
Itajubá - MGkmee.com.br 
by Luis F Miléo - 10:15 - 28 Apr 2021 -
punchout and cxml
Hello One of our customers would like to have his Odoo instance available through "punchout", possibly using cXML """ PunchOut is not a link to a web site. PunchOut is an easy-to-implement protocol for interactive sessions managed across the Internet. PunchOut is a communication from one application to another, achieved through a dialog of real-time, synchronous cXML messages, which support user interaction at a remote site. It is the best way to manage user sessions distributed across web applications. This protocol is most commonly used today in the form of Procurement PunchOut, which specifically supports interactions between a procurement application and a supplier’s eCommerce web site and possibly includes an intermediary for authentication and version matching. Procurement PunchOut describes the "traditional" PunchOut scenarios that use the regular PunchOut Setup Request and PunchOut Setup Response. The PunchOut session is initiated with a PunchOutSetupRequest and terminates with a posting of a PunchOutOrderMessage, which contains the initiating transaction’s cookie and a shopping cart or “quote”. """ (http://cxml.org/faq.html) Anyone already faced a similar requirement? Thanks for your feedback -- Alexandre Fayolle Senior Software Engineer Tel : +33 4 58 48 20 30 Camptocamp France SAS 18 rue du Lac Saint André 73 370 Le Bourget-du-Lac France http://www.camptocamp.com
by Alexandre Fayolle - 10:14 - 28 Apr 2021 -
Special way of searching for products
Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
by Radovan Skolnik - 10:14 - 28 Apr 2021-
Re: Special way of searching for products
Hi Radovan,I had a similar problem in my company. I partially solved it by developping some module like https://github.com/grap/grap-odoo-incubator/tree/12.0/multi_search_productBasically, I say to the user to don't enter special char.In your exemple, searching "CD*12345" will return all product containing "CD" and "12345" in any order.Maybe it can help you.Note : the wildcard caracter "*" is a global setting that can be changed.Kind regards.GRAP - Service informatique (Groupement Régional Alimentaire de Proximité)Site Web | FramaSphere | Facebook
3 Grande rue des Feuillants, 69001 Lyon
Standard : (+33) 09.72.32.33.17Service Informatique : (+33) 09.73.79.64.40Astreinte Informatique : (+33) 06.81.85.61.43Member of the OCA (Odoo Community Association)Le jeu. 29 avr. 2021 à 11:32, Graeme Gellatly <gdgellatly@gmail.com> a écrit :Well if you can't use trigram, you need to suffer the performance penalty of using Btree indexes for openended text searches. You could partially mitigate by sanitizing to just lowercase and using a like search rather than ilike but probably only worth it for 25k+ products by the time you massage inputs.But odoo.sh lets you connect via psql, so you can try. pg_trgm is bundled in contrib, same as pg_unaccent so should be there. Just whether you have rights to create extensions.On Thu, Apr 29, 2021 at 9:07 PM Radovan Skolnik <radovan@skolnik.info> wrote:Graeme, thanx for input. This part of your email caught my attention: > Stored computed sanitized code, then sanitize search args on way in. Trigram > index that stored field Stored computed sanitized code - no problem. I can do that and had that in mind. Sanitize search args on way in - you say search for bank accounts shows how to do this? Will check that out. Trigram index that stored field - I am on odoo.sh not sure if that is possible there. However if I am able to sanitize both stored code and input that should generally be enough. I am looking specifcally to work with internal reference (default_code) so no need to handle cases like "Red Cat" or "Cat Red" although it would nice also. Best regards Radovan Skolnik On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote: > I've done this for years in one way or another. OCA does have trgm module > which allows similarity search but for most use cases I find mostly the > issue is one of order of search terms. Product search is particularly > sucky because it has all sorts of overrides. This is in general my simple > approach. > 1. Install pg_trgm or else you will feel the pain. 2. Override search and > split the name argument into multiple ilikes. In my case I typically split > on spaces, which means users can search "Red Car" or "Car Red" and get same > result. I do it on spaces only. I know you want to avoid but actually for > your use case you are better just copying the way bank accounts are > sanitized and searched. Stored computed sanitized code, then sanitize > search args on way in. Trigram index that stored field On Thu, Apr 29, 2021 > at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few > ideas based on postgresql: > * not sure if it's possible with SIMILAR TO or ~ operators > * investigate extension * fuzzystrmatch: > https://www.postgresql.org/docs/13/fuzzystrmatch.html [2] * pgtrgm: > https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3] * > create your own unaccent rules: > https://www.postgresql.org/docs/current/unaccent.html [4] regards, > Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a > écrit : Hello, > I have been asked few times by users if it is possible to search for > products in a way omitting special characters (like dash or space for > exmaple) from product's default_code (or even input string). Let me give an > example: Let's say we have a product with default_code like CD-12345-XYZ In > current situation if user enteres "CD12345" or "CD 12345" nothing is > retrieved. Vice versa, if the default_code is CD12345XYZ and user enters > "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would > be to first remove those special characters from the string being searched > for and then search for default_code transformed with some (SQL?) function. > Is anything like that possible? One idea comes to mind using computed field > where that stripped deault_code would be stored and extending default search > to use this. However that would require stored computed field. Any way to > prevent this? > Thank you. Best regards > Radovan Skolnik > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [6] > Post to: mailto: contributors@odoo-community.org [7] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [8] > > -- > Pierre > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [9] > Post to: mailto: contributors@odoo-community.org [10] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [11] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [12] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] > > > > [1] mailto:pierreverkest84@gmail.com > [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html > [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 > [4] https://www.postgresql.org/docs/current/unaccent.html > [5] mailto:radovan@skolnik.info > [6] https://odoo-community.org/groups/contributors-15 > [7] mailto:contributors@odoo-community.org > [8] https://odoo-community.org/groups?unsubscribe > [9] https://odoo-community.org/groups/contributors-15 > [10] mailto:contributors@odoo-community.org > [11] https://odoo-community.org/groups?unsubscribe > [12] https://odoo-community.org/groups/contributors-15 > [13] 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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Sylvain LE GAL - 11:55 - 29 Apr 2021 -
Re: Special way of searching for products
Well if you can't use trigram, you need to suffer the performance penalty of using Btree indexes for openended text searches. You could partially mitigate by sanitizing to just lowercase and using a like search rather than ilike but probably only worth it for 25k+ products by the time you massage inputs.But odoo.sh lets you connect via psql, so you can try. pg_trgm is bundled in contrib, same as pg_unaccent so should be there. Just whether you have rights to create extensions.On Thu, Apr 29, 2021 at 9:07 PM Radovan Skolnik <radovan@skolnik.info> wrote:
Graeme, thanx for input. This part of your email caught my attention: > Stored computed sanitized code, then sanitize search args on way in. Trigram > index that stored field Stored computed sanitized code - no problem. I can do that and had that in mind. Sanitize search args on way in - you say search for bank accounts shows how to do this? Will check that out. Trigram index that stored field - I am on odoo.sh not sure if that is possible there. However if I am able to sanitize both stored code and input that should generally be enough. I am looking specifcally to work with internal reference (default_code) so no need to handle cases like "Red Cat" or "Cat Red" although it would nice also. Best regards Radovan Skolnik On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote: > I've done this for years in one way or another. OCA does have trgm module > which allows similarity search but for most use cases I find mostly the > issue is one of order of search terms. Product search is particularly > sucky because it has all sorts of overrides. This is in general my simple > approach. > 1. Install pg_trgm or else you will feel the pain. 2. Override search and > split the name argument into multiple ilikes. In my case I typically split > on spaces, which means users can search "Red Car" or "Car Red" and get same > result. I do it on spaces only. I know you want to avoid but actually for > your use case you are better just copying the way bank accounts are > sanitized and searched. Stored computed sanitized code, then sanitize > search args on way in. Trigram index that stored field On Thu, Apr 29, 2021 > at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few > ideas based on postgresql: > * not sure if it's possible with SIMILAR TO or ~ operators > * investigate extension * fuzzystrmatch: > https://www.postgresql.org/docs/13/fuzzystrmatch.html [2] * pgtrgm: > https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3] * > create your own unaccent rules: > https://www.postgresql.org/docs/current/unaccent.html [4] regards, > Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a > écrit : Hello, > I have been asked few times by users if it is possible to search for > products in a way omitting special characters (like dash or space for > exmaple) from product's default_code (or even input string). Let me give an > example: Let's say we have a product with default_code like CD-12345-XYZ In > current situation if user enteres "CD12345" or "CD 12345" nothing is > retrieved. Vice versa, if the default_code is CD12345XYZ and user enters > "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would > be to first remove those special characters from the string being searched > for and then search for default_code transformed with some (SQL?) function. > Is anything like that possible? One idea comes to mind using computed field > where that stripped deault_code would be stored and extending default search > to use this. However that would require stored computed field. Any way to > prevent this? > Thank you. Best regards > Radovan Skolnik > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [6] > Post to: mailto: contributors@odoo-community.org [7] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [8] > > -- > Pierre > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [9] > Post to: mailto: contributors@odoo-community.org [10] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [11] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [12] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] > > > > [1] mailto:pierreverkest84@gmail.com > [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html > [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 > [4] https://www.postgresql.org/docs/current/unaccent.html > [5] mailto:radovan@skolnik.info > [6] https://odoo-community.org/groups/contributors-15 > [7] mailto:contributors@odoo-community.org > [8] https://odoo-community.org/groups?unsubscribe > [9] https://odoo-community.org/groups/contributors-15 > [10] mailto:contributors@odoo-community.org > [11] https://odoo-community.org/groups?unsubscribe > [12] https://odoo-community.org/groups/contributors-15 > [13] 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
by Graeme Gellatly - 11:31 - 29 Apr 2021 -
Re: Special way of searching for products
Graeme, thanx for input. This part of your email caught my attention: > Stored computed sanitized code, then sanitize search args on way in. Trigram > index that stored field Stored computed sanitized code - no problem. I can do that and had that in mind. Sanitize search args on way in - you say search for bank accounts shows how to do this? Will check that out. Trigram index that stored field - I am on odoo.sh not sure if that is possible there. However if I am able to sanitize both stored code and input that should generally be enough. I am looking specifcally to work with internal reference (default_code) so no need to handle cases like "Red Cat" or "Cat Red" although it would nice also. Best regards Radovan Skolnik On štvrtok 29. apríla 2021 1:01:59 CEST Graeme Gellatly wrote: > I've done this for years in one way or another. OCA does have trgm module > which allows similarity search but for most use cases I find mostly the > issue is one of order of search terms. Product search is particularly > sucky because it has all sorts of overrides. This is in general my simple > approach. > 1. Install pg_trgm or else you will feel the pain. 2. Override search and > split the name argument into multiple ilikes. In my case I typically split > on spaces, which means users can search "Red Car" or "Car Red" and get same > result. I do it on spaces only. I know you want to avoid but actually for > your use case you are better just copying the way bank accounts are > sanitized and searched. Stored computed sanitized code, then sanitize > search args on way in. Trigram index that stored field On Thu, Apr 29, 2021 > at 9:42 AM Pierre Verkest < pierreverkest84@gmail.com [1] > wrote: Few > ideas based on postgresql: > * not sure if it's possible with SIMILAR TO or ~ operators > * investigate extension * fuzzystrmatch: > https://www.postgresql.org/docs/13/fuzzystrmatch.html [2] * pgtrgm: > https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 [3] * > create your own unaccent rules: > https://www.postgresql.org/docs/current/unaccent.html [4] regards, > Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik < radovan@skolnik.info [5] > a > écrit : Hello, > I have been asked few times by users if it is possible to search for > products in a way omitting special characters (like dash or space for > exmaple) from product's default_code (or even input string). Let me give an > example: Let's say we have a product with default_code like CD-12345-XYZ In > current situation if user enteres "CD12345" or "CD 12345" nothing is > retrieved. Vice versa, if the default_code is CD12345XYZ and user enters > "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would > be to first remove those special characters from the string being searched > for and then search for default_code transformed with some (SQL?) function. > Is anything like that possible? One idea comes to mind using computed field > where that stripped deault_code would be stored and extending default search > to use this. However that would require stored computed field. Any way to > prevent this? > Thank you. Best regards > Radovan Skolnik > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [6] > Post to: mailto: contributors@odoo-community.org [7] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [8] > > -- > Pierre > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [9] > Post to: mailto: contributors@odoo-community.org [10] > Unsubscribe: https://odoo-community.org/groups?unsubscribe [11] > > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 [12] > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe [13] > > > > [1] mailto:pierreverkest84@gmail.com > [2] https://www.postgresql.org/docs/13/fuzzystrmatch.html > [3] https://www.postgresql.org/docs/current/pgtrgm.html#id-1.11.7.40.6 > [4] https://www.postgresql.org/docs/current/unaccent.html > [5] mailto:radovan@skolnik.info > [6] https://odoo-community.org/groups/contributors-15 > [7] mailto:contributors@odoo-community.org > [8] https://odoo-community.org/groups?unsubscribe > [9] https://odoo-community.org/groups/contributors-15 > [10] mailto:contributors@odoo-community.org > [11] https://odoo-community.org/groups?unsubscribe > [12] https://odoo-community.org/groups/contributors-15 > [13] https://odoo-community.org/groups?unsubscribe
by Radovan Skolnik - 11:06 - 29 Apr 2021 -
Re: Special way of searching for products
I've done this for years in one way or another. OCA does have trgm module which allows similarity search but for most use cases I find mostly the issue is one of order of search terms. Product search is particularly sucky because it has all sorts of overrides.This is in general my simple approach.1. Install pg_trgm or else you will feel the pain.2. Override search and split the name argument into multiple ilikes. In my case I typically split on spaces, which means users can search "Red Car" or "Car Red" and get same result. I do it on spaces only.I know you want to avoid but actually for your use case you are better just copying the way bank accounts are sanitized and searched. Stored computed sanitized code, then sanitize search args on way in. Trigram index that stored fieldOn Thu, Apr 29, 2021 at 9:42 AM Pierre Verkest <pierreverkest84@gmail.com> wrote:Few ideas based on postgresql:* not sure if it's possible with SIMILAR TO or ~ operators* investigate extension* fuzzystrmatch: https://www.postgresql.org/docs/13/fuzzystrmatch.html* create your own unaccent rules: https://www.postgresql.org/docs/current/unaccent.htmlregards,Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Pierre_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Graeme Gellatly - 01:00 - 29 Apr 2021 -
Re: Special way of searching for products
"Similar to" operator is the % sign.
You can train users to use it, but I don't think this is what they are expecting.
PostgreSQL fuzzy matching might work.
You can try https://odoo-community.org/shop/product/fuzzy-search-698
Or, you can add a stored computed field to use for search, that copies the product code removing special character.
Then use that field as the search target.
/Daniel
On 28/04/2021 22:41, Pierre Verkest wrote:
Few ideas based on postgresql:
* not sure if it's possible with SIMILAR TO or ~ operators
* investigate extension* fuzzystrmatch: https://www.postgresql.org/docs/13/fuzzystrmatch.html* create your own unaccent rules: https://www.postgresql.org/docs/current/unaccent.html
regards,
Le mer. 28 avr. 2021 à 22:33, Radovan Skolnik <radovan@skolnik.info> a écrit :
Hello, I have been asked few times by users if it is possible to search for products in a way omitting special characters (like dash or space for exmaple) from product's default_code (or even input string). Let me give an example: Let's say we have a product with default_code like CD-12345-XYZ In current situation if user enteres "CD12345" or "CD 12345" nothing is retrieved. Vice versa, if the default_code is CD12345XYZ and user enters "CD-12345" or "CD 12345" nothing is retrieved either. So the solution would be to first remove those special characters from the string being searched for and then search for default_code transformed with some (SQL?) function. Is anything like that possible? One idea comes to mind using computed field where that stripped deault_code would be stored and extending default search to use this. However that would require stored computed field. Any way to prevent this? Thank you. Best regards Radovan Skolnik
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Pierre
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--
Daniel Reis
Managing Director
M: +351 919991307
E: DReis@OpenSourceIntegrators.comAv Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal
by Daniel Reis - 12:11 - 29 Apr 2021
-
-
Following the bank statement changes in v14
Dear OCA friends,Now that most of the key OCA accounting modules are ported to Odoo v14 and that the features that were moved to Odoo Enterprise have been restored in OCA (account_reconciliation_widget in OCA/account-reconcile and account_statement_import in OCA/bank-statement-import), I'm starting to do some real life end-to-end accounting scenarios in Odoo Community v14.The scenario I'm currently testing is the following:- create several vendor bills- add vendor bills to payment order- confirm SEPA payment order- import bank statement with 1 statement line with total amount of paymentIn previous odoo version, if the payment mode was configured with "offsetting_account" = "bank_account", it would generate an account move with the bank account as counterpart account ; and then, in the bank statement reconcile interface, you would match with a proposed blue line and it would not create a new account move but it would update the account move generated by the payment order and link it to the bank statement line.As far as I understand (please correct me if I'm wrong !), this accounting scenario is not possible in Odoo v14. According to my tests on runbot Enterprise, when you are in the bank statement reconcile interface, you can still see blue lines in the proposals, but selecting blue lines will generate a new journal entry, it won't update the journal entry of the payment.In short, the accounting scenario of vendor bill => SEPA payment => bank statement :- with Odoo v9 to v13 with "offsetting_account" = "bank_account" : expense account => supplier account => bank account (total : 3 accounts)- with odoo v14 : expense account => supplier account => Outstanding Payments Account => bank account (total : 4 accounts)So the accounting scenario is similar to what we used to do in v8 with the transfer account (now named "Outstanding Payments Account") before the introduction of the concept of "blue lines" on the bank statement reconcile interface.If this is confirmed, I plan to update the following OCA modules:- account_payment_order from OCA/bank-payment : remove the fields "offsetting_account" and "transfer_account_id" on account.payment.mode. We would keep the field "transfer_journal_id" because you may want to have the journal entry "supplier account => Outstanding Payments Account" in a specific journal that may not be the bank journal.- on account_check_deposit in OCA/account-financial-tools (pending PR https://github.com/OCA/account-financial-tools/pull/1088) : remove the fields "check_deposit_offsetting_account" and "check_deposit_transfer_account_id" on res.company.As these are important changes, I prefer to post this message before modifying the code.And I made a PR to remove the condition payment_id != false on account.move.line in the module account_reconciliation_widget:--Alexis de Lattre
by Alexis de Lattre - 10:13 - 28 Apr 2021-
Re: Following the bank statement changes in v14
As this message was blocked during several days, I copied it on this github issue : https://github.com/OCA/bank-payment/issues/740Please refer to the conversion that took place there. The module account_check_deposit has already been updated ; the account_payment_order module will be updated soon.Le mer. 21 avr. 2021 à 21:28, Alexis de Lattre <alexis.delattre@akretion.com> a écrit :Dear OCA friends,Now that most of the key OCA accounting modules are ported to Odoo v14 and that the features that were moved to Odoo Enterprise have been restored in OCA (account_reconciliation_widget in OCA/account-reconcile and account_statement_import in OCA/bank-statement-import), I'm starting to do some real life end-to-end accounting scenarios in Odoo Community v14.The scenario I'm currently testing is the following:- create several vendor bills- add vendor bills to payment order- confirm SEPA payment order- import bank statement with 1 statement line with total amount of paymentIn previous odoo version, if the payment mode was configured with "offsetting_account" = "bank_account", it would generate an account move with the bank account as counterpart account ; and then, in the bank statement reconcile interface, you would match with a proposed blue line and it would not create a new account move but it would update the account move generated by the payment order and link it to the bank statement line.As far as I understand (please correct me if I'm wrong !), this accounting scenario is not possible in Odoo v14. According to my tests on runbot Enterprise, when you are in the bank statement reconcile interface, you can still see blue lines in the proposals, but selecting blue lines will generate a new journal entry, it won't update the journal entry of the payment.In short, the accounting scenario of vendor bill => SEPA payment => bank statement :- with Odoo v9 to v13 with "offsetting_account" = "bank_account" : expense account => supplier account => bank account (total : 3 accounts)- with odoo v14 : expense account => supplier account => Outstanding Payments Account => bank account (total : 4 accounts)So the accounting scenario is similar to what we used to do in v8 with the transfer account (now named "Outstanding Payments Account") before the introduction of the concept of "blue lines" on the bank statement reconcile interface.If this is confirmed, I plan to update the following OCA modules:- account_payment_order from OCA/bank-payment : remove the fields "offsetting_account" and "transfer_account_id" on account.payment.mode. We would keep the field "transfer_journal_id" because you may want to have the journal entry "supplier account => Outstanding Payments Account" in a specific journal that may not be the bank journal.- on account_check_deposit in OCA/account-financial-tools (pending PR https://github.com/OCA/account-financial-tools/pull/1088) : remove the fields "check_deposit_offsetting_account" and "check_deposit_transfer_account_id" on res.company.As these are important changes, I prefer to post this message before modifying the code.And I made a PR to remove the condition payment_id != false on account.move.line in the module account_reconciliation_widget:--Alexis de Lattre
--Alexis de Lattre
Akretion France - 27 rue Henri Rolland - 69100 Villeurbanne - France
Mail : alexis.delattre@akretion.comMobile : +33 6 99 08 92 45
by Alexis de Lattre - 09:20 - 30 Apr 2021
-
-
By pass security rule on some situation.
Dear community,I want to bypass some field model's security rule. So far, we pass context to tell search/read function to use sudo().But I found this module as the solution we need https://apps.odoo.com/apps/modules/10.0/dynamic_bypass_record_rule/May to double check if community already has something already, else I will ask the author to include it in OCA.Thanks!Kitti U.
by Kitti Upariphutthiphong - 10:13 - 28 Apr 2021-
Re: By pass security rule on some situation.
I will check it. Thank you for the pointer.On Thu, Apr 29, 2021, 19:07 Holger Brunn <mail@hunki-enterprises.com> wrote:
I stand by my claim that allowing to turn off security rules from the client side is a horribly bad idea. If you need this, that means you designed the security rules wrongly, so better go back to the drawing board to write security rules you don't need to bypass. -- Your partner for the hard Odoo problems https://hunki-enterprises.com_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Kitti Upariphutthiphong - 07:16 - 1 May 2021 -
Re: By pass security rule on some situation.
I stand by my claim that allowing to turn off security rules from the client side is a horribly bad idea. If you need this, that means you designed the security rules wrongly, so better go back to the drawing board to write security rules you don't need to bypass. -- Your partner for the hard Odoo problems https://hunki-enterprises.com
by Holger Brunn - 02:06 - 29 Apr 2021 -
Re: By pass security rule on some situation.
On Wed, 28 Apr 2021 at 22:32, Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:Dear community,I want to bypass some field model's security rule. So far, we pass context to tell search/read function to use sudo().But I found this module as the solution we need https://apps.odoo.com/apps/modules/10.0/dynamic_bypass_record_rule/May to double check if community already has something already, else I will ask the author to include it in OCA.Thanks!Kitti U._______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Lorenzo Battistini
https://github.com/eLBati
by Lorenzo Battistini. - 01:51 - 29 Apr 2021
-
-
multichannel sales with different marketplaces
Hello, I'm in contact with a german company who would like to interface Odoo with different marketplaces, such as amazon, ebay but also local german actors. I don't have yet a full list, and the list is likely to evolve over time anyway, so I would not like to use 1 connector backend per marketplace... I think the most cost effective approach would be to use a 3rd party broker which would take care of the nitty gritty details and present Odoo with a single, unified interface. I think lengow does this, and we have a connector_lengow project in the OCA repositories. I'm happy to hear some feedback (on the lengow connector, or on using a broker for this purpose), doubtless some of you already had to walk this path. Thanks -- Alexandre Fayolle Senior Software Engineer Tel : +33 4 58 48 20 30 Camptocamp France SAS 18 rue du Lac Saint André 73 370 Le Bourget-du-Lac France http://www.camptocamp.com
by Alexandre Fayolle - 12:11 - 15 Apr 2021-
Re: multichannel sales with different marketplaces
Thanks Xavier for your feedback I'll keep this in mind. Alexandre On 15/04/2021 13:16, Xavier Brochard wrote: > Hello > > Using a multi-channel dispatcher is the best option, as it is allways > very complicated to handle all the marketplaces that you need in Odoo. > It is exactly like using a multi shipping provider. > > Lengow is only for big companies wich sells lot of products. > > We work with Iziflux, a french multi-channel feed (a «broker» as you > said, one can see it as a dispatcher). Price is really cheap compared to > Lengow and you can start with, for example, 100 products. There is a lot > of multi-channel feeders. Local feeders are recommended at there is also > a lot of local marketplaces. > > We have asked it-projects (Yelizariev's company) to code a connector > Odoo 13 - Iziflux. It works well and we would like to release it as GPL. > > However, a simpler module would be good enough for starting as nearly > all multi-channel feeds can handle CSV files. It would work as follow : > - check products to sell > - check require fields and transform format > And a cron job would > - CSV product and stock > - CSV stored in dedicated directory > - ftp your CSV to the multichannel feed (some multichannel feeds will > directly take it) > - ftp the multichannel CSV (sales) > - CSV sale import > Such a general module could be immediatly usable with every > multi-channel feed as soon as you will setup the fields and adapt > formats. > > If you need to search for multi channel providers, use these keywords : > multi-channel, feed, connector, flux > > --- > Librement, > Xavier Brochard xavier@alternatif.org > La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre > Rosnay) > > Le 15.04.2021 12:12, Alexandre Fayolle a écrit : >> I'm in contact with a german company who would like to interface Odoo >> with different marketplaces, such as amazon, ebay but also local german >> actors. I don't have yet a full list, and the list is likely to evolve >> over time anyway, so I would not like to use 1 connector backend per >> marketplace... >> I think the most cost effective approach would be to use a 3rd party >> broker which would take care of the nitty gritty details and present >> Odoo with a single, unified interface. I think lengow does this, and we >> have a connector_lengow project in the OCA repositories. >> I'm happy to hear some feedback (on the lengow connector, or on using a >> broker for this purpose), doubtless some of you already had to walk >> this >> path. > > _______________________________________________ > Mailing-List: https://odoo-community.org/groups/contributors-15 > <https://odoo-community.org/groups/contributors-15> > Post to: mailto:contributors@odoo-community.org > Unsubscribe: https://odoo-community.org/groups?unsubscribe > <https://odoo-community.org/groups?unsubscribe> > -- Alexandre Fayolle Senior Software Engineer Tel : +33 4 58 48 20 30 Camptocamp France SAS 18 rue du Lac Saint André 73 370 Le Bourget-du-Lac France http://www.camptocamp.com
by Alexandre Fayolle - 10:14 - 28 Apr 2021 -
Re: multichannel sales with different marketplaces
Hi Alexandre,I would personally go for a UBL standard XML file to import and export data to the third party provider, whatever it is. We used Lobster for example in one project.Then Odoo 'just' need to speak and understand UBL and most is already done in OCA/EDI repo.IMO it is, and should probably remain, that the customer have a hand on the third party app that communicate with Odoo and other tools. If we have one interface, fine we take the responsibility. If it starts to be many, and moreover moving target, then better the customer take this part.Strategically speaking, it's also important that the customer has its data and flows under control.Call me anytime,All the best,JoëlLe jeu. 15 avr. 2021 à 13:17, Xavier Brochard <xavier@alternatif.org> a écrit :Hello Using a multi-channel dispatcher is the best option, as it is allways very complicated to handle all the marketplaces that you need in Odoo. It is exactly like using a multi shipping provider. Lengow is only for big companies wich sells lot of products. We work with Iziflux, a french multi-channel feed (a «broker» as you said, one can see it as a dispatcher). Price is really cheap compared to Lengow and you can start with, for example, 100 products. There is a lot of multi-channel feeders. Local feeders are recommended at there is also a lot of local marketplaces. We have asked it-projects (Yelizariev's company) to code a connector Odoo 13 - Iziflux. It works well and we would like to release it as GPL. However, a simpler module would be good enough for starting as nearly all multi-channel feeds can handle CSV files. It would work as follow : - check products to sell - check require fields and transform format And a cron job would - CSV product and stock - CSV stored in dedicated directory - ftp your CSV to the multichannel feed (some multichannel feeds will directly take it) - ftp the multichannel CSV (sales) - CSV sale import Such a general module could be immediatly usable with every multi-channel feed as soon as you will setup the fields and adapt formats. If you need to search for multi channel providers, use these keywords : multi-channel, feed, connector, flux --- Librement, Xavier Brochard xavier@alternatif.org La liberté est à l'homme ce que les ailes sont à l'oiseau (Jean-Pierre Rosnay) Le 15.04.2021 12:12, Alexandre Fayolle a écrit : > I'm in contact with a german company who would like to interface Odoo > with different marketplaces, such as amazon, ebay but also local german > actors. I don't have yet a full list, and the list is likely to evolve > over time anyway, so I would not like to use 1 connector backend per > marketplace... > I think the most cost effective approach would be to use a 3rd party > broker which would take care of the nitty gritty details and present > Odoo with a single, unified interface. I think lengow does this, and we > have a connector_lengow project in the OCA repositories. > I'm happy to hear some feedback (on the lengow connector, or on using a > broker for this purpose), doubtless some of you already had to walk > this > path.
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Joël Grand Guillaume - 10:12 - 28 Apr 2021 -
Re: multichannel sales with different marketplaces
We're interested in this topic as well and maybe we run a project based on that soon. Lengow and Tradebyte are the main actors, maybe you want to take a look at both of them. What we've heard, based on the experience of our customers, is that they both provide great service but the cost is high, so it seems that the number of marketplaces involved has to be more than 5 or so.
The OCA Lengow connector is outdated, have in mind that maybe it's not working out of the box.
There's an opensource alternative Cenit.io [1] (and I think it was something related to our odoo world in their beginning), but we haven't tried.
But also, willing to hear more feedback.
[1] https://github.com/cenit-io/El jue, 15 abr 2021 a las 12:12, Alexandre Fayolle (<alexandre.fayolle@camptocamp.com>) escribió:Hello, I'm in contact with a german company who would like to interface Odoo with different marketplaces, such as amazon, ebay but also local german actors. I don't have yet a full list, and the list is likely to evolve over time anyway, so I would not like to use 1 connector backend per marketplace... I think the most cost effective approach would be to use a 3rd party broker which would take care of the nitty gritty details and present Odoo with a single, unified interface. I think lengow does this, and we have a connector_lengow project in the OCA repositories. I'm happy to hear some feedback (on the lengow connector, or on using a broker for this purpose), doubtless some of you already had to walk this path. Thanks -- Alexandre Fayolle Senior Software Engineer Tel : +33 4 58 48 20 30 Camptocamp France SAS 18 rue du Lac Saint André 73 370 Le Bourget-du-Lac France http://www.camptocamp.com_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Carlos Liébana Anero. - 01:15 - 15 Apr 2021
-
-
If I am not logged in, I cannot open a mail discussion
Hello,I am not sure if this is the right place to report...
If I am not logged in, I cannot open a mail discussion, I get a 403 error message.You can check with this link for instance:Regards,Jean-Charles
Jean-Charles Drubay Managing Director Mobile: +84 (0) 9 09 64 34 69 jc@komit-consulting.com | Skype: jc.drubay 204/34 Nguyen Van Huong, Thao Dien, D2, HCMC, Vietnam
https://komit-consulting.com
by Jean-Charles Drubay - 12:01 - 15 Apr 2021-
Re: If I am not logged in, I cannot open a mail discussion
I am seeing 403: Forbidden error message even if logged in:On a side note, I can't see the image in above email:On Thu, 15 Apr 2021 at 12:02, Jean-Charles Drubay <jc@komit-consulting.com> wrote:Hello,I am not sure if this is the right place to report...
If I am not logged in, I cannot open a mail discussion, I get a 403 error message.You can check with this link for instance:Regards,Jean-Charles
Jean-Charles Drubay Managing Director Mobile: +84 (0) 9 09 64 34 69 jc@komit-consulting.com | Skype: jc.drubay 204/34 Nguyen Van Huong, Thao Dien, D2, HCMC, Vietnam
https://komit-consulting.com _______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Simone Rubino - 12:41 - 15 Apr 2021 -
-
-
Changing quantities and adding products after confirmation of
Purchase orders
Hi all,I wonder how, in Odoo 12, handle correctly the change of received quantity and the add of new products, once purchase order has been confirmed.Here is my context :- Quantity billed are based on "Delivered Quantity".- purchase order can be quite big. (> 500 lines).- After a purchase is confirmed, people receiving goods have to change quantity many time with all the cases possibles :Case A) received qty > ordered qtyCase B) received qty < ordered qtyCase C) received qty = 0 (out of stock)Case D) new product received (no ordered).Typical Case
Ordered Qty Received Qty Product A - Corner Desk Right Sit 10 12 Product B - Storage Box 20 18 Product C - Cabinet with Doors 30 0 Product D - Pedal Bin 0 100 Draft Purchase OrderReceiving Stock PickingFor case A, B and C, i can change the received values on the stock picking : the received quantity on the purchase order will be correctly updated / computed.But if I add a new line (new stock.move), the line is not added on the purchase order, and so, the bill will not contain the correct value.Purchase order, (once the picking is confirmed)Desired purchase orderThe only solution I see for the time being is- for the case A, B, C : change values on the picking : OK.- for the case D, add a line on the purchase.order, and then, go to the picking, and then, set the correct received quantity.That is really not user friendly for end users, and so generates a lot of errors.- Do you know how to handle the 4 cases in the same screen ?- Do you know an (OCA) module that could add a purchase.order.line when adding an stock.move on a ready stock.picking ? (not sure it's the good design)thanks for your help.GRAP - Service informatique (Groupement Régional Alimentaire de Proximité)Site Web | FramaSphere | Facebook
3 Grande rue des Feuillants, 69001 Lyon
Standard : (+33) 09.72.32.33.17Service Informatique : (+33) 09.73.79.64.40Astreinte Informatique : (+33) 06.81.85.61.43Member of the OCA (Odoo Community Association)
by Sylvain LE GAL - 11:25 - 15 Apr 2021 -
Proposing Dorin Hongu as Romanian PSC member
Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro
by Mihai Fekete - 12:56 - 14 Apr 2021-
Re: Proposing Dorin Hongu as Romanian PSC member
Hi Stéphane,thanks for adding him.Cheers,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.roOn Wed, Apr 28, 2021 at 11:11 PM Stéphane Bidoul <stephane.bidoul@acsone.eu> wrote:Hi Mihai,I added Dorin in the Romania PSC. He should receive the invite by tomorrow.Best regards,-sbiOn Wed, Apr 14, 2021 at 12:57 PM Mihai-Adrian Fekete <feketemihai@nexterp.ro> wrote:Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro_______________________________________________
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
by Mihai Fekete - 07:25 - 29 Apr 2021 -
Re: Proposing Dorin Hongu as Romanian PSC member
Hi Mihai,I added Dorin in the Romania PSC. He should receive the invite by tomorrow.Best regards,-sbiOn Wed, Apr 14, 2021 at 12:57 PM Mihai-Adrian Fekete <feketemihai@nexterp.ro> wrote:Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Stéphane Bidoul - 10:11 - 28 Apr 2021 -
Re: Proposing Dorin Hongu as Romanian PSC member
Hi Pedro,thanks for the feedback, indeed since it is my suggestion he will get my +1.Cu respect,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.roOn Thu, Apr 15, 2021 at 1:22 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:The ones having the faculty according to PSC rules is that other PSC from that repo gives their approval, so I think you are the only one, and can have that power. I can only say as an external observer than +1 by my part.Let's see if Simone/Daniel/Stéphane can make the move at the OCA instance.Regards.El mié, 14 abr 2021 a las 12:57, Mihai-Adrian Fekete (<feketemihai@nexterp.ro>) escribió:Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro_______________________________________________
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
by Mihai Fekete - 12:26 - 15 Apr 2021 -
Re: Proposing Dorin Hongu as Romanian PSC member
The ones having the faculty according to PSC rules is that other PSC from that repo gives their approval, so I think you are the only one, and can have that power. I can only say as an external observer than +1 by my part.Let's see if Simone/Daniel/Stéphane can make the move at the OCA instance.Regards.El mié, 14 abr 2021 a las 12:57, Mihai-Adrian Fekete (<feketemihai@nexterp.ro>) escribió:Hello,i would like to propose Dorin Hongu as a Romanian PSC memberso that he can help us manage issues and pull requests.He is involved a lot in the project:https://github.com/OCA/l10n-romania/commits?author=dhonguThanksRegards,Mihai Fekete
NextERP Romania S.R.L.
600B, Peciu Nou, Romania
E-mail: feketemihai@nexterp.ro
Telefon: 0788-749989
Website: https://nexterp.ro_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Pedro M. Baeza - 12:21 - 15 Apr 2021
-
-
Performance of /shop controller
Hi all,in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.I profiled these requests with py-spy and noticed that execute function (odoo/sql_db.py) takes most of the time.Did anybody analyze these queries and have experience or modules to share?Thanks!
by Lorenzo Battistini. - 09:30 - 11 Apr 2021-
Re: Performance of /shop controller
It could be a lot of thingsI was realized that computing prices is heavy.But prefetching tables too as- website.user_id.partner_id.langMissing indexes and so on.There are fixes using LRU cache in newer versions but if you have detected that queries are slow you can try getting the postgresql log in order to analyze it--On Sun 11 Apr 2021 at 2:31 a.m. Lorenzo Battistini <elbaddy@gmail.com> wrote:Hi all,in our odoo 12 deployments we usually detect a time to first byte above 1.5 sec for /shop pages.We already cache \/web\/(static|image|content)\/ in nginx and installed website_js_below_the_fold, but odoo server is the bottleneck at the moment.I profiled these requests with py-spy and noticed that execute function (odoo/sql_db.py) takes most of the time.Did anybody analyze these queries and have experience or modules to share?Thanks!
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Moisés López CalderónMobile: (+521) 477-752-22-30Twitter: @moylop260Twitter: @vauxoo
by Moisés López Calderón - 09:41 - 11 Apr 2021
-
package in a package?
Hello community,with standard or OCA Odoo modules, is there the feature to put a stock.move.line in the destination package (like a small unit as parcel/package) and after several minutes to put the same stock.move.line in a bigger unit like a pallet without losing the information that the stock.move.line is both in the package and in the pallet?At use, it seems to me that, by default, a stock.move.line is only in a package at the same time, and not in a package (parcel) which is in a package (pallett).Maybe I missed something?Regards,Romain Deheele
by romain@avosdim.com - 11:11 - 6 Apr 2021-
Re: package in a package?
Hi Romain,In your case, it is recommended to do the packings in several operations.STOCK =PICKING> |PICK ZONE| =PACK> |PACK ZONE| =SHIP> |CUSTOMERS|So, during picking you can put your products in a pack, and in packing operation you can put your packs on a pallet.I hope this would help you.Regards,On Tue, Apr 6, 2021 at 11:12 AM Romain Deheele <romain@avosdim.com> wrote:Hello community,with standard or OCA Odoo modules, is there the feature to put a stock.move.line in the destination package (like a small unit as parcel/package) and after several minutes to put the same stock.move.line in a bigger unit like a pallet without losing the information that the stock.move.line is both in the package and in the pallet?At use, it seems to me that, by default, a stock.move.line is only in a package at the same time, and not in a package (parcel) which is in a package (pallett).Maybe I missed something?Regards,Romain Deheele_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--__________________________________________
Denis Roussel
Software Engineer
Acsone SA, Succursale de Liège (Val Benoît)
Tel : +32 2 888 31 49
Fax : +32 2 888 31 59
Gsm : +32 472 22 00 57Acsone sa/nv
Boulevard de la Woluwe 56 Woluwedal | B-1200 Brussels | BelgiumQuai Banning, 6 (Val Benoît) | B-4000 Liège | Belgium
Zone Industrielle 22 | L-8287 Kehlen | Luxembourg
by Denis Roussel - 11:31 - 6 Apr 2021
-
Login as Admin like in Odoo.SH
Hi community,Does anyone know how to have a button like in Odoo.SH:Is that possible to connect as a certain user? I get a session token then use it as a Header?Thanks!
by Diogo Duarte - 11:31 - 1 Apr 2021
