Multiple carts, copy or duplicate database?

25 Apr 2010, 22:55

#1

New Zenner

Join Date:: Feb 2009
Posts:: 15
Plugin Contributions:: 0

Multiple carts, copy or duplicate database?

I'm building multiple stores using Zen Cart. Initially, all of the stores will contain the same products. However, in the future, some stores will want to include optional products that the others don't have.

Several questions:

1. Is it possible to connect multiple Zen Carts to one database?
2. Is it possible to duplicate a database to use with different Zen Carts?

Thank you for your assistance!

25 Apr 2010, 23:08

#2

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Multiple carts, copy or duplicate database?

1. Is it possible to connect multiple Zen Carts to one database?

Yes, and to make management workable, there is a multi site 3rd party module - - Some have mastered it's setup buit the thread is long and I believe abandoned by the author

2. Is it possible to duplicate a database to use with different Zen Carts?

This is fully possible and you will end up with multiple stores, DB's and orders from each

25 Apr 2010, 23:13

#3

g1smd

Zen Follower

Join Date:: Mar 2010
Posts:: 449
Plugin Contributions:: 0

Re: Multiple carts, copy or duplicate database?

If you duplicate the database, how will you keep track of how many are left in stock when another of your sites sells the same item?

25 Apr 2010, 23:17

#4

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Multiple carts, copy or duplicate database?

g1smd:
If you duplicate the database, how will you keep track of how many are left in stock when another of your sites sells the same item?

While the OP did not specify, most that dropship do not have or track stock

26 Apr 2010, 06:48

#5

g1smd

Zen Follower

Join Date:: Mar 2010
Posts:: 449
Plugin Contributions:: 0

Re: Multiple carts, copy or duplicate database?

This is very true. :smile:

However I often see people implementing stuff before they have thought out what it is they really want it to do.

26 Apr 2010, 08:40

#6

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Multiple carts, copy or duplicate database?

g1smd:
However I often see people implementing stuff before they have thought out what it is they really want it to do.

BACKUP! BACKUP! BACKUP! BACKUP!
Before embarking on any mod install both files and the DB so you can revert back if it becomes a mess

Actually better to have a test site to practice on first

26 Apr 2010, 22:52

#7

jtlmusic

New Zenner

Join Date:: Feb 2009
Posts:: 15
Plugin Contributions:: 0

Re: Multiple carts, copy or duplicate database?

kobra,

You mentioned that it is possible to copy the database, or link multiple stores to one database. However, you didn't post any instructions on how to do it.

More info:
I have a potential of around 50 stores. Most will just sell the "stock" products, so the actual product line would be the same. However, the storefront (logos, graphics, ads, etc.) will be different for each. I would want to link these stores to the same product database.

Some stores will want some different products, in addition to the "stock" ones. In that case, I would need to duplicate the main database, then make some adjustments, as needed.

Each store will start with around 1000 products.

Thanks for your help!

27 Apr 2010, 02:48

#8

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Multiple carts, copy or duplicate database?

You mentioned that it is possible to copy the database, or link multiple stores to one database. However, you didn't post any instructions on how to do it.

I actually did and you can find the multi site module in the free software addons section - - - link above left

Copying the DB is in the tutorials/FAQ's section - - link above right and something that you should consult often

I searched it for "copy database"

https://www.zen-cart.com/tutorials/index.php?article=103

27 Apr 2010, 06:56

#9

g1smd

Zen Follower

Join Date:: Mar 2010
Posts:: 449
Plugin Contributions:: 0

Re: Multiple carts, copy or duplicate database?

jtlmusic:
I have a potential of around 50 stores!

I never understand why people want to run 50 sites instead of one. It's a lot more work. Google also takes a dim view of this sort of stuff. They usually call it 'spam'; they'll not want to list all of those sites. As a searcher, I'd not want to find 50 sites owned by one same company; I'd want to see diversity of supplier. That's Google's intent too.