MultiSite Module Support Thread

[philb316]

Thanks!

The sites sell related equipment, all in the automotive industry, so it would be my guess that as long as only 1 template was needed for displaying all product, that I could potentially collapse the sites into 1.
The sites are:
wiretrim.langeman.com
wrapcut.langeman.com

and they also created separate sites for the CDN equivalents at:
wiretrim.shoplangeman.ca
wrapcut.shoplangeman.com
I do not know why a separate set of sites (with their multisite module) were created for Canada. Although I believe that the pricing is different. i.e. not even after the US/CDN dollar exchange is taken into account.

Does Zencart have limitless pricing levels? i.e. could I have separate pricing for Distributor A, Distributor B, ... Distributor N, plus retail etc ?

Thanks.

[twitchtoo]

It's less complex to have one site and point the various domains at it when you're only using one template. Yes there are a number of options for group pricing, discount pricing and wholesale pricing in the forum plugins.

From my biased perspective, Group Pricing is currently being integrated into Twitch Wholesale which would give you guest, retail, wholesale prices then 5 more static pricing levels.

[philb316]

I have no problem paying for good code / good support that makes things simpler. I am still re-establishing requirements, but once they're done will be looking for solutions to set up ZenCart for selling products on every continent - well maybe not Antarctica - but certainly will require quite a number of pricing levels plus multiple languages.

Thanks again for your help.

[twitchtoo]

Sounds good, you know where to find me ;)

[adb34]

I am just trying to get my head around MYsql and adding/removing items from the database.

Using this plugin as reference I do not understand why there is only one line of command in the install patch and three lines in the uninstall patch.

Install.sql

ALTER TABLE orders ADD order_site varchar(30) NOT NULL DEFAULT 'no';


Uninstall.sql

ALTER TABLE `orders` DROP `order_site`;
ALTER TABLE `ezpages` DROP `ezpages_description`;

DELETE FROM admin_pages WHERE page_key = 'toolsMultiSite' LIMIT 1;

First: is this the correct place to talk about this
Second: can somebody explain why there is a variation in the two sql’s

[twitchtoo]

ALTER TABLE orders ADD order_site varchar(30) NOT NULL DEFAULT 'no';
This adds the column 'order_site' to the orders table

Uninstall.sql

ALTER TABLE `orders` DROP `order_site`;
This removes the column 'order_site' from the orders table

ALTER TABLE `ezpages` DROP `ezpages_description`;
This removes 'ezpages_description' from the ezpages table

DELETE FROM admin_pages WHERE page_key = 'toolsMultiSite' LIMIT 1;
This removes the 'toolsMultiSite' from the admin registry page

[simpledomaining]

Hello. i am looking at this module, and need a little bit explanation if it will work for me. We have a working site mydomain.com/store in english. i need to add 2 more translations for the entire site and its products (spanish and french). do i need to use the multisite module for this or there is anything simpler available? will this module in any way affect my existing urls? will qbi orders exporting work with multisite? thanks.

[ideasgirl]

Hello. i am looking at this module, and need a little bit explanation if it will work for me. We have a working site mydomain.com/store in english. i need to add 2 more translations for the entire site and its products (spanish and french). do i need to use the multisite module for this or there is anything simpler available? will this module in any way affect my existing urls? will qbi orders exporting work with multisite? thanks.

Hello!

No, you don't need multisite for that. You just have to download the languages files for those languages and install.

[Design75]

Hello. i am looking at this module, and need a little bit explanation if it will work for me. We have a working site mydomain.com/store in english. i need to add 2 more translations for the entire site and its products (spanish and french). do i need to use the multisite module for this or there is anything simpler available? will this module in any way affect my existing urls? will qbi orders exporting work with multisite? thanks.

No you do not need this module, just install extra languages

[royaldave]

Would you like to see which 'template' your customer is visiting when looking at whos_online ?

I did, and here's what you need to do if you also wish to ....



WHOS ONLINE FOR MULTISITE

Add following column to whos_online in database -

site varchar(50)

---------------


/zencart/admin/includes/languages/english/whos_online.php

add -

define('TEXT_SITE', '<strong>Site:</strong> ');

---------------------

/zencart/admin/whos_online.php

change -

