Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 7 votes

Multi-Stores Multiple Shops Support


  • You cannot reply to this topic
1538 replies to this topic

#41 jimmyanoyo

  • Community Member
  • 53 posts
  • Real Name:Jimmy Lee

Posted 28 January 2004, 05:41

Hi.

I am kinda confused with the installation.

Currently this is the directories what I have

www.domain.com/shop/admin
www.domain.com/shop/catalog
www.domain.com/shop/catalog1

I uploaded the script with the contributions installed.

I executed the update.sql in the contribution
I created a table 1_configuration and inserted the values into the table.

I created 2 stores name using the admin.

What else to I need to set inorder to make the site work. Anything else I need to do?

Edited by jimmyanoyo, 28 January 2004, 05:42.


#42 jme751

  • Community Member
  • 6 posts
  • Real Name:Jamie Kiefner

Posted 28 January 2004, 05:55

I was also wondering if there is a way to separate the accounts so a person who creates an account on one store would have to recreate it on another?
thnx
jamie

#43 jimmyanoyo

  • Community Member
  • 53 posts
  • Real Name:Jimmy Lee

Posted 28 January 2004, 14:31

Well. I think I got everything right and the store works. But one problem is that shopping cart will display the products from 2 different shop once you sign in.
How can you fix this problem? I checked the /classes/shopping cart.php and everything seems to be fine.

#44 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 14:38

hotnuts21, on Jan 20 2004, 12:17 PM, said:

The one admin to manage all stores sounds like a good idea :) Any idea when this will be ready?
I am right in the middle of making another contrib (Address Book Enhancer - shipping line 2 & phone & fax for address locations as well as a nickname for that entry) and will begin work on these added features next.

So in short.. perhaps a few days to a week.

#45 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 14:45

F1Peace, on Jan 20 2004, 06:29 PM, said:

