Database Connectivity - Using a different server

[DrByte]

Your first post left me with the impression that all the stores would have all the same products in them.

What you're talking about, while possible, is very complicated and prone to problems if not done well.
To do that is going to require a notable investment of time and custom coding.
And future upgrades will be ... well ... complex.

I really hope there's a lot more than just 5 products, else the amount of effort required isn't worth it.

Nevertheless, yes, it's possible. I wish you well !

[ecomuser2010]

Apologies for being a bit confusing, it's not easy to explain.

The first store attached to the 'master' one is goin to have the exact same products. After that each other store (selling different items) would have to have their items added to the mater one.

However, given the point about performance issues, this probably isnt a great solution, maybe it'd work well for 1 store if it was sat on the same server but otherwise like you said, it'd run slowly.

Anyway, thank you for your input, there wasn't too much online to research with :)