Community Add-Ons

Multi-Stores multiple shop system
for osCommerce Online Merchant v2.2

Description
History

These modifications allow you to assign specific products and categories to multiple stores that you define in the administration panel. The products and categories
will not be able to be manipulated via the web-browsers address bar (like in most
other multi-shop implementations). Also, there is no "one store to rule them all".
You decide which categories you want displayed on which store-front. You decide
which products in that category you want displayed on which store-front. Shopping
carts are NOT shared between the sites.

Legend: Download Report

Expand All / Collapse All

Full V2.0 package including security patch. Does not include the sitemap class from the previous contribution.

--------------------------------------------------------------------------------------------------------------
AUTOMATIC STORES GENERATION WITH OSCOMMERCE AND MULTI-STORES ADD-ON
USING A LAMPP ENVIRONMENT (Apache, MySQL and PHP under LINUX)
AUTHOR: Jose Ignacio Alvarez Ruiz
WEB: http://www.nacho-alvarez.es
--------------------------------------------------------------------------------------------------------------
Description:

The magnific Multi-Stores add-on (http://addons.oscommerce.com/info/1730) allow to modify the OsCommerce structure in order to maintenance different stores. For now, and it is all that I know, the only way for duplicate a store was copying manually the folder that contains the Oscommerce installation to a well-know path.

With the modifications I suggest, when stores are going to be created, the name and password of the manager can be specified and the following will be ocurr:

* An automatic copy of your master store will be made.
* A manager for the new store will be created, without visit the 'Administrators' menu.
* If you make changes in the master store, these changes will be showed in the rest of the stores, without need of aditional changes.
* When you delete a store, the data of the manager, the data of the store and the data of database relative to this store will be deleted.

To-Do:

Some new text is writed in english in order to don't modify various files of the OsCommerce structure. It is necessary to define constants for each language and text.
-------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
GENERACIÓN AUTOMÁTICA DE TIENDAS CON OSCOMMERCE Y MULTI-STORES
UTILIZANDO UN ENTORNO LAMPP (Apache, MySQL y PHP bajo LINUX)
AUTOR: José Ignacio Álvarez Ruiz
WEB: http://www.nacho-alvarez.es
--------------------------------------------------------------------------------------------------
Descripción:

El magnífico add-on Multi-Stores (http://addons.oscommerce.com/info/1730) permite modificar la estructura de OsCommerce de forma que se puedan mantener varias tiendas. Hasta ahora, por lo que yo conozco, la única forma de replicar las tiendas era copiando manualmente la carpeta con la instalación de OsCommerce a una ubicación bien conocida.

Con las modificaciones que propongo, al crear tiendas, se puede especificar el nombre y el password del gestor y ocurrirá lo siguiente:

* Se realizará una copia automática de su tienda maestra.
* Se insertará el gestor de forma automática, sin tener que pasar por el menú 'Administradores'.
* Si usted realiza cambios en la tienda maestra, éstos se reflejan en el resto de tiendas del sistema sin necesidad de cambios adicionales.
* Cuando usted elimina una tienda, se eliminan tanto los datos del gestor que la mantiene como la carpeta que contiene los datos de la tienda, así como los datos contenidos en la base de datos relativos a dicha tienda.

Por hacer:

Algunos textos nuevos están escritos en inglés para no modificar varios ficheros de la estructura de OsCommerce. Es necesario definir constantes para cada idioma y cada texto.
-------------------------------------------------------------------------------------------------

This solution was posted by Jean Pierre in the forums at: http://forums.oscommerce.com/index.php?s=&showtopic=70365&view=findpost&p=1079735

VERSIONS AFFECTED: Multistores version 2.0 (not v 1.9), any maybe only needed for mysql 5.xx and/or php 5.xx versions.

Problem: When clicking on the "New Products" button in the Specials page the following error occurs:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pd where p.products_id = pd.products_id and pd.language_id = '1' order by prod' at line 1

select p.products_id, pd.products_name, p.products_price from (products p, products_description) pd where p.products_id = pd.products_id and pd.language_id = '1' order by products_name

[TEP STOP]

Solution: Edit catalog/admin/includes/function/general.php line 209 (The parenthesis ")" before "pd" should be AFTER "pd".)

Original code: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " ) pd " . ($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ") . "where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' " . ($admin_allowed_stores[0] == '*' ? " " : " and p2s.stores_id in(" . implode(',' , $admin_allowed_stores) . ") ") . "order by products_name");

Corrected code: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd )" . ($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ") . "where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' " . ($admin_allowed_stores[0] == '*' ? " " : " and p2s.stores_id in(" . implode(',' , $admin_allowed_stores) . ") ") . "order by products_name");

Thanks to Jean Pierre

Incidentally: This problem does not occur in Hobzilla's v 1.9. Line 209 in his file is as follows and also works:
$products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd " . ($admin_allowed_stores[0] == '*' ? " " : " LEFT JOIN " . TABLE_PRODUCTS_TO_STORES . " p2s ON p.products_id = p2s.products_id ") . "where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' " . ($admin_allowed_stores[0] == '*' ? " " : " and p2s.stores_id in(" . implode(',' , $admin_allowed_stores) . ") ") . "order by products_name");

File attached is precisely the same as this text

Community Add-Ons

Multi-Stores multiple shop systemfor osCommerce Online Merchant v2.2

Multi-Stores multiple shop system
for osCommerce Online Merchant v2.2