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

[c.h.u.d.]

I think all mods/contribs are moderated. Can you just attach it to this thread as a zip so we can at least download it until they get around to moderating it?

[michael_s]

Originally Posted by kris7845

After re-reading my previous post let me revise (this forum needs an edit button)...

Ok, you now have an edit button

I think all mods/contribs are moderated. Can you just attach it to this thread as a zip so we can at least download it until they get around to moderating it?

It has not been approved yet because it was not properly submitted as a revision to the existing project (by clicking the 'Add revision' link in the main project). It is a little time consuming to correctly attach it to the project manually and I have not gotten around to moving it over...

[michael_s]

I just added the fixes as an attachment to the main project until a full release can be packaged. You can get it from the main multi stores project page.

[kris7845]

Originally Posted by simplex

Kris7845

Well I think I did everything you suggested in your previous posts and PM to me. When I drop the tables in the original or original/updated database and "Import" your database I now get multiple errors using myPHP. I comment out the 1st one about the #1193 SQL_MODE then I get a syntax errors starting with the address book entries one upon the other as soon as I correct 1 there is a next one.

I'm not really proficient at databases either...

Thanks for all your help but I think it's simply too discouraging and time-consuming that so many of the "Features" or add-ons to a basic install of oscMax are too difficult to implement for the osc novice.

Thanks to all

It takes time but keep in mind the multi store mod is probably one of the more difficult mods to install, it ranks up there with the gift voucher system. JPF did a remarkable job with the conversion to max but like most mods of this caliber it needs some fixes/tweaks here and there.

Right now my time is divided into work, moving and building my site but when I get some more time i am going to come back and see if i can help out with the fixes/tweaks.

[simplex]

Kris 7845, I totally admire members like yourself, JPF and others for your dedication and commitment to the oscMax project. I am sorry my skills don't allow me to do anything more than ask for help rather than contribute.

I think this software has great potential in all applications of e-commerce and will continue to watch what happens to it in the future. I am under the gun at this point and must get a site up and running efficiently and no longer have the luxury of trying to learn new languages or mysql management so I will need to move on for now.

Keep up all the good work and I will keep coming back to see how this progresses.

Thanks,
Simplex

[CMWM]

I am having all of the problems that Simplex is having. I have installed oscmax v2 rc3.0.1 installed the multi-stores shop system and updated the database. I have then applied the fix but continue to get the 1054 error.

I have tried to upload the test database supplied but get multiple php errors. I am using php 4.41 and the sql says 4.47 is this the problem. If so what can I do to make them compatable?

Has anyone worked through these issues and got them to function? I really need to see if it can work for me.

By the way I also use the wholesale group.

Thank you!
John

I do appreciate all of the effort everyone has put into this.

[CMWM]

sorry I miss stated. The mySQL version is 4.0.27 standard and I believe the SQL statement is 5

[FlakyJake]

Originally Posted by CMWM

sorry I miss stated. The mySQL version is 4.0.27 standard and I believe the SQL statement is 5

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%') )

[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..

[FlakyJake]

The search thing is still a problem and don't seem to be able to resolve it, anyone have any iideas..