Multi-Stores shop system for OSCMAX

[BudiSoetantijo]

Hi...

I am trying to get multistore to work as well.

I am getting this error when the search feature is used:
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 = '2' 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 '%toy%' or p.products_model like '%toy%' or m.manufacturers_name like '%toy%') )

Has anyone find a solution to this ?

Thank you.

[plorimer]

Hi there

This is my first post so I hope it is in the correct place.

The query above, are you by chance using MySQL V5.xx because it uses more standardised SQL and less of the MySQL specific syntax. I've had a lot of table joins fail. As a rule of thumb I've been ensuring that all FROM statemens are enclosed in parenthesis. It has solved that exact error for me many times. You can veryfy it by testing on a system running MySQL4.xx - I bet there is no error.

[plorimer]

Hi

Is this the correct mod for me to do the following:

I have 10 or so shops for the same client the sell Scottish Clan wear, Higlandwear and are the largest Tartan manufacturer in the world.

Each product is available in different Tartans of which there are over 10,000 and they come in several different weights. You can imaging the data input.

While in the USA I saw a site - did not get the e-commerce engine name but basically it works with a centralised database (or site) where I add all the products only once. Then I can go into the product settings and choose which sites that product is to be sold on. So if i have 10 sites I may have 10 checkboxes where i tick whatever sites to sell the product on and those sites are automatically populated with the product data.

Would the Muli-Stores Shop Mod work for this????

[MindTwist]

Yes, this mod would work for that. BUT, only if those 10 stores are being run from the same host/server, because all the stores will be runing on the same database (if they sell worldwide and they have their stores being run on different hosts/countries, it would not work).

All the stores would be sharing database and be runing on the same products table, and you can activate products on any given store.

Kepp in mind that it is a HARD contribution to install and run. It is already hard on a plain OSC/OSCMAX installation, and it is harder the more contributions you have on your store, since many contributions might need "multistores tweaking".

[plorimer]

Excelent

We have a server cluster containing 2 mysql servers so will give it a try but I'm also in the process of setting up a stand alone server just for that client.

Thanks for the quick response

[jpf]

MindTwist:

This contrib is easier to install when all sites ar hosted on the same server. In reality - as long as the MYSQL is hosted on the same server - is a more correct term. (have done this with MS2 - but have not done this with Multi-store - but should work the same)

Yes this is a hard contrib to add and have work - because it is heavily modified and on top of a heavily modified store. I am not the original contrib maker - just the one who converted it to oscmax.

[plorimer]

Excellent will give it a try.

Do you know if anybody has ported OSCMax to work with Postgres (database abstraction layer)?

[Gerald_1980]

Will this contrib work with the newest version of OSCMAX (RC4)? It looks like a pain to install so I'd like to know if it works first before attempting to install it!

[jpf]

It was a PITA :anal:to do - but is not been worked on for a while now. Most likely Not RC3 or RC4 compatibly.

[MindTwist]

I am using Multi-Stores with RC3. It was indeed very hard to get to work everywhere, and I am sure it will be about the same with RC4, there is a lot of work to be done on it.