Jump to content
hobbzilla

Multi-Stores Multiple Shops Support

Recommended Posts

i got it sort of 'up and running' but from the /admin/index.php he won't change the data.

I am assuming "he" is a customer of yours? I'm sorry this statement confuses me...

 

when i select one shop (i got 3 in all) from the dropdown menu. the output always stays the same, no matter which one i choose.

When you select a store to configure from the dropdown menu in the admin on the index page? The output in configuration always stays the same?? or the output on each store (catalog side) always stays the same? Can you verify that if you have 3 different config tables and each is named a different store name, etc. that those different names display under admin->configuration->my store ??? Have you double checked each of the catalog's include/database_tables.php to make sure you are defining the right config table for each store? (they should be different for each catalog).

Share this post


Link to post
Share on other sites

You should utilize a comparison utiltiy such as diff or beyond compare, etc. and look at your files before inserting this contrib and after. Also, looking at the diff between the MS2 stock version and the MS2-modified contrib file.

 

If you are going to be incorporating contribs and/or making updates to your codebase, a good diff program is worth it's weight in gold! I'm serious spend the $40 or so... you won't regret it.

Share this post


Link to post
Share on other sites

I am assuming "he" is a customer of yours? I'm sorry this statement confuses me...

 

sorry ryan, he is supposed to be the script ;-)

 

When you select a store to configure from the dropdown menu in the admin on the index page? The output in configuration always stays the same??

 

yes, i'm afraid, it does :(

 

or the output on each store (catalog side) always stays the same? 

 

they do change, but for some reason the categories differ when i change the language

 

Can you verify that if you have 3 different config tables and each is named a different store name, etc. that those different names display under admin->configuration->my store ???

 

yes, i can confirm that i have 3 different ones, but they dont change under admin->configuration->my store

 

Have you double checked each of the catalog's include/database_tables.php to make sure you are defining the right config table for each store? (they should be different for each catalog).

 

