MultiSite Module Support Thread

[makenoiz]

Have installed fresh 1.3.7 with Multi site. I have activated teh side box categories via tools > layout boxes but my cats show not products.
I have added the <!--site1-site2--> etc. code to descriptions in in categories_definiations but I still do no see any products. I am using the demo products that I installed with the ZC install.. ist here something else that I have to "turn on" in order to see the products?

Thanks

[makenoiz]

I need to make a correction... my categories are not even showing in the side box- only

Specials.....
All Products ....

Need the categories themselves to show.. I have placed the comments in the DB per instructions. What am I missing?

Thank you

[KThompson]

Check to make sure the name you used in the comments is the same that you specified in the "www.YOURDOMAIN.com_config.php" file

[tanik]

hi, i was testing out the payment on my website and i got this error message.

1054 Unknown column 'order_site' in 'field list'

and a bunch of other stuff below but thats the main one.

I was using paypal and using a credit card not a paypal account. it gives that error message but it went through with paypal but it did not go through in the orders under the admin page. Is there something wrong that i cannot see. The order did go through but only in paypal before it was working fine. But i think the multisite did something not sure what it is.

[cablesimple]

Just a forewarning, while I am using this, it is not even close to a complete solution. I also do not use the category filtering in this mod, or the cross-site carts so I have no idea if this would effect their functionality although it seems unlikely. I may never get around to providing this as an addition to this module, so figured it was still worth posting.

I had the need to limit which products were displayed by the stores by something other than categories. For the most part I needed to be able to restrict by manufacturer, but I figured why not make it more flexible while I was at it. So I decided to use the products_status field in the products table. Basically the idea is that you can create a filter group of products by making all of their products_status=2 (or any number). I keep the regular products that all stores can see on status=1. Then only the stores that are specifically given access to a status of 2 will be able to see the products in question. Doing this gives me unlimited product filtering flexibility. If I wanted to create tools to limit it by manufacturer it would be simple enough, although at the moment I just manually update the database where I see fit.

The other advantage to this solution for me is that I share the products,categories,manufacturers tables (mysql symbolic link) with another non-multisite store. By limiting products in this way the non-multisite store without any modifications will not see the products specified in a filter group.

What I did was install this function (put it in a file in includes/functions/extra_functions of any PHP filename):

function status_query_phrase()
{
    global $status_access;
 
   $query_phrase = "(";
 
    foreach ((array)$status_access as $status)
    {    $query_phrase .= "p.products_status = '". $status ."' OR "; }

    $query_phrase = rtrim($query_phrase,"OR ");
    $query_phrase .= ")";

    return $query_phrase;
} 

In each store config file includes\config_sites\www.example.com_config.php create the $status_access array:

$status_access = array("1","2"); 

Make sure each store has at least "1" so it can see the globally available products. You could make that a default in the function (if the array didn't exist) if you'd like, I chose not to.

Then I just used the zen cart developer tool to search for p.products_status and replaced each occurrence where products_status is in the "where" clause with status_query_phrase() like the example below from includes/functions/functions_categories.php

      $products_query = "select count(*) as total
                         from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                         where p.products_id = p2c.products_id
                         and ". status_query_phrase() ."
                         and p2c.categories_id = '" . (int)$category_id . "'"; 

Then you have to update the database and set the products you want in their respective filter groups. So for example if I wanted the manufacturer_id=5 to be only visible to one of my stores I would:

 update products set products_status=2 where manufacturers_id=5;

Then in the config file for the store that needs access add 2 to the status_access array.

Anyway, sorry for the roughness of this but I hope it's useful to someone out there.

[Coop1979]

I've been following this module for months, but there appear to be a few questions that I have that I can't find the answers to.

• I have my main ZC installation on domain1.com on server1
• I want to use the multisite module to use that 1 ZC installation on domain2.com on server2.
• Eventually I will have domain3.com on server3, domain4.com, etc... all on different servers.

How do I set that up?

[MotoDelta]

Not sure if anyone is still looking at this, but I have a few questions that I hope some Multisiters can help me with...

1. With secure checkout I'll be using a common page for all sites. (ie www.site1.com, www.site2.com all go to secure.site.com for checkout). Will the secure checkout respect the template of the site it came from?

2. Ihave the admin tools installed but the "add all" and "remove all" buttons generate the following error:

Line 28
char 6
Error 'name' is null or not an object
URL: http://secure.xxx.com/admin/multisit...tegories_sites

Any ideas?

[MotoDelta]

hi, i was testing out the payment on my website and i got this error message.

1054 Unknown column 'order_site' in 'field list'
.

Did you add the "order_site" column to the database per the installation instructions?

[MotoDelta]

On step 4 where exactly am I supposed to upload www.site1.com_config.php to? the site1.com html folder or a folder on the main sites area?

Thanks

To the includes/config_sites directory per the instructions.

[cablesimple]

MotoDelta

1. With secure checkout I'll be using a common page for all sites. (ie www.site1.com, www.site2.com all go to secure.site.com for checkout). Will the secure checkout respect the template of the site it came from?

Since you will have to setup secure.site.com in multisite config it will have its own template folder so I don't think it will. Don't remember seeing any code to make that work smoothly, but I could easily be wrong.

Try it. If it doesn't work you should be able to set something up where the template variable is passed when the secure site is accessed, put it in as a session variable, and then have the multisite config access that session variable as it's template folder.