$who_query = $db->Execute("select session_id, time_entry, time_last_click, host_address, user_agent
from " . TABLE_WHOS_ONLINE . "
where session_id='" . $which . "'");

to -

$who_query = $db->Execute("select session_id, time_entry, time_last_click, host_address, user_agent, site
from " . TABLE_WHOS_ONLINE . "
where session_id='" . $which . "'");

change -

$sql = "select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent
from " . TABLE_WHOS_ONLINE . " :where: order by :orderby:";

to -

$sql = "select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, site
from " . TABLE_WHOS_ONLINE . " :where: order by :orderby:";

change -

echo TEXT_SESSION_ID . zen_output_string_protected($whos_online->fields['session_id']) . '<br />' .
TEXT_HOST . zen_output_string_protected($whos_online->fields['host_address']) . '<br />' .
TEXT_USER_AGENT . zen_output_string_protected($whos_online->fields['user_agent']) . '<br />';

to -

echo TEXT_SESSION_ID . zen_output_string_protected($whos_online->fields['session_id']) . '<br />' .
TEXT_HOST . zen_output_string_protected($whos_online->fields['host_address']) . '<br />' .
TEXT_SITE . zen_output_string_protected($whos_online->fields['site']) . '<br />' .
TEXT_USER_AGENT . zen_output_string_protected($whos_online->fields['user_agent']) . '<br />';

------------------------

/zencart/includes/functions/whos_online.php

change -

$wo_user_agent = substr(zen_db_prepare_input($_SERVER['HTTP_USER_AGENT']), 0, 254);

to -

$wo_user_agent = substr(zen_db_prepare_input($_SERVER['HTTP_USER_AGENT']), 0, 254);
$wo_site = SITE_NAME;

change -

$sql = "update " . TABLE_WHOS_ONLINE . "
set customer_id = '" . (int)$wo_customer_id . "',
full_name = '" . zen_db_input($wo_full_name) . "',
ip_address = '" . zen_db_input($wo_ip_address) . "',
time_last_click = '" . zen_db_input($current_time) . "',
last_page_url = '" . zen_db_input($wo_last_page_url) . "',
host_address = '" . zen_db_input($_SESSION['customers_host_address']) . "',
user_agent = '" . zen_db_input($wo_user_agent) . "'
where session_id = '" . zen_db_input($wo_session_id) . "' and ip_address='" . zen_db_input($wo_ip_address) . "'";

to -

$sql = "update " . TABLE_WHOS_ONLINE . "
set customer_id = '" . (int)$wo_customer_id . "',
full_name = '" . zen_db_input($wo_full_name) . "',
ip_address = '" . zen_db_input($wo_ip_address) . "',
time_last_click = '" . zen_db_input($current_time) . "',
last_page_url = '" . zen_db_input($wo_last_page_url) . "',
host_address = '" . zen_db_input($_SESSION['customers_host_address']) . "',
user_agent = '" . zen_db_input($wo_user_agent) . "',
site = '" . zen_db_input($wo_site) . "'
where session_id = '" . zen_db_input($wo_session_id) . "' and ip_address='" . zen_db_input($wo_ip_address) . "'";

change -

$sql = "insert into " . TABLE_WHOS_ONLINE . "
(customer_id, full_name, session_id, ip_address, time_entry,
time_last_click, last_page_url, host_address, user_agent)
values ('" . (int)$wo_customer_id . "', '" . zen_db_input($wo_full_name) . "', '"
. zen_db_input($wo_session_id) . "', '" . zen_db_input($wo_ip_address)
. "', '" . zen_db_input($current_time) . "', '" . zen_db_input($current_time)
. "', '" . zen_db_input($wo_last_page_url)
. "', '" . zen_db_input($_SESSION['customers_host_address'])
. "', '" . zen_db_input($wo_user_agent)
. "')";

to -

$sql = "insert into " . TABLE_WHOS_ONLINE . "
(customer_id, full_name, session_id, ip_address, time_entry,
time_last_click, last_page_url, host_address, user_agent, site)
values ('" . (int)$wo_customer_id . "', '" . zen_db_input($wo_full_name) . "', '"
. zen_db_input($wo_session_id) . "', '" . zen_db_input($wo_ip_address)
. "', '" . zen_db_input($current_time) . "', '" . zen_db_input($current_time)
. "', '" . zen_db_input($wo_last_page_url)
. "', '" . zen_db_input($_SESSION['customers_host_address'])
. "', '" . zen_db_input($wo_user_agent)
. "', '" . zen_db_input($wo_site)
. "')";