Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Download Sale Orders from Magento 2.3 to Odoo14

Archives

Contributors

Proforma invoices in Odoo

suggestion for monitoring error 500

Download Sale Orders from Magento 2.3 to Odoo14

Hello everyone,

 

we are integrating Odoo14 in our main company business and we need to cover an important need, but we don’t know yet if we should develope our custom solution or use a 3rd party connector.

It would be really helpful to have your opinion in relation of our needs, if possible, or more simply about Odoo-Magento connectors in general.

 

We cooperates in dropshipping with a company that use Magento 2.3 (and will possibly switch to Magento 2.4) and we are managing for him the stock and part of delivery workflow.

 

We don’t need a full syncro, because our ‘dropshipping partner’ only sells product that we already have in stock.

This means that we only have to sync

 

  • orders
  • possibly new customers, but we don’t manage invoice data so we don’t need much data for the customer sync, just a generic reference

 

With this premise, we were think that using a connector is not necessary but we would like to have an opinion from experienced people that know Odoo better than us.

 

The workflow we are using right now with another ERP and we are going to re-create in Odoo is pretty raw, but it works well:

 

  • we receive an XML with orders,
  • we read XML,
  • we create orders in Odoo,
  • we process orders internally,
  • we send, at the end of the day, a csv file with our stock quantity (for all products) back to the ‘dropshipping partner’ so he can update his product availability on Magento website

 

Also, in Odoo we are going to make some little improvements here and there to make orders easier and fast to manage once they have been processed, so we would need to make a few implementations even if we buy/use a 3rd party module.

 

From my perspective it’s not worth to get a connector to achieve this specific tasks unless is a very good one, meaning that:

 

  • Well supported by community (if it’s free, but i did not find one) or have very good and responsive assistance service
  • it will work without spending much additional time on it,  expecially because it will probably add hundreds (if not thousands) of code line that we are not fully going to take advantage of,

so it might just be better to spend time on develope our small but specific solution, if that’s the case

 

Thanks in advance and regards,

 

Francesco B.

 

 

 

 

 


Privo di virus.www.avast.com
by Francesco Ballerini - 07:26 - 29 Apr 2023

