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

[ericgtp313]

Awesome, thanks for the quick reply

[ericgtp313]

Well, still getting the sql errors as the people above, the 1054 error, s.specials_id column.

I'm not sure what info I could give that would help debug for anybody, but heres everything relevant: PHP 4.3.9., mysql 4.1.20, centOS, apache 2.0.52, oscmax latest version, multi-stores latest version with all patches from this thread. Also tried the version of oscmax before the latest, same issues...

I'll keep looking into it myself to try and find a fix...

[kris7845]

Originally Posted by ericgtp313

Well, still getting the sql errors as the people above, the 1054 error, s.specials_id column.

I'm not sure what info I could give that would help debug for anybody, but heres everything relevant: PHP 4.3.9., mysql 4.1.20, centOS, apache 2.0.52, oscmax latest version, multi-stores latest version with all patches from this thread. Also tried the version of oscmax before the latest, same issues...

I'll keep looking into it myself to try and find a fix...

I will work on a fresh install and figure out which files i fixed to get it working. I will update with more info

[kris7845]

k, i installed a fresh copy of oscmax, overlayed the mutli shop and imported the database and then copied over the fix files. Like you i got the error again. I checked to see if my test shop was still working (both were tied into the same database) and it got the error too so i imported my backup and it fixed the problem.

You can download my test shop's database which can be found

http://www.consolerepairguides.com/oscmax/oscmax.zip

you will need to install the oscmax, then copy the original mutlishop mod files over, then copy over the fix files. once all the files are in place go to phpmyadmin (or whichever DB app you use) and drop all your tables, then import the oscmax.sql database in it.

There are three test porducts and three test "stores" in this database for you to play around with. Also it is worth noting that when you create a new store the table it creates does not contain all the configuration info for your shop, get around this by exporting the table in phpmyadmin, open it up in wordpad and change the

CREATE TABLE `XXX` (

to whatever you want your new stores's configruation file to be. Save and import the table into your database.

Lemme know if you run into any other problems

[kris7845]

After re-reading my previous post let me revise (this forum needs an edit button) the configuration part so it is easier to understand. Export your configuration table, make the edits and add to the last line

(1201, 'Stores ID', 'STORES_ID', 'XxX', 'The id of my store', 6, 0, NULL, '2007-08-14 21:38:25', NULL, NULL);

where XxX should be the number of your store.

save it, import it and then once the new store files are copied be sure to edit the TABLE_CATEGORIES in the database_tables.php file.

hopefully i didnt forget anything....

[ericgtp313]

well that worked perfectly, but now after logging in as a user that is part of the wholesalers group and going to a product, i get the following error:

PHP Code:

1054 - Unknown column 'oscmax.s2s.customers_group_id' in 'on  clause'

select p.products_id, pd.products_name,  IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price,  p.products_price) as products_price, p.products_tax_class_id, p.products_image,  s.specials_new_products_price from products p, products_description pd, specials  s LEFT JOIN products_groups pg, products_to_stores p2s, specials_to_stores s2s  using (products_id, customers_group_id) where p.products_status = '1' and  p.products_id = s.products_id and pd.products_id = s.products_id and  pd.language_id = p2s.products_id and p2s.stores_id = '1' and s2s.stores_id = '1'  and s.specials_id = s2s.specials_id and pd.language_id = '1' and s.status = '1'  and s.customers_group_id= '1' order by s.specials_date_added desc limit  10

[TEP STOP] 


I'm guessing this has something to do with the seperate pricing mod and not the multi-stores...so this is probably the wrong thread for it.

Also, when i try to check out when logged in as a wholesale user, i get this:

PHP Code:

Fatal error: Call to undefined function: get_shiptotal() in  /var/www/websites/oscmax/catalog/includes/classes/shipping.php  on line 22 


Not sure why thats happening either....

But, the fixes above worked fine for the other problems, so thank you very much for that

[kris7845]

hmmm, I am not sure what the problem could be there. I really have never used the wholesale part of oscmax so i dont know where to start with that one. I was able to get a few errors of my own when testing with a wholesale test account but which file the problem is in i couldnt find it.

does it work like normal when the customer is retail?

The function your getting an error from is a part of the shopping_cart.php class, i wouldn't doubt that this mod is causing the hiccup. I will see if i can track down the problems if i have some spare time tonight.

[ericgtp313]

Yeah, the shop works flawlessly when im not logged in, or when logged in as a regular retail user.

[ericgtp313]

Oh and thank you also, any help is appreciated. I have a regular osc running with multi-stores and vendor pricing, but to be able to have oscmax with both of those working would be awesome...

[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