Sync products from MS Dynamics NAV 5.0 to Magento

I wrote some SQL-scripts in PHP years ago which pulls products from Microsoft Dynamics NAV 5.0 and inserts them into the Magento 1.9 database using ODBC-driver.

It's a one-way sync which kinda works.

Basically what we want now is a script:

- that will create the product if it doesn't exist in Magento

- it should be imported as a Grouped Product if there is multiple products with same name in a certain MS Dynamics field.

- if the product already exist in Magento the fields should be updated

(description, stock, price, etc)

- some lines in a Dynamics-table should be merged into the Description-field of the product in Magento

- The enabled/disabled state of the products should be updated

- probably also some other info that should be updated

Alternatively it might be better to use Magento's API?

I'm open for suggestions and comments.

ERP: MS Dynamics NAV 5.0
eCommerce: Magento CE 1.9
Windows Environment

Back in 2010 I made some SQL/PHP-scripts which sync products one-way from Dynamics NAV to Magento. They kinda work but the implementation needs to be rewritten to increase stability and purpose.

The new sync should be able to:
1: Create product in Magento if a field in NAV is checked
2: Disable existing product in Magnento if same field is unchecked
3: Create grouped product in Magento if a field of 2+ products in NAV have the same name
4: Update Description in Magento by joining multiple rows from a NAV table. (NAV 5.0 has limit of 50 characters pr row)
5: Sync stock and price from NAV about every 30 minutes.
6: Mark product in Magento as "NEW" if a field in NAV is checked.
7: Mark produkt in Magento as "In Stock" if stock in NAV >= sold_by_count
... Probably also a few more cases will emerge as we test the sync.

The sync may be constructed using SQL, API or a mix. I'm open for all comments and suggestions :-)

Skills: Magento, MySQL, PHP

See more: sql create table price, microsoft dynamics nav magento, set sync magento dynamics crm online api, sync magento dynamics, magento import categories products, magento best selling products, magento show latest products site, magento cart lots products, magento save exported products, page nav magento, magento menu vertical products

About the Employer:
( 6 reviews ) Skallestad, Norway

Project ID: #8500398

5 freelancers are bidding on average $477 for this job


Hi, We are interested in doing this project. We would like to hold a detailed discussion with you in order to have a more clear understanding of your requirements. As of now, I have placed a PLACEHOLDER BID. = More

$78 USD in 3 days
(215 Reviews)

Hi, I am managing a professional web agency for more than 8 years. You can check my Themeforest profile with ratings here: [login to view URL], as well as the marketplace I build recently for prom More

$2051 USD in 9 days
(44 Reviews)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$105 USD in 3 days
(121 Reviews)

Project Requirements: - Sync products from MS Dynamics NAV 5.0 to Magento Skills and experience: - I've built and managed Magento installations for some of the world’s most recognizable brands. - Specialist in More

$6666 USD in 30 days
(21 Reviews)

Hii, Thanks for your project post. We are a reputed organization with the team of 40+ developers having core expertise in Web design and Mobile development. We believe that we would best suits to your requiremen More

$74 USD in 1 day
(16 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More

$54 USD in 3 days
(1 Review)

Hello, woo pro here I go get your stuff done for you professionally. Please visit our work: [login to view URL] [login to view URL] [login to view URL] [login to view URL] looking forward to more details, let things roll now. Ang More

$75 USD in 1 day
(0 Reviews)