Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Best way to add/update products from external databases?

‎09-14-2016 02:08 PM
‎09-14-2016 02:08 PM

Best way to add/update products from external databases?

I have two external mysql databases with a different table structure for products. Those database each belongs to an online shop.

 

What I would like to do is to somehow insert into the magento database all the products from those two external database and regularly like every few hours check if the prices and the stock of the products from the external databases changed. If it's the case, then the stock and the price for those products would update in the magento's database too.

 

So basically I wanna link those two external databases to the magento database. Have all products in magento database and when the stock or the price change in one of the external database to update it in the magento database too.

 

I only have an idea by creating an observer function and a cron job but I have no knowledge how to do this, neither of them.

 

Could someone help me out  ? I am really stuck with this issue.

Labels:
0 Kudos
1 REPLY 1
‎09-22-2016 07:36 AM
‎09-22-2016 07:36 AM

Re: Best way to add/update products from external databases?

Due to database structure differences that might be a problem.

 

First thing that should be clarified, can you export data from this external database into the file?

 

 

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.
0 Kudos