Any help is appreciated!

 

Thanks!

P

 

The main problem with this scenario really comes down to the fact that ProductCart is simply not designed for the "multi-store-single-DB' set up.  I do know there are platforms out there that are designed for this function but they are also very, very expensive and you are typically paying quite up front for the license or or you end up shelling it out on a month-to-month basis.  

 

Aside from the licensing aspect that Hamish pointed out, in order for productcart to be able to handle multiple stores would be a monumental design effort in my view both on the coding and Database side of things.  This would require the ability to segregate billing, multiple merchant accounts, and multiple shipping accounts to name just a few.

 

We have been able to achieve something that is about 50% to what you are looking for by linking inventory and pricing between multiple PC stores (separate DB's) but not multiple stores on a single DB.  Even linking the inventory is pretty tricky as the product numbers and SKU's must be identical between both stores and since PC assigns the product numbers internally ....  like I said very tricky!

 

Sorry to sound like a kill-joy here but I think the best option would be to set up multiple stores separately.  Many of our customers are doing this now and it works well for them.  It also allows them to cross link sites and come up with different looks for each site.

 

It may still be possible to link products and inventory (if you track that internally) so you can update products in one master store and push those changes to the other databases (recall above where I said that is pretty tricky as product numbers and SKU's need to be identical).

 

Just a few extra thoughts for what it is worth.