WordPress.org

Ready to get started?Download WordPress

Forums

WooCommerce - excelling eCommerce
Merging a database with WooCommerce, it's possible? (6 posts)

  1. adminad
    Member
    Posted 1 year ago #

    Hello,

    I want to know if you can merge a custom database to the one on WooCommerce. I have a physical shop with a database and I have limited product, so if I sell products physically I would like to substract it on WooCommerce automatically.

    It is possible to do that?

    Thank you,
    Regards!

    http://wordpress.org/extend/plugins/woocommerce/

  2. bheadrick
    Member
    Posted 1 year ago #

    I've migrated data from other shops into woocommerce before, and it's not that hard, but what you really want to do is export that data into a csv, and then use a decent csv import plugin to import the data.

    I use a free CSV Import plugin for importing products to woocommerce, and it works pretty well. It's not made specifically for woocommerce, so there are a few hoops to jump through, but it's not that difficult.

    Here's a template to use

  3. bheadrick
    Member
    Posted 1 year ago #

    there are still some manual steps needed to get attributes set up properly... Maybe that'll be my next feature.

  4. bheadrick
    Member
    Posted 1 year ago #

  5. adminad
    Member
    Posted 1 year ago #

    Thanks bheadrick for answering, but what I really want to know is if it's possible to merge two database (the one of my physical shop and woocommerce) and if a customer buys 5 candies on my physical shop and I have 100 in total, I would like to be updated automatically both database at the same time, so in WooCommerce and in my shop it would remain 95 candies.

    Thank you,
    regards!

  6. bheadrick
    Member
    Posted 1 year ago #

    You can't merge the databases per se, but you could add a function to the add_to_cart action which does an ajax call to your physical shop db to check whether the inventory count for each item being sold matches. (you'd want the ajax handler to have read/write access to your physical shop db so it could update the count there)

    so, merge? no synchronize? yes

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic