HI,

Here's what I'd like to do... I'd like to synchronize my inventory between my ecommerce and my physical store.

I have set up my ecommerce with concrete5 by buying the core commerce module.
Now
I want to start using unicenta POS system to manage my physical inventory, my billing, etc... In order to replace the good old cash register...

Unicenta can be configured to work with MySQL.

Is there a way to have concrete5 core commerce get its product data from unicenta's DB?
Or
Is there a way to synchronize both DB so that they "mirror" each other.

For instance, if I sell online, the quantity of available products should decrement... And If a sale is made in the physical store, The quantity should decrement in the online store as well... And so on, when I add new products, new product should be added to both DB (or one central DB???) and, in a perfect world, become available for sale, both online and in the physical store...

Does this makes any sense, or am I day dreaming here?

ANY help is greatly appreciated!!!

thanks

Pat