When I create products and categories in any of the other stores, if I also assign them to Main Mall, they will show up on the home page of the mall (What's New - New Products etc.). Otherwise they only show on that particular store.

See the possibilities?
I think I have decided my course of action on the admin side of things so one admin can control (not only the catalog of products and categories and what store they are assigned to.. that already works) all of the stores configuration by not hardcoding the table definition in database_tables.php but using a drop down similar to the language selector.

It is perhaps easier explained by:
www.domain.com/catalog1 & www.domain.com/catalog1/admin
www.domain.com/catalog2 & www.domain.com/catalog2/admin

whereas in the not too distant future it will be:
www.domain.com/catalog1 & www.domain.com/catalog1/SUPER_admin
www.domain.com/catalog2 & www.domain.com/catalog2/puny_admin

A few things thing to note is that you..
.. don't have to use the same domain.com as long as the sites both have access to the mysql server they can be different domains, on the same localhost OR different machines altogether!

Also, if you are creative with how you name your categories you could have a MAIN MALL without having to assign each and every product to that main mall. Simply don't update any of the files with the ones from my contrib that have to do with displaying categories & products... and they will ALL be displayed. I liked this option better than creating a master store and having to have an if statement and then having 2 distinct sql statements.

HTH

#46 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 14:48

F1Peace, on Jan 22 2004, 05:37 PM, said:

For those who are having problems with insallation, I have created 3 sql files that should help you out.
Upload and install the files from the contrib and then simply use the modified sql files in the package I have prepared.
If you don't mind, please e-mail those files and I will look at them and add them to the install process for the next release.

#47 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 14:50

richjboyd, on Jan 27 2004, 05:32 PM, said:

Wold like to implement the Multi shop but only with one admin, so you are able to share products and customaries etc between the two shops but yet they are still very separate identities.

...

Anyone able to point me to a contribution or solution? Would be much appreciated.
You're here.

I am finalizing the one admin functionality later this week. But as it stands right now, you just described this contribution. The next step is to TRY IT and see if you think it will work for your situation.

#48 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 15:06

jme751, on Jan 27 2004, 11:39 PM, said:

Thanks for your contribution hobbs. I was wondering if there is a way to have different prices for products on different websites besides using the specials (i know i'm being way greedy, but i'd like to use those too)?
jamie

ps. congrats on the engagement....
Thanks for the congratulations!

First and foremost.. anything can be done!!

However, the simple answer is no. There is not an _easy_ way to do this. If you change the structure of products table too allow for multi much other contributions will break as well as you will have to then modify even MORE stock osc code as well as keep your eyes wide open for any contribution that you install.

You can always either create multiple products and assign them to different stores,
or use the specials ability. I doubt I will personally be adding different pricing per store into my mod. If someone wants to add that so be it. I just want to change as little as I have to from stock osc so other contribs continue to work with it.

However, if you are determined to do so, you could simply create an additional column in products_to_stores like products_stores_price decimal(15,4) NOT NULL,
and do some tweaking on the admin side so that you can specify which store to active the product at product creation or edit time (which I plan to do) but also include the text boxes along with the checkbox to indicate that stores price. If it is left blank it would default back to the default price. This would entail quite a bit of code changes on the catalog side as well.

#49 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 15:13

jme751, on Jan 27 2004, 11:55 PM, said:

I was also wondering if there is a way to separate the accounts so a person who creates an account on one store would have to recreate it on another?
thnx
jamie
Yes I believe this could be done rather simply by creating all the tables related to customers for each store.

i.e. customers_store2, customers_basket_store2, customers_basket_attributes_store2, customers_info_store2

and updating each store's table definition in database_tables.php.

NOTE: you will need to perform this mods alter statements on the udpdate customers tables as well or my contrib will break. Doing it this way though takes away the need for the stores_id alter statements anyway, as you now are not needing a customer check since they are seperated physically by table name. Also, this will pose another problem in the SUPER_admin (not so much in the puny_admin) in the next release.

#50 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 15:19

jimmyanoyo, on Jan 28 2004, 08:31 AM, said:

Well. I think I got everything right and the store works. But one problem is that shopping cart will display the products from 2 different shop once you sign in.
How can you fix this problem? I checked the /classes/shopping cart.php and everything seems to be fine.
Check all stores configuration tables and make sure that the STORES_ID aren't the same... and also that database_tables.php are pointing to the new tables for each new store.

FYI I will be making this option available under the My Store group instead of the hidden group in next release so it is easier to update in osc.

#51 jimmyanoyo

  • Community Member
  • 53 posts
  • Real Name:Jimmy Lee

Posted 28 January 2004, 15:19

I dont know if this is a bug or anything.

I added a product in store #1
the url is www.domain.com/shop/catalog
then I log into my account for checkout.

I type in the browser url www.domain.com/shop/catalog1
the product that I added in shop #1 will show up in the shopping cart of shop #2

Is this a bug? or I did somthing wrong?

#52 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 28 January 2004, 15:48

Jimmy,

I responded to your question about this. I have verified that when everything is set up correctly, the stores do not share shopping carts.
Do you have a site url so I could look at this?

I really think this is a configuration issue on your side.

#53 pmortlock

  • Community Member
  • 28 posts
  • Real Name:Paul Mortlock

Posted 02 February 2004, 02:31

thanks very much i got this working tonight, fantastic work thank you

#54 richjboyd

  • Community Member
  • 29 posts
  • Real Name:Richard
  • Location:UK

Posted 04 February 2004, 14:05

Hi ~Zilla

How’s the one Admin does all coming along, looking forward to it. I have a few questions about possible installation problems. I have read the forum and the installation instructions and looked at the files and it sounds like for installation you would like your contribution to go over a fresh installation of osc2.2.

This concerns me because the idea is that we are running one shop at the moment selling both Mac and Pc products and I would like to take the current data form this and split it into two shops, one with Mac products and one with Pc products and some products in both, some customers in one and some in the other and be able to admin them form one admin. I have spent quite a lot of time inputting the 200 plus products into the current mixed store and it would be good if I did not have to do this over again.

Would it just be a case of being able to modify the current database to take into account your update, making it possible to keep the current data like products, orders and customers.

Also we are running the Admin access levels contribution, will I be able to use this with the Multi Store one admin.

We would like to be able to do this within the next week or so, and we would not mind helping towards costs in finishing the solution which we are looking for.

Thank you for your help.
Richard

#55 jimmyanoyo

  • Community Member
  • 53 posts
  • Real Name:Jimmy Lee

Posted 04 February 2004, 14:15

Hi.

I am using MS1 release with contributions installed already. I dont want to upgrade to MS2, but I need to get this Multi-stores system to work. I am willing to pay a price if someone is able do it since I dont know how to program php. According to the programmer of this contribution, the multi-stores system should work on MS1 release.

Unless there is an easy way for me to upgrade MS1 to MS2 with the contributions I have installed on MS1!!??

#56 pmortlock

  • Community Member
  • 28 posts
  • Real Name:Paul Mortlock

Posted 04 February 2004, 14:48

if you run the sql and update your live database you can then just run another query to populate the store_id's by category number. using one configuration file for both stores is possible, by setting the store_id inside the page instead of loading from the control file. this might help with using one control panel to do all the admin but i will give it some more thought this afternoon.

#57 pmortlock

  • Community Member
  • 28 posts
  • Real Name:Paul Mortlock

Posted 04 February 2004, 14:51

jimmy how about listing your MS1 mods, getting them to work with MS2 would be good. then using this mod would be more feasible i think.

#58 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 04 February 2004, 17:02

richjboyd, on Feb 4 2004, 08:05 AM, said:

How’s the one Admin does all coming along, looking forward to it. I have a few questions about possible installation problems. I have read the forum and the installation instructions and looked at the files and it sounds like for installation you would like your contribution to go over a fresh installation of osc2.2.

This concerns me because the idea is that we are running one shop at the moment selling both Mac and Pc products and I would like to take the current data form this and split it into two shops, one with Mac products and one with Pc products and some products in both, some customers in one and some in the other and be able to admin them form one admin. I have spent quite a lot of time inputting the 200 plus products into the current mixed store and it would be good if I did not have to do this over again.

Would it just be a case of being able to modify the current database to take into account your update, making it possible to keep the current data like products, orders and customers.

Also we are running the Admin access levels contribution, will I be able to use this with the Multi Store one admin.

We would like to be able to do this within the next week or so, and we would not mind helping towards costs in finishing the solution which we are looking for.

Thank you for your help.
Richard,

The super admin is coming along nicely. It is being completed in my spare time so it is pretty touch and go. I feel like a lot of people are taking notice to this contrib and simpler installation instructions and handholding in the install guide are in order. You don't need to install this contrib over a vanilla MS2 (it is just easier that way). This contrib was written with MS2 in mind (and will be re-released with MS3 compatibility when finished also). Developers do not like to try and keep current with CVS as was the whole idea of the milestone releases. So, that being said, as long as you are using MS2 you can incorporate my mod by hand (searching for the keyword "multi-store" or by using a comparison editor (Beyond Compare is what I use).

AFAIK, you won't have a problem with the Admin access levels contrib (although it might not incorporate the access portion without your editing. I certainly can't release a version with each other contrib in mind .. so it might take some editing & php skill on your part.

In short, you should have no problem updating your current store so you don't have to re-input your product / customer / order data. But then again if you backup your DB there isn't a problem .. you can simple re-import them. If it were me, I would just modify your current store AFTER you back everything up.

#59 richjboyd

  • Community Member
  • 29 posts
  • Real Name:Richard
  • Location:UK

Posted 06 February 2004, 11:51

Quote

Richard,

The super admin is coming along nicely. It is being completed in my spare time so it is pretty touch and go. I feel like a lot of people are taking notice to this contrib and simpler installation instructions and handholding in the install guide are in order. You don't need to install this contrib over a vanilla MS2 (it is just easier that way)................

Thanks for the words of encouragement if dose sound posable I am going to start a couple of test sites and you are right as long as I back up there should be know probs, I may need some direction with the php but I will keep yous informed on how it goes.

Good luck with the super admin let us know now it goes.
:D
Richard

#60 hobbzilla

  • Community Member
  • 827 posts
  • Real Name:Ryan Hobbs
  • Gender:Male
  • Location:Texas, USA

Posted 06 February 2004, 19:41

Multi-Stores v1.2 has been released!

This includes the new super-admin functionality whereas one admin can rule all configuration for all stores. Much improved store database creation (option for table creation & population at store creation time). Please let me know what you think!

GET IT HERE

Updated Installation Instructions
Included manufacturers_to_stores ability
Added super-admin functionality
Fixed several bugs relating to cPath being shown when product wasn't enabled for store
Optimized display of boxes relating to products