Follow-Ups

  • Re: Download Sale Orders from Magento 2.3 to Odoo14
    Simone, thank you for sharing your POV, I see that we are more or less aligned on the point of making our own solution, it's useful to have enforcements/confirmation about this topic from different people, I appreciated the hint about EDI, I will take a loot at it : )

    Oleg Kuryan

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 

    I disagree with this. At least on the message that carries... but we might have just a "translation" problem, so please take this as a way to help improving this conversation  ;)
    We have plenty of people - me included - that fix bugs for free or that help (w/ reviews, tests, comments, etc).
    Moreover the "fix and contribute yourself" does not mean that you shouldn't do it in the OCA. (at least partially) ;)
    And yeah, that might not be so "common" but I think it comes most of the time from "fear", "shyness" or the feeling that you've just expressed here ;)

    About this point, I think I got both point from Oleg and Simone ; ) We probably all agree that when people work for the money in the context of a company that is supposed to provide a service, it's almost automatic that they will be (or at least do their best to be) as responsive and efficient as they can. 

    BUT that doesn't exclude the fact that sometimes community can be even more responsive and efficient, but you might have to deal with a lot of variables. 

    I think the fact Oleg wants to point out is that when you rely on community you "have to be lucky", while if you rely on a professional company you can litterally claim to have the assistance you need. On the other hand this still doesn't always mean that official assistance is always better than the community service, I think we're just talking about two very different approach that somehow lead in the same way and they have both pro and cons. Very interesting point to discuss : )

    Sorry for the late answer, I was not in Milan unfortunately, I hope I can go to Odoo days next year !

    Privo di virus.www.avast.com

    Il giorno mer 3 mag 2023 alle ore 16:42 Simone Orsi <notifications@odoo-community.org> ha scritto:
    Ciao Francesco,

    Here's my POV:

    1. your scope sounds too small to use connector-magento (that should be migrated, etc) or any other "existing" connector
    2. this does not mean that you cannot create a connector. The connector module proposes a pattern to handle inbound/outbound sync. That's it. I won't exclude this idea a priori.
    3. you mention "receiving and processing XML files and sending out some other files": sounds more like an EDI exchange than a connector -> I encourage you to have a look at the EDI framework.

    I'm going to the Odoo Italia days in Milan: if you come, we can have a chat ;)

    Finally, a few words for Oleg regarding

    Oleg Kuryan

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 

    I disagree with this. At least on the message that carries... but we might have just a "translation" problem, so please take this as a way to help improving this conversation  ;)
    We have plenty of people - me included - that fix bugs for free or that help (w/ reviews, tests, comments, etc).
    Moreover the "fix and contribute yourself" does not mean that you shouldn't do it in the OCA. (at least partially) ;)
    And yeah, that might not be so "common" but I think it comes most of the time from "fear", "shyness" or the feeling that you've just expressed here ;)
     
    So yes, in your case it is better to develop your own script that you will understand yourself and will support it yourself 
    I know this 100% as we are developing Connectors to e-commerce systems and we know how much time it takes to support them, constantly develop, fix bugs, respond in reasonable time.
    I see your point but there's always the other side of the medal: go always fully this way and you'll always be by yourself. Fully. Forever :)

    My $0.02.

    Bests

    --
    Simone Orsi

    Full stack Python web developer, Odoo specialist, Odoo Community Board Member, in love with open source.

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

    by Francesco Ballerini - 06:30 - 7 May 2023
  • Re: Download Sale Orders from Magento 2.3 to Odoo14
    Ciao Francesco,

    Here's my POV:

    1. your scope sounds too small to use connector-magento (that should be migrated, etc) or any other "existing" connector
    2. this does not mean that you cannot create a connector. The connector module proposes a pattern to handle inbound/outbound sync. That's it. I won't exclude this idea a priori.
    3. you mention "receiving and processing XML files and sending out some other files": sounds more like an EDI exchange than a connector -> I encourage you to have a look at the EDI framework.

    I'm going to the Odoo Italia days in Milan: if you come, we can have a chat ;)

    Finally, a few words for Oleg regarding

    Oleg Kuryan

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 

    I disagree with this. At least on the message that carries... but we might have just a "translation" problem, so please take this as a way to help improving this conversation  ;)
    We have plenty of people - me included - that fix bugs for free or that help (w/ reviews, tests, comments, etc).
    Moreover the "fix and contribute yourself" does not mean that you shouldn't do it in the OCA. (at least partially) ;)
    And yeah, that might not be so "common" but I think it comes most of the time from "fear", "shyness" or the feeling that you've just expressed here ;)
     
    So yes, in your case it is better to develop your own script that you will understand yourself and will support it yourself 
    I know this 100% as we are developing Connectors to e-commerce systems and we know how much time it takes to support them, constantly develop, fix bugs, respond in reasonable time.
    I see your point but there's always the other side of the medal: go always fully this way and you'll always be by yourself. Fully. Forever :)

    My $0.02.

    Bests

    --
    Simone Orsi

    Full stack Python web developer, Odoo specialist, Odoo Community Board Member, in love with open source.
    by Simone Orsi - 04:40 - 3 May 2023
  • Re: Download Sale Orders from Magento 2.3 to Odoo14
    Francesco,

    Yes, demo is on Enterprise but our connectors of course working on Community Edition. 

    About library to use. Magento has simple rest api. So we investigated available libs. But as result created our own simple one class wrapper. It is very easy. Just we didn’t want to be limited with some library. We faced this with some other libraries for other e-commerce systems because as result we had not only develop our own connector, but also make fixes to library.


    On Sun, 30 Apr 2023 at 19:36, Francesco Ballerini <notifications@odoo-community.org> wrote:


    Romualdo Briosos Jrsab 29 apr, 20:12 (22 ore fa)
    In your situation, I would recommend developing a Python program that can connect to both the Magento API and Odoo API. This would give you greater control over

     

    Oleg Kuryan

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 
    So yes, in your case it is better to develop your own script that you will understand yourself and will support it yourself 
    I know this 100% as we are developing Connectors to e-commerce systems and we know how much time it takes to support them, constantly develop, fix bugs, respond in reasonable time. 

    Thanks for your feedbacks, it really helps in the decision process! 

    It is very likely that we will proceed this way:

    1) we will make a temporary implementation of the old workflow as I described in the first message for 2 reasons
       - it's more "cluncky" but it's (at least for me) faster to develope and requires less code updates in the future
       - this would also allow us to have a low-level fallback import system, which we can use if "something breaks" after an update 

    2) one day not too far, is very likely that we will implement our own API as you both suggested. About this I'd like to ask if you have specific libraries to recommend, I see there are different libraries and I think this one might be a good point to start https://pypi.org/project/magento/, but I'm not sure about version compatibility. 
    It would be great to know your recommendations about libraries, if you'd like to share any.

    Thanks for the video suggestion Oleg, I have almost finished it, I see the connector Demo is on Odoo Enterprise but VentorTech solutions can also be found for Odoo Community is it correct?

    Thanks,
    Francesco B.


    Privo di virus.www.avast.com

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

    --
    ///

    Best Regards,
    Oleg Kuryan

    CEO & COO, VentorTech OÜ |     Building Personalized Inventory and Product Management Systems

    | ph PL: +48 573 992 456
    | skype: kuryan.oleg
    by "Oleg Kuryan" <oleg@ventor.tech> - 08:16 - 1 May 2023
  • Re: Download Sale Orders from Magento 2.3 to Odoo14


    Romualdo Briosos Jrsab 29 apr, 20:12 (22 ore fa)
    In your situation, I would recommend developing a Python program that can connect to both the Magento API and Odoo API. This would give you greater control over

     

    Oleg Kuryan

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 
    So yes, in your case it is better to develop your own script that you will understand yourself and will support it yourself 
    I know this 100% as we are developing Connectors to e-commerce systems and we know how much time it takes to support them, constantly develop, fix bugs, respond in reasonable time. 

    Thanks for your feedbacks, it really helps in the decision process! 

    It is very likely that we will proceed this way:

    1) we will make a temporary implementation of the old workflow as I described in the first message for 2 reasons
       - it's more "cluncky" but it's (at least for me) faster to develope and requires less code updates in the future
       - this would also allow us to have a low-level fallback import system, which we can use if "something breaks" after an update 

    2) one day not too far, is very likely that we will implement our own API as you both suggested. About this I'd like to ask if you have specific libraries to recommend, I see there are different libraries and I think this one might be a good point to start https://pypi.org/project/magento/, but I'm not sure about version compatibility. 
    It would be great to know your recommendations about libraries, if you'd like to share any.

    Thanks for the video suggestion Oleg, I have almost finished it, I see the connector Demo is on Odoo Enterprise but VentorTech solutions can also be found for Odoo Community is it correct?

    Thanks,
    Francesco B.


    Privo di virus.www.avast.com
    by Francesco Ballerini - 07:35 - 30 Apr 2023
  • Re: Download Sale Orders from Magento 2.3 to Odoo14
    Hello Francesco,

    In community you will never find good and well supported connector. This is community, nobody will respond to you for free for bugfixing. You need to fix and contribute yourself. It is very rare case that people will fix your reported bugs. And it is more based on enthusiasm of individual person in case he has free time / desire / good mood :) 

    So yes, in your case it is better to develop your own script that you will understand yourself and will support it yourself 

    I know this 100% as we are developing Connectors to e-commerce systems and we know how much time it takes to support them, constantly develop, fix bugs, respond in reasonable time. 

    On my presentation on last Odoo conference I was comparing connectors to e-commerce. Look at this presentation just for high level overview of connectors in Odoo world (this are first 5 mins or so 

    On Sat, 29 Apr 2023 at 20:12, Romualdo Briosos Jr <notifications@odoo-community.org> wrote:
    In your situation, I would recommend developing a Python program that can connect to both the Magento API and Odoo API. This would give you greater control over the program's behavior and functionality.

    On Sat, Apr 29, 2023 at 9:27 PM Francesco Ballerini <notifications@odoo-community.org> wrote:

    Hello everyone,

     

    we are integrating Odoo14 in our main company business and we need to cover an important need, but we don’t know yet if we should develope our custom solution or use a 3rd party connector.

    It would be really helpful to have your opinion in relation of our needs, if possible, or more simply about Odoo-Magento connectors in general.

     

    We cooperates in dropshipping with a company that use Magento 2.3 (and will possibly switch to Magento 2.4) and we are managing for him the stock and part of delivery workflow.

     

    We don’t need a full syncro, because our ‘dropshipping partner’ only sells product that we already have in stock.

    This means that we only have to sync

     

    • orders
    • possibly new customers, but we don’t manage invoice data so we don’t need much data for the customer sync, just a generic reference

     

    With this premise, we were think that using a connector is not necessary but we would like to have an opinion from experienced people that know Odoo better than us.

     

    The workflow we are using right now with another ERP and we are going to re-create in Odoo is pretty raw, but it works well:

     

    • we receive an XML with orders,
    • we read XML,
    • we create orders in Odoo,
    • we process orders internally,
    • we send, at the end of the day, a csv file with our stock quantity (for all products) back to the ‘dropshipping partner’ so he can update his product availability on Magento website

     

    Also, in Odoo we are going to make some little improvements here and there to make orders easier and fast to manage once they have been processed, so we would need to make a few implementations even if we buy/use a 3rd party module.

     

    From my perspective it’s not worth to get a connector to achieve this specific tasks unless is a very good one, meaning that:

     

    • Well supported by community (if it’s free, but i did not find one) or have very good and responsive assistance service
    • it will work without spending much additional time on it,  expecially because it will probably add hundreds (if not thousands) of code line that we are not fully going to take advantage of,

    so it might just be better to spend time on develope our small but specific solution, if that’s the case

     

    Thanks in advance and regards,

     

    Francesco B.

     

     

     

     

     


    Privo di virus.www.avast.com

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



    --
    Sincerely,

    Romualdo Briosos Jr - Computer Engineer.
    Al Milad - Rocmet Corporation Group

    Corporate Headquarters
    Office Number: +971-4-553-1045
    Address: Unit 1809, Lake Central Fakhruddin Properties, Business Bay, Dubai- U.A.E.

    Warehouse
    Office Number: +971-6-5345587
    Address: Yard No. 14 - Street No. 18 -Industrial Area 11 P.O BOX 21034, Sharjah, UAE

     
      

    DISCLAIMER:

    This email and any files transmitted with it may be confidential and contain privileged or copyright information. If you are not the intended recipient you must not copy, distribute or use this email or the information contained in it for any purpose other than to notify us of the receipt thereof, if you have received this message in error, please notify the sender immediately, and delete this email from your system. Please note that e-mails are susceptible to change, the sender shall not be liable for the improper or incomplete transmission of the information contained in this communication, nor for any delay in its receipt or damage to your system. The sender does not guarantee that this material is free from viruses or any other defects although due care has been taken to minimize the risk.

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

    --
    ///

    Best Regards,
    Oleg Kuryan

    CEO & COO, VentorTech OÜ |     Building Personalized Inventory and Product Management Systems

    | ph PL: +48 573 992 456
    | skype: kuryan.oleg
    by "Oleg Kuryan" <oleg@ventor.tech> - 07:41 - 30 Apr 2023