Using oscMax for multiple stores.

**oblongpeg** · 10-06-2006, 03:45 PM

Hi all,

I am trying to set up a multiple store site using oscMax for a friend (read free). Have read ronu's recent query on this.

I have looked into the multi store contrib in oscommerce, but it does not lend itself to BTS, tinyMCE, etc.

Wanting some db tables to be common (eg, customers) and others to be unique to each store (eg, products), I created extra tables to accomodate the changes required, eg shop1_products. shop2_products, etc.

I then changed the table paths in the respective database_tables.php files in catalog and admin to reflect the changed db table names, as well as other tables that have been modified.

Now, when I try to open the shop, it is looking for the original Table.products, and not Table.shop1_products, as modified in the define argument in database_tables.php.

Where else is the table called in it's raw name. The only reference I can find is the TABLE_PRODUCTS call.

I have found a couple of unrelated raw calls in the admin section relating to added features, which when changed work fine. Just cannot find the calls in the index.php, application_top.php or the other myriad files I have looked at.

Unfortunately, sub domains are not an option in this instance. Shame, it would have made the job a breeze.

Sorry for the long winded post.

**oblongpeg** · 10-06-2006, 05:06 PM

Here is a weird update.

I have just added the tables that were said to be missing (products,etc) without the shop prefixes, so that I can get with other things for the time being.

What actually shows up on the page when it does open is the details (categories, products, and such) that were added to the modified tables.

It appears that to open the page, it is looking for the old table names, but once the page is opened it is looking at the modified tables.

Any clues on where to look for this fault would be much appreciated.

**jpf** · 10-08-2006, 05:43 PM

Multi-Stores multiple shop system
http://www.oscommerce.com/community/contributions,1730

Convert to BTS is not impossable. As long as all stores are hosted on the same server it has been done before.

**oblongpeg** · 10-10-2006, 04:53 AM

Thanks for the reply jpf.

I do prefer to stick with getting max running properly in the multistore environment as, not only for the templating and wysiwyg type additions, there are many other changes in here that are going to be utilised as well.

The latest is that by placing a set of tables in the database without any name change allows me to open the site. Any alterations to say categories, products, etc, get entered into the correct altered tables as they should. So basically I can use max for what I want to do without any problems now.

It is getting to be a niggling thing, not being able to clean up this problem.

Can someone advise me where to look for the statup problem. What files are being called during the initial site opening process, before index.php is opened. I have searched high and low in many files for the raw table call to no avail.

Like I said, it is not an urgent issue any more as the site is running properly on the test server, it is just that I feel that I am cheating and would like to clean it all up so it is performing without bandaids.

Thanks again for your help.

**jpf** · 10-12-2006, 07:28 PM

Like I said use the file above.....Compare it to a PLAIN MS2 and comment the differnces.

Then in MAX compare it the NEW set. Add in what is needed and is not duplicated. If you get stuck with a few lines - post them and we can help.

I am unable to upload any files to this board so I can't give you the files I have......

**ashelleydesign** · 04-01-2007, 11:19 PM

Has anyone successfully added multiple stores to oscmax?

**ashelleydesign** · 04-01-2007, 11:24 PM

Originally Posted by jpf

Like I said use the file above.....Compare it to a PLAIN MS2 and comment the differnces.

Then in MAX compare it the NEW set. Add in what is needed and is not duplicated.

Is there a quick and easy way to compare code? There are a boat-load of files for Multiple Stores install. I have dreamweaver. Are ther any tips or tricks to expediting the process...Thanks, Angie

**bkpie** · 04-03-2007, 04:38 AM

Get Beyond Compare or Winmerge They work well

**ALElder** · 04-03-2007, 05:33 AM

If someone gets this to work would be a great mod to post

**jpf** · 04-16-2007, 02:37 PM

Ditto on the Beyond Compare(not free) and Winmerge(free)! They BOTH show a side by side comparison of what is changed/added - very quick to learn and navigate.