Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multi-Stores Multiple Shops Support


hobbzilla

Recommended Posts

Is ist now possible to create shop without copying the whole catalog to a new directory ?

Yes, with a little tweaking here and there, this could be done (fairly easy I would think). But, until template support is finalized, all shops would look the same. Also unless you were a mod_rewrite king, you might have some trouble with multiple SSL & domain names.

 

I personally will not be taking the multi-stores contrib that route. Feel free to change the code and re-submit it as a new contribution that allows for a "store_id=store_2" type implementation.

Link to comment
Share on other sites

Hi,

 

It's been a while since I looked at using this contribution. Unfortunately, I found the contribution well after I had added my own "hack" to have 3 domains on the one website.

 

Now for a simple question, can I have 3 domains on the one website by using this contribution. Here is what happens now:

 

1. Page titles are different (different company name,etc)

2. Some content is different

3. Contact (email) form shows different names,address, emails,etc

 

Thanks,

 

Peter

Link to comment
Share on other sites

Peter,

 

Perhaps it is just too early in the morning for me.. but I never found a question in your post! :) Are you asking if M-S will allow you to do those things, if so, the answer is "yes".

 

-Ryan

Link to comment
Share on other sites

Hi Ryan,

 

Have you have a chance to figure the (only) particular admin has access to their store?s products? It would be very nice and safe. Currently, every admin from each store has access to all products administration area. I wish to have each different admin to control their own products only, and main central admin (big boss, its me :D ) will able to manage all stores.

 

Please let me know if you update for it.

 

Thank you again for the great contribution.

 

Serial

Everything is possible.

Link to comment
Share on other sites

Hi Ryan,

 

Perhaps it is just too early in the morning for me.. but I never found a question in your post!

 

Well, it was possibly a bit hidden .........

 

can I have 3 domains on the one website by using this contribution.

 

That's good that M-S will do those things. Now for some harder questions ....... :D

 

1. Does M-S have a 'feature' to dump all the products/categories for the "current" store into the other stores ?

 

2. I realise M-S enables you to have different products for each store. What about other 'store' content, like the text that appears on the main page (index.php) ??

 

Thanks,

 

Peter

Link to comment
Share on other sites

1. Does M-S have a 'feature' to dump all the products/categories for the "current" store into the other stores ?

 

All stores share the same database. The only thing that is different is the configuration table. Each store has it's own.

 

2. I realise M-S enables you to have different products for each store. What about other 'store' content, like the text that appears on the main page (index.php) ??

M-S is not a template system. That being said, yes you can have different content for each store. Basically due to the fact you are replicating one store's installation for 'x' number of stores.

Link to comment
Share on other sites

Hi,

 

1. Does M-S have a 'feature' to dump all the products/categories for the "current" store into the other stores ?

 

All stores share the same database.  The only thing that is different is the configuration table. Each store has it's own.

 

Okay, no actual dump function. When you say the only thing different is the config. table, it would appear from the SQL code, these 3 tables:

 

* products_to_stores

* categories_to_stores

* manufacturers_to_stores

 

would actually imply that you can have different products in each store, in fact each store can have its' own products, categories and manufacturers (which are all tied to products in one sense anyway). Therefore, it is more than the configuration table that is different, is it not ??

 

I can see that a 'website' may have (say) 107 products, and for my situation (3 domains on the one website), we might have:

 

53 products in store A

42 products in store B

22 products in store C

 

as store B may have 10 products sold that are also sold in either store A or C. I can see by the SQL code that the contribution is quite flexible, you simply setup ALL your products as normal, and then assign a product (category/manufacturer) to a store.

 

I'm just trying to get a handle on whether this contrib. will suit our needs. We don't have 3 stores as such, but have 3 domains by parking the other 2 on top of the 'main' domain.

 

