Hi there,
I want to be able to create the products in woocommerce by getting the information of the products (title, price, stock, description) from our database wich we use to do some other stuff inside our organization. We have more than 8000 products (simple, not variable) and that is the reason why we would like to create the products using the information that is already in the database. We use Microsoft SQL Server for our database.
We want to sync data, so if something changes on our Microsoft database it updates products on our WordPress one and vice versa. Since our database is connected to an app, that we use to update the stock of products, It would be great if the woocommerce database is updated whenever there is an new item or change of stock in the database.
Yesterday I was able to create a product and retrieve a product using the Woocommerce API (no connection to my DB). Next step I guess would be developing an ETL process so we can get the information of the products from my database, transform it so woocommerce API can understand the data and then uploading that to woocommerce through the API.
Do you now any other way to accomplish this?
There is a problem with this approach: It would not be an automatic process. So, there would not be a continuos syncing.
Is there a way to automate this process?