Two stores on the same database.

[ricardino]

hi all, bit of a convoluted question here, but ill see if i can make it come across correctly. We have a client with two established brand names, and hes wanting e commerce solutions for both addresses, each with a unique look. However, the actual stock being sold is identical for both stores. Basically i was wondering wether its possible for both stores to get there stock details from the database records so when the database is updated, changes show up on both stores? any help would be appreciated.

thanks.

[kuroi]

Yes, you can do this. The way to do it would be to set both stores up in a single database with difference database prefixes. You can then hardcode the database prefix in the includes/database_tables.php file for one of the stores to point to the other store's product tables. I would strongly recommend though, spending some time looking at the various product tables and understanding how they fit together with each other and with the categories tables, and in partular how the products_to_categories table works.