Archives
Contributors
-
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 -
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 -
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: New module for data synchronization between Odoo instances
Dear DanielI would be interested with your work about data sync between instancesWe have a use case here with a pos on a boat without internet access when at sea...We are considering synchro at db level with bucardo...Feedback is welcomeBest RegardsLe ven. 19 mars 2021 à 02:16, Daniel Reis <dreis@opensourceintegrators.com> a écrit :Hello,
I'm working on a module to synchronize data between Odoo instances.
It will support one master with many slave databases, and allow for bidirectional sync.
My design builds on top of, and expands, the great auditlog module (https://github.com/OCA/server-tools/tree/14.0/auditlog)
I'm considering my options on:
a) the repo to contribute the module to, and
b) the name for the module.
Suggestions are welcome.
Thank you
--
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 Cyril VINH-TUNG - 10:13 - 28 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: 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: 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: 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 -
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 -
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 -
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 -
-
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 -
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 CaseOrdered 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