I notice the stores tbale has 'stores_url', so that would be handy. It's rather 'messy' the way I have to handle it now, but it does work, no crashes. I just have to check what domain a visitor is using and then set about 10 constants, then use those throughout osCommerce, and especially use the 'language_id" so that we can have different page content for each domain.

 

M-S is not a template system. That being said, yes you can have different content for each store.  Basically due to the fact you are replicating one store's installation for 'x' number of stores.

 

Okay. One of the files often changed is of course:

 

/catalog/includes/languages/english/index.php

 

which changes the main page content. No doubt there are a number of constants to use from this contrib. to change content, based on store, for example STORES_ID.

 

Thanks for your help,

 

Peter

Link to comment
Share on other sites

Hello people

I have being reading this thread for a while, but I would like to see one of the virtual mall implemented to see waht it looks like.

Can someone please post here a link so that I can see it?

Thank you very much

fborot

Link to comment
Share on other sites

Can someone please post here a link so that I can see it?

Super great contribution for running a b2b wholesale business. See this demo of one B2B use of the MASTER ADMIN as the main WHOLESALE SOURCE. Notice the many wholesale categories source in this MASTER.

 

Then see this vendor store who pull out only a specific category of Feng Shui Products from the master wholesale source mentioned above.

 

This only demonstrate one of the few wholesale business application concept which this contribution could do. To see the real power, I would suggest you to install it with no hesitation.

 

Take this opportunity to express my heartfelt thanks once again for the author's generous to offer this SUPERB business class scripts FREE for everyone on this community :) Although the author has indicated not expecting any donation, I would suggest everyone who has enjoyed this remember to make a donation to express our thanks, and further support the author's continuous development on this.

Link to comment
Share on other sites

Last question

 

I am going to install it right away. I guess it si better to start with OSC

MS2, vanilla installation and then install the contribution. Is the install.txt file in the zip file enough to serve as a guide?

thank you

fborot

Link to comment
Share on other sites

I am going to install it right away. I guess it si better to start with OSC

MS2, vanilla installation and then install the contribution. Is the install.txt file in the zip file enough to serve as a guide?

Basically, yes! Assuming you have the experience to install an oscommerce, with all steps of CHMOD!

 

remember:

 

1. choose database session during oscommerce. You would encounter this in the first few steps during installation.

 

2. run the attached update.sql in phpMyAdmin

 

that's it.

 

enjoy :lol:

Link to comment
Share on other sites

  • 1 month later...

Hi,

 

I have recently downloaded version 1.4 of this contribution.

 

We want to have two stores, to be used like this:

 

1. http://example.com/shop (retail store)

 

2. http://example.com/wholesale

 

I have used the sql code, and the extra tables have been loaded okay. I gather by the docs on this, that to have 2 stores like explained above, we will also need to have a seperate 'configuration' table, that is, simply export the current configuration table data, create a new table for wholesale, call it something like "wh_configuration" or "configuration_wh", and then import the config data.

 

Then, I _think_, we will be able to add another store. Looking at the sql code, I assume the constant STORES_ID can be used to check whether the current store is 'store id=1' or 'store id=2', once we have the two stores setup ??

 

Not having dug deep into the code yet, how is the STORES_ID set ? Obviously, by a qry to the correct 'config' table, but is the store "tied into" a URL, as I see the STORES table has a URL. This is the method we need to use, a 'store' will be, by default, defined by the URL/URI (the access/path).

 

Unfortunately, the site is MS-1, so I think I'm going to have to "line up" the MS-2 code with this contribution, to see where the modifications need to be inserted/replaced into the MS-1 code. This is because there is actually quite a difference in the osC code between MS-1 and MS-2.

 

Can I be 100% certain that ALL the modifications in version 1.4 of this contribution have:

 

1. The following for blocks of new code:

 

//rmh 12/09/2003 multi-stores

 

2. The following for line changes:

 

define('TEXT_INFO_HEADING_CATEGORY_TO_STORE', 'Category to Store'); //rmh 12/09/2003 multi-stores

 

