web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / MS Dynamics NAV & ...
Microsoft Dynamics NAV (Archived)

MS Dynamics NAV & PHP Magento

(0) ShareShare
ReportReport
Posted on by Craig Cleaver 160

Hello All,

First time post and it's more of an informagtion gathering process where hopefully someone can help me.

I have a client who is going through the integration process of NAV which won't be ready until Dec 2010. I have been commissioned to develop their new website, which I will be using Magento. There is a plugin out there which acts as a web-connector by SilverSolutions, and I wanted to know if anyone has had any experience in using this?

Or a more open ended question is, are there any pitfalls with NAV and PHP integration?

The site will be running full ecommerce and I obviously want to integrate NAV into the system to make life easier for the client and the customer, but NAV isn't due to be completed until late into the year and the site needs to be launched earlier. Is there anything I can read, anyone I should speak to to help me get this moving?

I appreciate this is quite an open request but I would like to know your response.

Thanks in advance,

Craig

*This post is locked for comments

I have the same question (0)
  • DigiTecKid Profile Picture
    DigiTecKid 56 on at
    Re: MS Dynamics NAV & PHP Magento

    Milos,

    I tried to respond to your message here but it didn't post anything.  I did respond to your private message though.  I sent you a big chunck of code on connecting to a MySQL database using NAV and ADO.  Unfortunately nothing directly on integration with Magento.

  • Milos Rajcevic Profile Picture
    Milos Rajcevic 20 on at
    Re: MS Dynamics NAV & PHP Magento

    Hey guys,

    I know it's a bit old topic, but let's make it live again.

    I'm kinda struggling these days also to find a solution for integration between NAV and Magento. Did you have any luck with it?

    I found few commercial solutions, but I am more interested in noncommercial one.  Do you have something to recommend maybe?

    Thanks in advance,

    Milos

  • Jeffery Profile Picture
    Jeffery 75 on at
    Re: MS Dynamics NAV & PHP Magento

    DigiTecKid,

    I replied to your PM.

    I have been working with NAV integration for the last couple of months. All my implementations have been using NAV Pages, but will be working with CodeUnits soon.

    Since my Application environment was dependant on being run on a linux environment, I didn't have the luxury of using VS2008/C# for the implementation.

    Overall, I have been successful in placing Orders into NAV via the SalesOrder Page exposed as Webservice and also able to retrieve data via through ReadMultiple calls for the Page Webservices.

  • DigiTecKid Profile Picture
    DigiTecKid 56 on at
    Re: MS Dynamics NAV & PHP Magento

    Hey Jeffery,

    I ended up having to do the same thing, build my own integration.  I tried to use a PHP add-on for the e-commerce site I'm working with (Interspire Shopping Cart) but couldn't get PHP to connect to the NAV web service (codeunit with an XLMport as a parameter).  We are now researching using an FTP process to transfer XML files back and forth to send the data (orders, item updates, shipments, etc...).

    When the customer started asking for testing functionality I ended up creating a lot of it myself.  Most of it I did in VS2008 C# using the MySQL .NET Connector.  I also have some functions in a codeunit in NAV that uses MySQL ODBC...
     
    ConnectionString := 'DRIVER={MySQL ODBC 5.1 Driver};' +
                                         'SERVER=01.01.01.01;' +
                                         'UID=dude;' +
                                         'PASSWORD=wheresmycar;' +
                                         'DATABASE=webstore_shopping_cart;' +
                                         'OPTION=3';

    ADOConnection.Open(ConnectionString);

    Since I'm using NAV 2009 R2 and I can define variables as installed .NET components, I'm considering changing the functionality over to use the MySQL .NET Connector just like I do in VS2008 C# app I built.

    What have you used and found effective?

     

    p.s. I posted this reply 10 times in as many ways as i could find.  it wasn't until I posted  a short one line reply, then went back and edited that reply that I got it to post my complete reply...

  • Jeffery Profile Picture
    Jeffery 75 on at
    Re: MS Dynamics NAV & PHP Magento

    Hi Craig/DigiTecKid,

    I am afraid you won't find many answers over here with relation to PHP-NAV integration.

    Craig, I don't have experience working with magento but have been working on integrating with NAV via a PHP Application. It is a library I have written from scratch and it has been a real painful experience developing it, as I am so not used to developing for Microsoft solutions.

    If you need any assistance in the integration, I am happy to answer them... but I am not expert as I have just scratched the surface.

    Jeffery

  • DigiTecKid Profile Picture
    DigiTecKid 56 on at
    Re: MS Dynamics NAV & PHP Magento

    Hey Craig,  Did you have good luck with the NAV and PHP ecommerce site integration?  I'm working towards the same thing.  How did you finally go about it?

  • Nilesh Shelar Profile Picture
    Nilesh Shelar 2,130 on at
    Re: MS Dynamics NAV & PHP Magento

    Hi Craig,

    There are many ways you can integrate website data to NAV.

    First thing which NAV version you are using?

    If you are using NAV 5.1 and downward then you can take help of SQL procedure and push data into NAV in temp table. In NAV you can process same data and create customer, sales order , sales quote and etc.

    If you are using NAV 6/2009 then you can use Web service and process data. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans