Using External Database to Update WooCommerce Store

  • Resolved cmagras

    (@cmagras)


    4 years, 8 months ago

    Hi,

    I have an inventory database, which has a rest API available. I want the information in this database to update my WooCommerce store (at least twice a day) – specifically to keep things like product quantity up-to-date and synced.

    Everything I’ve read so far is about WooCommerce sending info over to external databases – not the other way around.

    In other words, I want product inventory to be controlled by an external database that then pushes/updates WooCommerce a couple of times a day.

    Can someone help me understand the steps needed to set this up? I know I have rest API’s on both sides (with the external database AND with woocommerce), but I’m not sure what to do with them.

    Thank you,
    Carissa

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mirko P.

    (@rainfallnixfig)

    4 years, 8 months ago

    Hi @cmagras,

    That’s an interesting setup! But there’s not a way to do what you are wanting to do with WooCommerce core by default. This would definitely require some customization. You could build an intermediary app, pull your data from the external database and push it to WooCommerce with REST API and JSON.

    This forum is intended to support the default functionality of WooCommerce though, so there aren’t as many developers on here as other options.

    For this type of questions, you’re more likely to get input by asking in the WooCommerce Developer Slack or Advanced WooCommerce Facebook group. As those communities are both frequented by developers.

    Alternatively, you can consult with a developer or customization expert who can help you create a custom solution:

    https://woocommerce.com/customizations/

    Have a good day!

    Thread Starter cmagras

    (@cmagras)

    4 years, 8 months ago

    Thank you so much, Mirko! That is very helpful. I will check out the resources you recommended and see what I can find out there. 🙂

    Thanks!
    Carissa

    Mirko P.

    (@rainfallnixfig)

    4 years, 8 months ago

    Hello Carissa,

    Great! My pleasure!

    I’m going to mark this thread as solved now. If you have more questions feel free to open a new topic at any time.

    Have a good day!

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

The topic ‘Using External Database to Update WooCommerce Store’ is closed to new replies.