Thanks, :)

 

Peter

Link to comment
Share on other sites

Hi,

 

I assume by needing to have the 2 stores as such:

 

1. http://example.com/shop (retail store)

 

2. http://example.com/wholesale

 

then this line in database_tables.php

 

  define('TABLE_CONFIGURATION', 'configuration');

 

would be as above for 'store 1' (retail), and:

 

  define('TABLE_CONFIGURATION', 'config_wholesale');

 

for 'store 2' (wholesale), assuming we call the configuration table for the wholesale store "config_wholesale".

 

Then if we wanted to do any specific functionality within a particular 'store', a simple check for the PHP constant STORE_ID would suffice.

 

That seems to be how the contribution works. :)

 

Thanks,

 

Peter

Link to comment
Share on other sites

Then if we wanted to do any specific functionality within a particular 'store', a simple check for the PHP constant STORE_ID would suffice.

 

That seems to be how the contribution works.  :)

 

That is about it. STORES_ID is a database configuration value that cooresponds to the stores_id in the stores table. It is read in and defined in application_top.php.

 

So, in any contribution you plan on integrating with M-S that needs seperate values for each store, yes you would use the STORES_ID definition.

 

Honestly, the codebase for v.1.4 is pretty ancient and has some bugs and missing features. I will port my 1.6 Loaded (since removed) into (hopefully) a complaint contribution as soon as some spare time pops up .... I do not have an estimated time table for this.

 

-Ryan

Edited by hobbzilla
Link to comment
Share on other sites

Now I found my error - forgot to change the settings of "config.php" in the new catalog-directory (thought I made this)...

 

But now:

 

How can I add Products ?

In my default shop are categories and products - in the new shop there is nothing.

 

Further I have an error message in admin/catalog section here BOX_CATALOG_PRODUCTS_PRICE_SCHEDULES:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_ROW_LISTS_OPTIONS' at line 1

 

select pps.* from products_price_schedules pps left join products_description pd on pps.products_id = pd.products_id and pd.language_id = '2' order by pps.products_price_schedules_id LIMIT 0, MAX_ROW_LISTS_OPTIONS

 

[TEP STOP]

Edited by runweb

OSC Webmakers Edition modiefied with many other contribs and enhancements.

+ STS 4.5.7 for 2.2MS2 and RC1

Link to comment
Share on other sites

Hello Ryan and everyone,

 

I was able to setup three stores successfully. Only assigned products are displayed in each particular store in user mod.

 

However, admins are able to view "all" products by login to any store. I want Admin for the store #1 to be able see and edit only the products assigned to store #1.

 

What did I do wrong? How do I correct it?

 

Please help.

 

Thank you.

Edited by Serial

Everything is possible.

Link to comment
Share on other sites

  • 1 month later...

Hi,

I have installed the contribution for multiple stores; http://www.oscommerce.com/community/contri...ns,1730/page,21

no problem with installation - but now I am stuck: how does it work to "show" the let's say second store?

I have a large "default store" that shows of course on the front page - but I don't know where to create what for the second store to show.

I created a category in the second store - but how do I get products/images in to it - all there is right now is to manually add a single item, one by one.

I use easy populate for the main store - but it only perteains to the main store.

I tried to show one existing category from the default store in the 2nd store - but absolutely nothing shows up on the front page.

So - I assume the 2nd store has to have it's own directory - and if so, what all does have to be in that directory for store 2 to function identical as default store functions?

 

Greatly appreciate any help.

There is zero documentation for this and no sample url either where I could look at.

Link to comment
Share on other sites

  • 2 weeks later...

This thread has been cleaned up to match the versions available at the Contributions section.

 

v1.5 and v1.6 of the MultiStore contribution was heading in a direction in becoming more of a project fork than a contribution and have been removed from the Contributions section. The support questions relating to these versions have also been removed from this thread due to the forum rules stateing that all works discussed in the forums must be available at the Contributions section.

 

