Multi-Stores shop system for OSCMAX

[jpf]

A new project_project entry has been added:

[drupal=173]Multi-Stores shop system for OSCMAX[/drupal]

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

[simplex]

I just installed osCMax v2_RC3_0_1 which seemed to work just fine. I did not make any changes to the install except to change the template from aabox to CSS-Fluid-1.

I then downloaded & installed multi-stores_v1_4MAX exactly as instructed in the 'install.txt' file included. I now get the following error when I choose from the category list on the opening page:

1054 - Unknown column 's.specials_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c LEFT JOIN specials_to_stores s2s ON s.specials_id = s2s.specials_id 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 = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1'

This only appears to happen when I attempt to go to the category products list from the menu. If I go directly to the product from the "What's New" listing everything works out just fine.

Since I am new to osCMax I assume I have not done something that would be taken for granted by others more familar with it. Please help.

Thanks in advance.

[mlloyd]

I got the same problem, but I think the problem is caused by the Multi Store package (which I assume was coded for OSCMAX 1.4) is not compatible with OSCMAX 2.0.

Basically someone needs to work out the changes needed to add multistore to OSCMAX 2.0.

[simplex]

That's what I thought might be the problem however, the last update that was made to the mod was after Ver 2.0 and I believe reference was made to the changes that would be compatible with it.

BTW, thanks for the reply. This message and others that I have posted, including a "contact us" email concerning templates, have gone basically un-answered. This kind of help reminds me of another nightmare called MIVA which you also couldn't get help with nor did they have a great tutorial on how to edit the store. Oh, well, I guess newbies to this software just have to waste ridiculous time or simply move onto a more editable shopping cart.

[bkpie]

Please be patient with this board. It is a growing community and the more people we get involved the better this and oscmax will get. Out of all the carts I worked with this one is very versatile. You do need some patience and have to do alot of googling and research on some problems but I have learned much from that.

I can not answer your problem as I have not added that contribution yet but plan to. I believe jpf ported that to work with oscmax and has it working. Maybe he might have an answer and I am sure he will respond if he does.

[michael_s]

First, you should probably post any problems with the multi-store mod in the dedicated thread that actually deals with that mod:

http://www.oscmax.com/forums/oscmax-...em-oscmax.html

Oh, and one last thing, you are not allowed to start complaining about us until you have at least 25 posts, and have become one of us, but then you can really let it rip.

As for your actual problem, I have never tried to install that mod.

[mlloyd]

In osCommerce (or I guess OSCmax) it is usually fairly easy to add a bug free individual contribution to the base module by following installation instructions. The complications usually start to arise when there are multiple contributions added which start cutting across or interfering with each other. Even then contributions which involve mainly small changes to a small number of existing modules are not to difficult to adapt.

Adding big contributions like Multi-Store to an existing heavily modified version of osCommerce (like OSCmax 1.4 or OSCmax 2.0) is quite a daunting task as it involves new tables, additional fields on tables, lots of code changes to lots of modules. I assume that the OSCmax 1.4 multi store contribution worked well with OSCmax 1.4 and I am sure the contributor could probably make it work for 2.0 if he has the time and inclination, just the same as I could make it work if I had the time (....which I dont!).

An alternative would be to offer new OSCmax users the opportunity to download previous versions of OSCmax like 1.4. It is possible that OSCmax 1.4 (which I assume was a stable version) plus an easy upgrade to a working multi-store might be closer to what I need than OSCmax 2.0 plus a headache!

In an ideal world we will be able to select base osCommerce plus just the contributions we actually need though we are a way off that Utopia just yet.

[mlloyd]

Hi, just to advise that a I have had a problem installing this contribution with osCMax v2_RC3_0_1. Same problem also encountered by another user (see link further below).

We both tried this as we noticed your contribution was posted after OSCmax 2.0 became the base version.

I assume your multi-store add on was for a OSCmax 1.4 installation. Do you intend to provide an OSCmax 2.0 version?

We got the following error when I choose from the category list on the opening page:

1054 - Unknown column 's.specials_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c LEFT JOIN specials_to_stores s2s ON s.specials_id = s2s.specials_id 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 = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1'

http://www.oscmax.com/forums/oscmax-...html#post27962

[bkpie]

I believe that the Multi Store Contribution version is 1.4 not OsCMAX . The Contribution was ported for the current version of oscmax however since not installing it I am not sure what is causing this error other than it says unknown column so the first place I would look at is the DB to see if it is there.

[michael_s]

I am merging this thread with the official thread to keep everything together.