yes, i did that several times :(

 

can i send you the link to admin in a pm?


... in the end, it will work

Share this post


Link to post
Share on other sites
You should utilize a comparison utiltiy such as diff or beyond compare, etc. and look at your files before inserting this contrib and after.  Also, looking at the diff between the MS2 stock version and the MS2-modified contrib file.

 

If you are going to be incorporating contribs and/or making updates to your codebase, a good diff program is worth it's weight in gold! I'm serious spend the $40 or so... you won't regret it.

 

good thought, but i had it installed on a fresh out of the box MS2 :rolleyes:


... in the end, it will work

Share this post


Link to post
Share on other sites

Hi all

 

I am working with OCS 2.2 ms2 with multi shop and access levels mod?s installed, and all is going well until I installed CCCVV_ISSUE_START Selectable with card blacklist mod, so I can take uk CC cards

 

It all seems to work fine when gathering the CC details cvv numbers cc number issue etc during the order process, and the info is on the db. But when I go to admin to view the orders there is nothing there!! I have read thought the CCCVV_ISSUE_START Selectable with card blacklist forum and found only that its good to try and reinstall the mod in payment modals thought admin. I have done this a couple of time but still have not managed to see any orders.

 

My only guess was that the multi shop mod is effecting the way that the orders are displayed which conflicts with the CC mod but not having great coding skills am having treble isolating the problem and making a solution.

 

If there is anyone out there that is running CCCVV_ISSUE_START Selectable with card blacklist with multi shop and got it working or feels like they could help me solve this problem that would be cool, or just someone with an idea.

 

Thanks


Richard

Share this post


Link to post
Share on other sites

Will this mod allow you to see all the differnt stores available from a main page? Is it possible for the shopper to see all orders centrally regardless of where they placed the order from? I know there is no central store but I really need for the shopper to be able to see all orders globally.

 

I guess more than anythign what I need is a mod that lists the items in the cart by the vendor and also calculates shipping per individual vendor set in the cart. However too busy unfortunately to deeply think on this

Edited by bluephoenix

"If you rundown your shadow, you will never catch it"

Bob Marley

Share this post


Link to post
Share on other sites

I'm in the same situation. I need to offer free standard shipping within the UK on dvds and but charge for delivery of weapons because they go direct by courier. It doesn't seem that complicated but I can't work it out. :(

Share this post


Link to post
Share on other sites
Will this mod allow you to see all the differnt stores available from a main page? Is it possible for the shopper to see all orders centrally regardless of where they placed the order from? I know there is no central store but I really need for the shopper to be able to see all orders globally.

 

I guess more than anythign what I need is a mod that lists the items in the cart by the vendor and also calculates shipping per individual vendor set in the cart. However too busy unfortunately to deeply think on this

You can change the order history to not pull orders where the orders_stores_id is STORES_ID. That would then pull all orders by that customer regardless of which store the order was placed.

 

Also, this mod does not have a combined cart for all the stores (ie. shipping & taxes, etc. per line item) rather it is just a seperate installation of the catalog for each store where the items are all being pulled from the same database (same with customer, etc. etc) and 1 admin can see all the orders from the various sites at one location.

 

HTH

Share this post


Link to post
Share on other sites
I'm in the same situation. I need to offer free standard shipping within the UK on dvds and but charge for delivery of weapons because they go direct by courier. It doesn't seem that complicated but I can't work it out. :(

A possible fix might be to have the shipping tare weight equal to 0 and all the dvd's weigh zero. And at checkout if the shipping weight is zero, select (or show) the free shipping (FLAT RATE SHIPPING) option.

 

Otherwise on weapons there would be a weight and it would be calculated at checkout and the shipping charges would only be calculated on the weight of the weapon (if using weight based shipping courier) or you could use a flat rate again but charging on this flat rate instead of having it 0.

 

HTH.

Share this post


Link to post
Share on other sites

Thanks for the idea. It would probebly work if I just shipped domestically. I'm trying to pluck up courage to try the Enhanced Multi Vendor Shipping Contribution. It seems as if it might be the answer :unsure:

Share this post


Link to post
Share on other sites

OK, what am I doing wrong?

 

I just set up 2 dummy stores, to try this Contribution out. Followed the instructions to the letter. It wasn't working, so I started from scratch again, same results.

 

Here's the deal:

 

Whenever I assign "Store 1" to a category, that category appears in all stores. If any given category is NOT assigned to "Store 1," it does not appear in ANY store.

 

It would appear to me that the "Store 1" is simply a moniker for weather or not a category is visible. Chosing "Store 3" or "Store 9" or "Every Store Except for 1" simply 'shuts off" that category in ALL stores.

 

Alternatively, selecting any store except for "Store 1," does nothing.

 

So, basically, after all this rambling.... Selecting "Store 1" turns a category on in ALL stores. NOT selecting "Store 1" turns it off in ALL stores. Selecting "Store 1+n" has absolutely no effect at all in any way.

 

:blink:

 

This seems not what the author intends. Why?

Share this post


Link to post
Share on other sites

Hi there,

 

Is that possible to redirect the user to one particular store for checkout so that you don't have to buy SSL certificates for each store?

Thanks in advance.

 

Regards,

 

Jerry

Share this post


Link to post
Share on other sites
Hi Hobbzill,

 

thanks for the reply, it would seem that i probably won't be able to use this with Barclays Epdq as the Barclays end of the configuration allows for only 1 Allowed URL to make the call to their processing page :(

 

Cheers

 

stubbsy

I made ePDQ work for multi-currency

[*Edit* - Good! Please contribute it to the community - Matti]

Edited by Johnson

Share this post


Link to post
Share on other sites

Hi Guys,

 

I seem to have the contrib working but I need to have the same product on two stores at a different price, on for general public and one for employees at a discount.

 

Every time I add a special and try to assign it to a store it comes up on both sotres no matter what I select. I thought maybe its because specials.php isnt updated to make a check fot specials_to_stock?

 

// Sets the status of a special product
 function tep_set_specials_status($specials_id, $status) {
   return tep_db_query("update " . TABLE_SPECIALS . " set status = '" . $status . "', date_status_change = now() where specials_id = '" . (int)$specials_id . "'");
 }

////
// Auto expire products on special
 function tep_expire_specials() {
   $specials_query = tep_db_query("select specials_id from " . TABLE_SPECIALS . " where status = '1' and now() >= expires_date and expires_date > 0");
   if (tep_db_num_rows($specials_query)) {
     while ($specials = tep_db_fetch_array($specials_query)) {
       tep_set_specials_status($specials['specials_id'], '0');
     }
   }
 }

 

Any help would be much apreciated.

 

Cheers

Stot

Share this post


Link to post
Share on other sites
Hi Guys,

 

I seem to have the contrib working but I need to have the same product on two stores at a different price, on for general public and one for employees at a discount.

 

Every time I add a special and try to assign it to a store it comes up on both sotres no matter what I select.  I thought maybe its because specials.php isnt updated to make a check fot specials_to_stock?

 

// Sets the status of a special product
?function tep_set_specials_status($specials_id, $status) {
? ?return tep_db_query("update " . TABLE_SPECIALS . " set status = '" . $status . "', date_status_change = now() where specials_id = '" . (int)$specials_id . "'");
?}

////
// Auto expire products on special
?function tep_expire_specials() {
? ?$specials_query = tep_db_query("select specials_id from " . TABLE_SPECIALS . " where status = '1' and now() >= expires_date and expires_date > 0");
? ?if (tep_db_num_rows($specials_query)) {
? ? ?while ($specials = tep_db_fetch_array($specials_query)) {
? ? ? ?tep_set_specials_status($specials['specials_id'], '0');
? ? ?}
? ?}
?}

 

Any help would be much apreciated.

 

Cheers

Stot

 

I will have to look into your problem with assigning the specials to specific stores.. I thought I had that worked out. Anyway I had to do something similar to what you are needing and I solved this delima not by tweaking the multi-stores contrib but by incorporating another contrib where you can assign customer classes and then have various price levels for each customer class.

 

Perhaps that would work for you too!

 

http://www.oscommerce.com/community/contributions,1673

Edited by hobbzilla

Share this post


Link to post
Share on other sites

Hi,

 

Thanks for your reply. I took a look thru the specials.php code in the catalog/ directory and it looks like that is where it should be doing the check for if it is added to a store, its a hella long argument though :huh: and I didnt get my head round it yet.

 

Unfortunately that contrib wont work for what I need, theres no set discount on any of the items. I may be able to put it to some use though as certain other customers do get a 50% discount. :ph34r:

 

Ill take another look at them args in specials.php, looking at the sql its adding all the correct information into the database on admin side just picking it out wrong on the catalog side.

 

Cheers

Stot

Share this post


Link to post
Share on other sites

Ok making progress.. the argument in Specials.php in catalog/ IS doing what its supposed to, This is the info box at the right of the main page that shows speciails on your store.

 

There must be an argument in the info boxes etc that checks for specials too, off I search. :D

 

Cya

Stot

Share this post


Link to post
Share on other sites

looking thru this it looks like the '$listing_sql' queiry isnt taking the specials to stores status into account in index.php and probably also in products_new.php, product_info.php, and maybe even all the way to checkout. hunt hunt hunt

 

Cya

Stot

Share this post


Link to post
Share on other sites

Did you get a chance to look at this at all hobbzilla? Im sure all it needs is an if else statment for that sql query but as i dont really know php ( although I can follow it ) dont know exactly how to go about this :unsure:

 

Cya

Stot

Share this post


Link to post
Share on other sites
I was thinking about moving the image folder outside the stores, so there would be only one image folder, and adjusting the path in the configure files.

But my tries didn?t work yet. So before going on with that, just let me know if this is a waste of time or not...

 

Another try was setting up a seperate admin fodler in each of the stores, but that get's confusing after a while... (what happens if you suddenly start to edit the files of another store? and I guess there will just be no way to hide on admin section from another...?)

 

Anyway: It is still one of the best contribs and I?m having a lot of fun with it (this is not cynical!!!). Hope you are going to develpoe it even further!

 

Ciao, Robert

This i believe is a vital issue because everyone knows how annoying duplicates are.. no one really has space to afford unneccessary duplicates.

 

I was able to forward all image requests to one image folder by changing the html_output.php function file from:

 

// alt is added to the img tag even if it is null to prevent browsers from outputting
// the image filename as default
   $image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"';

 

To this:

 

// alt is added to the img tag even if it is null to prevent browsers from outputting
// the image filename as default
   $image = '<img src="/catalog/' . $src . '" border="0" alt="' . tep_output_string($alt) . '"';

 

And this will grab all images from the images folder in your main catalog.

Share this post


Link to post
Share on other sites

Hello,

 

I'm really liking this contribution have got it all up and running like a dream - just wandering if anyone could help me with something?

 

I have the featured products contribution installed and could just do with a hand with the SQL (as im not very good at it !)

 

I just want the following code to just call the featured products in its own shop

$featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);