This is somewhat of a spaghetti mess which will be cleared up with Ryans upcoming v1.7 release of his work returning to a normal contribution status.

 

We apologize for the inconveniences caused in having disabled v1.5 and v1.6 of the contribution and for removing its relevant support postings in this thread.

 

We will remain in contact with Ryan during the release of his next version to solve any remaining issues, and to make sure the transition to v1.7 goes smoothly for everyone involved.

 

We'd like to thank Ryan for his dedication to this contribution and for returning it to a normal contribution status!

:heart:, osCommerce

Link to comment
Share on other sites

:o :o :o :angry:

 

I don't get it... We don't care if MultiStore is becoming a fork or a spoon or whatever, we are trying to use it and want some answers to our questions. If the developers cannot give one right now, maybe some other user could. But now our postings are deleted and we are not allowed to talk about it anywhere in this forum! :x at least until v1.7 is released (when?) and then write again our postings...

Excuse me, but I don't see much logic in this!

Link to comment
Share on other sites

There isn?t much logic here, the editing effectively eliminated everything from the point before 1.5 came out to today, which I think it has been poorly done and again without respecting the user community who greatly depend on this forum. Some of these questions were related to the 1.4 version and new users who have no clue what happened or really care about the problems with the different versions.

 

But since it is their rules and their product, it does not matter. All I can say is don?t stop using or supporting osCommerce and their team and all the people who give us great

 

 

:o  :o  :o  :angry:

 

I don't get it... We don't care if MultiStore is becoming a fork or a spoon or whatever, we are trying to use it and want some answers to our questions. If the developers cannot give one right now, maybe some other user could.  But now our postings are deleted and we are not allowed to talk about it anywhere in this forum! :x at least until v1.7 is released (when?) and then write again our postings...

Excuse me, but I don't see much logic in this!

Link to comment
Share on other sites

It is unfortunate that actions had to happen at such a late stage in having to remove two contribution versions (v1.5 and v1.6). We do apologize for the inconveniences caused, however support for project forks are not to be provided on these forums.

 

We do appreciate Ryans continuing efforts despite this setback.

:heart:, osCommerce

Link to comment
Share on other sites

For the record I just want to let the community members know that I appreciate their support and patience on this contribution. Hopefully when v1.7 is released, things can go back to normal. I hope to have v1.7 released by Jan 1 2005.

 

Although, I do not support the decision by Harald & other members of the dev team regarding this contribution as a project fork, or taking the prior mentioned versions down from the contribution section, or removing (or hiding) this support thread (twice at the time of this writing), or locking my user account from posting privileges, and now removing an entire sequence of support related material... supporting osCommerce and continuing to develop contributions for the platform remains my focus. Alternatives such as leaving to join a similar project or community, or even dropping all my contribution development altogether (which ironically would simplify my life), are premature. Unless I am blinded in ignorance, most contribution authors are not developing to make themselves independently wealthy. They do it to give back to the community and to support a project that they love.

 

In my opinion, all of these actions wreak of censorship and do a dis-service to the osCommunity -- that without osCommerce would have no purpose.

 

So therefore, I implore all community members to continue to support osCommerce, continue to support (answer questions, send $ donations, create contributions, etc.) the dev Team as well as 3rd party contribution authors. But, more importantly, voice your concerns & opnions regarding the issues you believe in.. otherwise the dev Team may never know the real voice of the community.

Edited by hobbzilla
Link to comment
Share on other sites

I believe it is a fork when:

 

A ) you declare it a fork.

or

B ) the dev Team declares it a fork.

 

I got stuck in case B. And yes there are other osCommerce forks out there besides those that you have mentioned. It is sad to say, I really would like to mention them as they may benefit some that read this, but with my luck, I write such a message and get flagged for immediate account deactivation. :P

 

Anyway, those that you mentioned are not allowed to be discussed or supported on this forum.

Edited by hobbzilla
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...