Page 1 of 1
Can multple shops share a database
Posted: Sun Mar 01, 2015 12:33 am
by premint
Can i have 3 or 4 different online shops with different domain names share a single database ? they would all be selling the same products at the same price
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 6:53 am
by IP_CAM
OC can handle Multi-Shops, they all are connected to/trough the same Database. BUT..., under certain Conditions only!
One of them may
probably be, that all SITES related are physically placed on the same Server, using the same BASIC ROOT path, i.E.
/home/yourname/www/site_a/shop/
/home/yourname/www/site_b/shop/
/home/yourname/www/site_c/shop/
/home/yourname/www/site_d/shop/
http://www.opencart.com/index.php?route ... ure&path=4
GOOGLE for: "Opencart Multi Store"
for further details, I have never tried that stuff yet.
Ernie
bigmax.ch/shop/
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 7:23 am
by premint
all the sites would be on the same server, my idea is to run 3 or 4 shops under different domains hopefully each using different skins/themes
products, descriptions etc and prices would all remain the same
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 11:16 am
by labeshops
Yes. See the links in my signature - I run more than 20 multistores this way.
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 11:29 am
by IP_CAM
labeshops wrote:Yes. See the links in my signature - I run more than 20 multistores this way.
one of those days, I wanna find out on this. One short Question: Does it really somehow 'file-lock', if multiple 'Tasks' are done with/on the same item?
Ernie
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 8:15 pm
by labeshops
IP_CAM wrote:labeshops wrote:Yes. See the links in my signature - I run more than 20 multistores this way.
one of those days, I wanna find out on this. One short Question: Does it really somehow 'file-lock', if multiple 'Tasks' are done with/on the same item?
Ernie
Not understanding your question. I am the only admin on my stores so do you mean so multiple people cannot edit the same item? If so, I have no idea.
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 9:21 pm
by premint
firstly im using cubecart 2, not 1.5
i want to run 3 or 4 different websites IE,
www.site1.com,
www.differentsite.com,
www.anothersite.com
i do NOT want sub domains, each shop will have its own exclusive domain but all on the same server / host
they will all sell exactly the same products with the same item descriptions etc
the reason i wnat more than one site selling same stuff is because i want to use different skins / themes for each site
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 11:38 pm
by IP_CAM
labeshops wrote:Not understanding your question. I am the only admin on my stores so do you mean so multiple people cannot edit the same item? If so, I have no idea.
I meant, how does OC avoid a DB-Collision, if an item is called/ordered/processed, possibly exactly at the same time. Under Perl, Db-Access is 'file-locked', in such a Case, for a second or so, to avoid it to be 'editable' by more than one User at once in order to prevent a 'Collision'.
Code: Select all
if($config{flock}){
flock(FILE,2);
seek(FILE,0,2);
}
Is this done in any way in OC, or, how does handle OC such 'things'?
Ernie
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 11:52 pm
by labeshops
IP_CAM wrote:labeshops wrote:Not understanding your question. I am the only admin on my stores so do you mean so multiple people cannot edit the same item? If so, I have no idea.
I meant, how does OC avoid a DB-Collision, if an item is called/ordered/processed, possibly exactly at the same time. Under Perl, Db-Access is 'file-locked', in such a Case, for a second or so, to avoid it to be 'editable' by more than one User at once in order to prevent a 'Collision'.
Code: Select all
if($config{flock}){
flock(FILE,2);
seek(FILE,0,2);
}
Is this done in any way in OC, or, how does handle OC such 'things'?
Ernie
Sorry, but that is way too technical for me to answer. Perhaps someone else can.
Re: Can multple shops share a database
Posted: Sun Mar 01, 2015 11:57 pm
by labeshops
premint wrote:firstly im using cubecart 2, not 1.5
i want to run 3 or 4 different websites IE,
http://www.site1.com,
http://www.differentsite.com,
http://www.anothersite.com
i do NOT want sub domains, each shop will have its own exclusive domain but all on the same server / host
they will all sell exactly the same products with the same item descriptions etc
the reason i wnat more than one site selling same stuff is because i want to use different skins / themes for each site
Multistores works the same in v2 as they do in 1.5.
I use exclusive domains for each store. Only the store you set up as the main installation actually is "hosted" (labeshops.com in my case) - all others are set up as addon domains in your host's control panel that point to your oc installation directory. (see
http://forum.opencart.com/viewtopic.php?f=19&t=98202 for step by step instructions).
By default, all stores would have the same item descriptions (I use a mod to let me have different ones for each store as well as custom product names/titles per store). You can add products to any of the stores you want, including all of them if that is what you want.
You can use different themes for each store.
Now from an SEO standpoint, I would NOT use exactly the same products with exactly the same descriptions as google will view them as duplicate content so you will not rank as well. If you are going to use other means of advertising such as PPC, this is less important, but know that your organic reach may not be very high.