6 Sites, 1 Database

Hi Guys,

Haven’t been on the support forums for a long time now.

Just did some updates on a network of sites I built using WP (basically just to see if I could). Worked out pretty good I think. I never asked anyone here what they thought so some feedback would be great.

http://www.region4.com.au
http://www.region4.co.nz
http://www.primera.com.au
http://www.primera.co.nz
http://www.evocept.com.au
http://www.evocept.co.nz

The Codex and Support Forums here were invaluable to creating these sites. No doubt in my mind that without them, I would not have been able to achieve this outcome.

All 6 sites run from the one database, share the same posts, pages, etc… tables in the database. The only exception being that each has their own options table.

I did this because I needed some products to be across 4 websites, and didn’t want to have to them 4 times. Pretty neat. Using different themes I’ve got WP to spit out different information depending on what site you’re too.

So if you’re on a New Zealand site it spits out the NZ dollar, and Austrlian sites spit out the Australian dollar etc..

The biggest challenge was trying to exclude some product ranges from appearing on some of the websites. For example, primera.com.au is only for Primera range products, so I couldn’t have, for example, the ‘Mini Cubis’ in the Datatronics rnage showing up in searches, or if you typed in its post number as all sites shared the same tables.

Try it out. On the Region4 website, http://www.region4.com.au/?p=56, and then on the Primera website, http://www.primera.com.au/?p=56. Neat.

This is because I put in some code that checks the product range (a custom field entry) each time a product page is loaded and shows content accordingly.

Anyway, I’ve been typing too long. Tell me your feedback.

Cheers.

Nick.