Multi-Stores shop system for OSCMAX

[jpf]

A new project_project entry has been added:

Multi-Stores shop system for OSCMAX

Version 1.4
=============
These modifications allow you to assign specific products and categories to multiple stores that you define in the administration panel. The products and categories

[habelson]

I do believe that I have fixed this problem, but I don't have time right now to dig up the code. Give me until Monday and I'll post the code snippet you need.

[habelson]

OK, this is real quick, I don't have access to my usual editor so I can't give you line numbers.

In /templates/fallback/content/catalog_products_with_images.tpl.php (or wherever your template content is if its not default)

find:

$products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, p.products_date_added, IF(s.status = 1, s.specials_new_products_price, NULL) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_GROUPS . " pg on pg.products_id = pd.products_id and pg.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order"; 

and replace with:

$products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, p.products_date_added, IF(s.status = 1, s.specials_new_products_price, NULL) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_GROUPS . " pg on pg.products_id = pd.products_id and pg.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_PRODUCTS_TO_STORES . " p2s on p.products_id = p2s.products_id left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id where p.products_status = '1' and p2s.stores_id = " . STORES_ID . " and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order"; 

That should do it.

I'm sorry I can't give you a line number, I think if you do a search for "// Number of products to display per page" the query will be right above that. It's somewhere in the third quarter of the code. Hope this helps.

[spooker8]

How do i actually access the individual stores? i have installed them but no idea how to access them

[habelson]

you need to set it up so that each store is in a different directory. For instance you may have all of your store files in /catalog

What I do then is create a new directory, like say /store2. Make symbolic links in /Store2 to every file and folder in /catalog except for the following files:

/includes/configure.php
/includes/database_tables.php

and whatever template you are using. You need actual copies of these files to be different from the main store.

create\edit a configure.php to point to the new /store2 instead of /catalog and create\edit the database_tables file to reflect the new configuration table you created when you created a second store in the admin panel.

Now, if you were able to access your primary store by going to yourdomain.com you can access your second store by going to yourdomain.com .

Hope this helps.

[spooker8]

Thanks alot for the info , i have better understanding now,

But can you clarify more on what you mean by

Make symbolic links in /Store2 to every file and folder in /catalog except for the following files:

/includes/configure.php
/includes/database_tables.php

[habelson]

I won't get into what symbolic links are. THink of them as shortcuts that point to the actual files. This was just my method of doing it. THis way if I had to change any code I wouldn't have to change the code for each store.

If that is not a concern, simply copying all of the files from your catalog directory into the directory that will be your second store will suffice. just make sure to make the proper changes to the two files i mentioned in your quote.

If you need more info.. PM me

[spooker8]

got it
i understood now , how it works ,

Originally Posted by habelson

I won't get into what symbolic links are. THink of them as shortcuts that point to the actual files. This was just my method of doing it. THis way if I had to change any code I wouldn't have to change the code for each store.

If that is not a concern, simply copying all of the files from your catalog directory into the directory that will be your second store will suffice. just make sure to make the proper changes to the two files i mentioned in your quote.

If you need more info.. PM me

[ALElder]

Have one problem please help:

After installing the main site is still @ 100%

The sub-site you can see the small image but cant Enlarge also lost all the Mo pics can someone help me out on this.

Also another question what can I delete from the sub-site can I get rid of images?

Thanks,

Adam

[MindTwist]

I still haven't began setipg up multisites myself, but I'll throw a quick question that might help others that need to try it, and that will save me a bit of googling when I need to try it myself.

A few years back I had to do something similar but with Postnuke instead of OSCMAX (several domains running off the same Postnuke install). I didn't have shell access on my account, just ftp, so I had to create the symbolic links with PHP.

So, the question is, anyone knows how to do it? I know I will eventually find it when I need it since I already did once, but if someone can post the info on the thread in advance, I will probably won't be the only one grateful.

[ALElder]

MindTwist,

Thanks for the input:

I have SSH access and still can't get the images to work.

Does anyone have a step by step instructions for how to fix the images.

Thanks,

Adam