and

$featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);

 

Any help greatly aprieciated

 

Thanks

 

Sam :D


Knowledge is knowing that a tomato is a fruit, wisdom is not putting one in a fruit salad :D

Share this post


Link to post
Share on other sites

Thank you Ryan.

 

I finally had it work for total two stores yesterday.

 

Today, I added one more store. Now, I have total three stores.

 

The main first store is showing only the assigned products. It is fine.

 

I just found out that the last two stores are showing the same exact products regardless of whatever I chose.

 

Why the ertra two stores showing all the products?

 

I just copied, pasted and replaced the existing store files and configuration table db.

 

What could be the problem? I really want to assign different products to each store.

 

Thank you.


Everything is possible.

Share this post


Link to post
Share on other sites

Hi Ryan or anyone,

 

Its me again...

 

Each store has an unique Store ID.

 

Why are both of these additional 2nd and 3rd stores showing All ENTIRE products from all the store? Why?

 

I followed the installation guide.

 

Please advise me, what else could be wrong?

 

 

Thank you.


Everything is possible.

Share this post


Link to post
Share on other sites

Have you changed the database_tables.php found in catalog/includes and catalogue/admin/includes in the other two stores? Each one needs to have the following changed to match the name you gave the stores in the Admin/stores config panel.

 

  define('TABLE_CONFIGURATION', 'configuration');

 

eg, if you created a second store in admin called 'mystore2' the code would read

 

  define('TABLE_CONFIGURATION', 'mystore2');

 

You need to change that for each store you create.

 

Cya

Stot

Share this post


Link to post
Share on other sites

Hi Stot, thank you for your advice.

 

The database tables setup is same as the installation guide. I have the seperate configuration tables (ie: configuration, configuration_store1, configuration_store2). They all have their unique store id.

 

What else should I need to change? The paths in the congif.php(s) has also been changed. (Other than that, all the files in these two stores are the same because I just copied it from the initial one.)

 

* Each additional stores also has "Multiple Admin Levels" feature installed. I am not sure if this effect to any file. (any info?)

 

Why are they both showing all the products from the database?

 

I do appreciate your time. Please help me.

 

Thank you.

Edited by Serial

Everything is possible.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×