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 :-)

Compétences : Magento, MySQL, PHP

en voir plus : 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

Concernant l'employeur :
( 6 commentaires ) Skallestad, Norway

Nº du projet : #8500398

5 freelance font une offre moyenne de $477 pour ce travail


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. = Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(215 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 9 jours
(44 Commentaires)

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 !! Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(121 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(21 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)