Create products from external database

  • andrespaez1

    (@andrespaez1)


    5 years, 5 months ago

    Hi there,

    We are trying to set up an e-commerce for our company and we decided to use woocommerce.

    We 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.

    What would be the best approach in order to achieve this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Riaan K.

    (@riaanknoetze)

    5 years, 5 months ago

    Hi there,

    WooCommerce needs the database of products to be in a format that it understands. Practically speaking, this means that you’d likely need to import those products through a CSV file into WordPress/WooCommerce. Without knowing the fields you’re looking to import, the most flexible approach would be to use a plugin like https://www.wpallimport.com/

    Thread Starter andrespaez1

    (@andrespaez1)

    5 years, 5 months ago

    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?

    Thanks in advance.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Create products from external database’ is closed to new replies.