multiple storefronts, same customer lists

[alexp]

Hi,

 

Just wondering if anyone knows whether it would be possible to

setup multiple stores that share same customer list. We are thinking

to use system in a restaraunt type of enviroment where diffrent types

of restaraunt units offer diffrent food products. We also want to be able

to query stores and find out which ones provide specifc type of food based on the search criteria that was supplied.

 

Is something like this possible ?

 

Thanks.

[Ian-San]

There is no problem having multiple stores sharing the same database (and hence same product list) providing that they also share the same domain name. So if your multiple stores have different urls, then they would need to auto - redirect back to the master store (which is not search engine friendly).

 

To my knowledge, you cannot share a database across different domain names.

 

Nor can you have different product lists stored in one database without a lot of bespoke coding unless you make creative use of OS e.g. by using a spare feature like manufature to indicate store name.

 

There are quite a few posts on this subject but no clear solution - every case is different.

[Ajeh]

I have the same database working with:

 

Same domain, different directories

 

Different domains, same server

 

Pointed domains, same server

 

As long as you can reach the database you should be okay.

[Ian-San]

Different domains, same server

 

Linda, are you saying that:

 

function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {

global $$link;

 

if (USE_PCONNECT == 'true') {

$$link = mysql_pconnect($server, $username, $password);

} else {

$$link = mysql_connect($server, $username, $password);

}

 

if ($$link) mysql_select_db($database);

 

return $$link;

}

 

would work from any domain name providing you specify DB_SERVER as the target domain name. Or is there more to it than that?

[Ajeh]

I am saying that on my server I have:

 

20 domain names

 

25 domain names that point to another domain name

 

I can set this up so that all of these, while using their own Catalog layout use the same Admin and same MySQL

 

Example:

 

http://www.thewebmakerscorner.com/allstores.html

 

These are either real domains, domains pointed to real domains or different subdirectories on the same domain.

 

There is just one Admin and just one MySQL

 

The difference here is that there is a setting for what products show where. This is something I am developing for multiple stores.

 

But, the same idea could be used where all stores show all the same products. Just each has its own Catalog face.

[cannuck1964]

Hi there,

 

I have just finshed setting up two stoes on different domain names using the same db, my client wanted different stores but the same products for both stores.....works great.....

 

most of what I did had to do with which tables osc has to use to get info from....

 

as well the image upload for the admin needed to be looked at too....

 

cheers...

[Guest]

Example:

 

http://www.thewebmakerscorner.com/allstores.html

 

These are either real domains, domains pointed to real domains or different subdirectories on the same domain.

 

There is just one Admin and just one MySQL

 

The difference here is that there is a setting for what products show where. This is something I am developing for multiple stores.

 

Hey there Linda :)

 

I was just wondering if when this code is completed will it be something that can be added to an existing store. I know that this sounds like a crazy question and all, but I have noticed with the other mall scripts it all comes down to the entry of the categories and products.

 

Thanks for the help :D

[Ajeh]

I have a lot of other add-ons to bring current and finish before I return to the multiple stores to get it running. It's not on the top of the To Do List ... but it's on the list ...