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