Reza,

I have just been through the exercise of setting up multiple shops from the one database using Gerome's module and so far I am loving it. To help answer a few of your questions.

1. The SQL query needs to be run in the admin section for MySQL from your hosting companies MySQL admin tool.

- What errors did you get? This query worked first off for me.
- You will see the constant names in the Admin section of your ZenCart, under the Configuration menu there are loads of submenus each with different things to change. Say you pick the Layout Settings and then the first thing to modify is the "Column Width - Left Boxes". Over on the right hand side of the page is the bit with the edit button, The bit in the CAPS text is the Constant Name. Like so:

Width of the Left Column Boxes
px may be included
Default = 150px
BOX_WIDTH_LEFT

It is the same for all the modifyable bits.

2. A redirect Model would not allow you to have different templates, or looks for each site.

The way that I set up my multisite shops was to install ZenC on the "Primary" site, (http://dcinet.com.au/catalog/), then apply the Multisite changes. Then copy the catalog directory to subdomains, (I have http://shop1.dcinet.com.au/catalog/ and http://shop2.dcinet.com.au/catalog/). When I copied the catalog directories I removed the admin directory from shop1 and shop2, I also had to edit /includes/configure.php to modify urls and directory paths. You will probably need to do this. Using Gerome's multisite module I was able to apply different templates to each site, you can see the results at the urls above.

3. see 2. :)

4. all of mine were on the same host, I think that this will make it easier. I'm not sure how you would go trying to connect to the main site database from other hosts, (this might not work, then again it might, haven't tried it can't give you a definitive answer.)

5. I do not quite understand this question.

6. This is the same as 1. what was the error?

7. As I said before I don't think redirection is the model that will work for you, but it really depends on what you are trying to achieve. The model that I have set up will work for me, because I want to have one database / list of products, One Shopping Cart, but multiple shops all with a different look. My plan is to sell shops to companies where their employees can by products from my offerings, but each shop will be branded to the company that buys it. So what is it that you want to achieve?

8. The reason that you have no products or categories displayed is that you missed a step in the instructions. You need to add <!--sitename--> to the description for the categories that you want to display in your shop. You need to add a separate comment for each site that you want to display the category in. So if you have site1, site2, and site3, and you have a category called hardware, and you want to display this category in site1 and site3 but not site2, you need to add <!--site1--><!--site3--> to the description of the category hardware. You add this in the ZenC admin site. Log in to the admin site::Select the Catalog Menu::Select the Categories and Products menu item::Click the little green "e" on the right hand side of the page that lines up with the "Hardware" category::Add <!--site1--><!--site3--> to the categories description field:: Click the Save Button::Go back to your Shop and refresh the page::Viola:: Happy happy Joy Joy, well at least that is what I said when I got things going.



I hope that this helps at least a little bit, and just post again if this wad of info leads you to more questions.

Kind regards,

David Buckley.