Two sites on single WordPress and single database

Hi Mika,

Thanks for getting back to me. The “Create a Network” guide was what I followed to get to the stage I’m at, but it doesn’t mention anything about the databases.

The background to my request is this:

If I have a website, an online store that for example sells jackets, sweaters, trousers and shoes, I need a 2nd site that is identical but sells only the trousers and shoes, while the first site sells all categories. I’m using WooCommerce and the support guys there said a single installation of WooCommerce cannot filter different products to two different sites, therefore a multisite network with a subdomain site, and a separate installation of WooCommerce was recommended, with two databases. I’m getting confused because if I have two separate database does that not mean I need to duplicate everything on the sites?

I need as little duplication of work as possible, so the same admin accounts to be able to work on both sites, a single WordPress installation with the same plugins resulting in upgrades of WordPress and the plugins being done only once etc.

Have I done this correctly so far? I get confused when it comes to the database. I.e if it was two separate WordPress installations I would amend the wp-config.php file on the 2nd site to give a different prefix to the table entries on the same single database. But I haven’t seen anywhere what I need to do for the database entries for two sites running on a single WordPress installation with a single database.

I hope I’ve made sense here.

Thanks