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

[FlakyJake]

Is this module being maintained, as this thread seems to have died. I am trying to get this t work for a client across 5 domains and everything so far is ok bar the search facility.

Would i get a faster response if I paid for it?

[habelson]

I just wanted to thank everyone in this thread for all of the great info provided. I was able to get the multi-store mod working perfectly thanks to all of the info in this thread.

-Heath

[FlakyJake]

Thats good news Heath, I have got it working but having errors when using search see above, any ideas...

[habelson]

Honestly, I haven't had a need to test out search. Let me know what kind of problem you are having, Ill try to check it out.

[MindTwist]

(nevermind this post from me)

[habelson]

OK.. I have had the multi-stores mod running for about a month now. I have setup 5 different stores, with most files being symbolic links to the original install. Each store seems to work fine except for the account_history.php page, where I get an 403: Forbidden error from every store except for the original store. It doesn't seem to matter weather I am logged in as a valid customer or not.

Can someone please help me... this seems to be the last thing I need to iron out before I can go live.

[vpicchi]

Originally Posted by FlakyJake

I believe this is an error caused by MySQL 5. If anyone can help me correct the SQL for this version I am sure this will help a number of others..

Does someone make to run this project ?

[vpicchi]

Originally Posted by FlakyJake

I have got it working, thanks to the sql download and the fix. However, the only module throwing an error is the search module, whenever something gets put into the search box.

1066 - Not unique table/alias: 'c'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c left join specials_to_stores s2s ON s.specials_id = s2s.specials_id, categories c, products_to_categories p2c INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%siku%' or p.products_model like '%siku%' or m.manufacturers_name like '%siku%' or pd.products_description like '%siku%') )

Have you got a solution for this problem please ?
My version of MySQL is : 5.0.45
My version of PHP is : 5.2.5

Thanks in advance.

[habelson]

I haven't looked at the actual code except what you posted in the thread, but it looks to me like the categories table is referenced twice in the FROM clause. I haven't tested this but try removing one of the "categories c" from the query and that should fix the error.

[trifid]

I've been working on a multi-store system using osCMax v2 for the past month. One issue I have is that the "Printable catalog" selects all active products in the database no mater which store they are assigned to.

Looking at the SQL the selection based on store assignment does not exist. SQL is not my thing. Has any one fixed this issue and would be willing to share their solution?

This solution would be transferable to several other similar adaptations I am having to make to the code.