Guest Posted October 30, 2002 Share Posted October 30, 2002 We are trying to cut down on the need for multiple instances of OSC on one server to run multiple shops. Is there any way to anyones knowledge to use a single version of OSC with some modification to the dbconnect info so that if I access the OSC dir from one virtual url and connect to a specific directory, the core functions of OSC will now only work with that DB. then if I access it from another virtual url and connect to another DB, the core OSC only uses that DB!? The main reason behind this is so that as we modify and adapt OSC and as new snapshots are released, we don't want to have to modify and update 2-3 different DIR's of core OSC code! I hope this kind of explains our issue. We are having some luck at the moment, but there are still issues. Cheers, Craig Link to comment Share on other sites More sharing options...
Ajeh Posted October 30, 2002 Share Posted October 30, 2002 Peek and see if this is something you are talking about: http://www.thewebmakerscorner.com/allstores.html This is several stores on either the same domain, different domain on same server or pointed domain. 1 MySQL database is used to control them all and one Admin. The Admin portion is password protected at this time. Link to comment Share on other sites More sharing options...
Guest Posted October 31, 2002 Share Posted October 31, 2002 Linda, You never cease to amaze me with your work. Is this a single OSC core with multiple DB's and a DB to controll them all? I also noticed that it would seem that you have given the option to share products between stores!? Looks good. Do you have controll over the look and feel for each store, or are they all going to have to look the same? Is there any way to get a look into the admin? I'd like to know what you are catering for here! If this is the way I think, is it available? We are currently trying to build 4 stores, but don't want to waste space on the webserver. Cheers Craig. Link to comment Share on other sites More sharing options...
Ajeh Posted October 31, 2002 Share Posted October 31, 2002 That is one MySQL for everything. The individual stores use their own code so that their look can later be customize. The products and categories are setup for what store they can appear on or a combination of stores. As long as the MySQL is accessible, then it can be shared. Basically I have this being shared by same domain with different directories, different domains but on the same server and pointed domain names that use different subdirectories. ie. One active domain with 5 pointed domain names all are technically the same domain, but the different subdirectories make it appear to be different domains. The things I am working on now for it are whether the Shop sets the shop id or the customer's login sets the shop id. Plus a way to turn the various shops into either a show case or show room where they display products but no prices or products w/prices but no purchasing etc. There are a few issues that need addressing in regards to payment modules and shipping modules as some may not want the same ones or they want their name and not the main store name etc. I have a lot to finish on this, but a lot has been completed so there is light at the end of the tunnel to bring this to a completed add-on. Link to comment Share on other sites More sharing options...
halstat Posted December 6, 2002 Share Posted December 6, 2002 Hi Linda: That multiple store concept is great and I like your "little froggy" on the admin error page! :D I was wondering if the site link below is something that would fit the multiple store idea or if it could be accomplished in a simpler manner. This is what I had in mind: http://www.esurg.com/app/home/Index My first level category list is up to 42 now and the list browsing becomes hard on the eyes. I like what they have done on the site above and would like to incorporate that into OScommerce. Thanks for any ideas you may have! Best Regards, Hal sitesnbytes.com Link to comment Share on other sites More sharing options...
Ajeh Posted December 7, 2002 Share Posted December 7, 2002 If I ever have time to get back to it ... :shock: This can handle a lot of different styles of shops. I just need to find time to do finish it so it is something others can use. Hopefully between the holidays I will get some time to get back on this and get an alpha release at least out. Link to comment Share on other sites More sharing options...
Guest Posted December 7, 2002 Share Posted December 7, 2002 If I ever have time to get back to it ... :shock: This can handle a lot of different styles of shops. I just need to find time to do finish it so it is something others can use. Hopefully between the holidays I will get some time to get back on this and get an alpha release at least out. Linda did you get my email? I would be willing to help you with this contribution. Link to comment Share on other sites More sharing options...
Ajeh Posted December 7, 2002 Share Posted December 7, 2002 Thanks for the offer. :D But right now I am taking it in 3+ directions to make it more flexible and I confuse myself trying to think it out ... trying to explain it all to someone and where it is suppose to end up would take longer than writting it I think ... :shock: Link to comment Share on other sites More sharing options...
WebGeek Posted December 7, 2002 Share Posted December 7, 2002 That is absolutely fantastic! The only minor problem I can see is that you still have to login to each store individually. I've been trying all week to get this exact concept up and running. I've setup one database and I am sharing some of the tables between all of the stores and have multiple instances most of the tables for each individual store. What I can't figure out is how to set up the main shop with the products from all of the stores. Do all your stores share every table in the database? It looks as though you have this all figured out. Any insight on how you set this up would be GREATLY appreciated!!! shopping.enternetmall.com demo.enternetmall.com store.flattopcomputers.com shop.flattopwoodworks.com I haven't lost my mind, I have it backed up on disk, somewhere... Link to comment Share on other sites More sharing options...
Ajeh Posted December 8, 2002 Share Posted December 8, 2002 I use 1 MySQL database and 1 set of products and categories. You determine what shows in what stores when you set up the categories and admin. You also will be able to decide if the store itself sets what products are seen or the customer. Link to comment Share on other sites More sharing options...
teamsleep Posted December 8, 2002 Share Posted December 8, 2002 id be interested in hearing ur approach too! Link to comment Share on other sites More sharing options...
WebGeek Posted December 8, 2002 Share Posted December 8, 2002 I understand the single database/admin concept, but how do control what catagories appear on which store? Are you using a customized admin configuration or a customized categories.php? Or am I way off base? I haven't lost my mind, I have it backed up on disk, somewhere... Link to comment Share on other sites More sharing options...
Ajeh Posted December 8, 2002 Share Posted December 8, 2002 I have fields on the categories and products setup where you can set what store can see which categories and products. If the setting is on for the store you are in, then you see them. If not, then they are hidden. Then, in the Admin you see all. Hence, one database does all. :D Link to comment Share on other sites More sharing options...
nick Posted December 8, 2002 Share Posted December 8, 2002 I have fields on the categories and products setup where you can set what store can see which categories and products. Linda - How's your "work in progress" multiple stores mod going :?: Link to comment Share on other sites More sharing options...
medisave Posted December 9, 2002 Share Posted December 9, 2002 This could be the coolest mod ever! (apart from metatag controller maybe!!) Graham www.firstaidsave.co.uk Graham Wright ________________ Link to comment Share on other sites More sharing options...
Ajeh Posted December 9, 2002 Share Posted December 9, 2002 I was kind of partial to the Free Call for Price and the Quantity Controller ... but that's just me ... :D Link to comment Share on other sites More sharing options...
WebGeek Posted December 13, 2002 Share Posted December 13, 2002 This could be the coolest mod ever! (apart from metatag controller maybe!!) Graham www.firstaidsave.co.uk I whole-heartdly concur. Very I, for one, can't wait! :P shopping.enternetmall.com Coming soon, I hope! I haven't lost my mind, I have it backed up on disk, somewhere... Link to comment Share on other sites More sharing options...
lawsy Posted December 14, 2002 Share Posted December 14, 2002 Linda, I have a question, and please dont laugh to hard at my stupidity... I have a simlar virual stores conecpt running where i have added a db-table to give birth to the individual stores. I have included all the necessary options to allow them to be administrated via the admin... ie one admin to rule them all... I have made it so that you can add categories and products that are individual to each store. ( this is working on the same idea as adding rules to the produces table telling them which store or stores to dispaly within ) and I've just got individual emailfor each store to work... ie the stores have specific owners and email and shipping addresses and they disaply the same as your example " multistores " when you choose the option of viewing them " all " BUT............................................................................. ................ yes theres always a but BUT............................................................................. ............... how the *%#@ do i get them to display on individual sub-domains as their individual store ? ie.... categories : store 1 store 2 store 3 store 4 where store 1 will be displayed on store1.mydomain.com and store 2 wll displayed on store2.mydomain.com etc etc is there a simply solution, or is it necessarry to install complete multi copies of oscommerce on each sub ? -Greg Link to comment Share on other sites More sharing options...
Ajeh Posted December 14, 2002 Share Posted December 14, 2002 Everything is on the same physical server. All my domains are set up with the same DNS address ... umm is that the term I am looking for? I think so. I have a set of catalog code on each domain or subdirectory. I have one copy of the admin somewhere within all of this that touches the MySQL database that all the other stores are using for the products. The Admin now sees all orders that come in, categories/products are added/edited etc. from here. Basically, as if there were only one store with the exception of the store code field that you put in the store code(s) where the product is allowed to be displayed. The Admin is set up to see all. The stores are setup to see only their store coded products and categories ... or a new twist I am adding is where the customer is assigned which products he is allowed to see. Now, you are running the same copies of code on the catalog side but you can customize this code for the look etc. The key code changes remain to manage the products and categories allowed for display. But, everything else may be changed. As long as the Admin and the stores can touch the MySQL database, you are mainly just modifying the configuration.php files to address the domain name, subdirectories etc. This also works with pointed domian names. So, yes you need multiple copies at this time for the catalog side of the stores. Unless, you are using the customer assigned codes. Then the customer is altering the display of categories and products based on their login. This is handy for when you do not want to sell products to various regions, you can use the store codes to manage this. Link to comment Share on other sites More sharing options...
NetDave2000 Posted December 14, 2002 Share Posted December 14, 2002 Linda, is your Multiple Stores code available for download. I checked your site and the contributions page but didn't find it. It's just what we've been looking for! Link to comment Share on other sites More sharing options...
Ajeh Posted December 14, 2002 Share Posted December 14, 2002 I am in the middle of a major re-write for it. So, I am afraid there is no download available at this time. As soon as I have this in a workable format there will be a posting on it. Link to comment Share on other sites More sharing options...
lawsy Posted December 15, 2002 Share Posted December 15, 2002 Thanks Linda... At the moment what Im trying to acheive is not so much selling of stores, ( but this will some a little alter ) but rather setting up of my own server... on which I have 6 subdoamains... Such at help@mydomain, support@mydomain etc etc... We are actaully a small local ISP , and Ive been looking to do a little something different from all the bigger boys, something a little dynamic.. and Ive played with osc b4 and liked it, hence the quiries regarding stores.. Ideally I am wanting to create dialup@ourdomain , adsl@ourdomain, hosting@ourdoamin.. ALL linking to the one DB and the one customer account, so no matter what the purchase they will be able to see it in the history.. Now like I said, Ive got the stores bit figured as far as working in a single domain, what i carnt figure is how to get them to display on the subdomains... I'll copy accross the current configuration to each, giving them a basic of customisation, and change the configure.php to point at the correct sql host..... BUT how do I get them to display only the shop I want ? ( please be kind, im only just learning PHP, or rather migrating to ) Thanks Greg Link to comment Share on other sites More sharing options...
Ajeh Posted December 15, 2002 Share Posted December 15, 2002 That is the thing ... displaying the info for just the right stuff everywhere on the right shop. Yes, on mine you can see all orders from all stores in the order history, unless you add what should be a switch when I am done to filter it. But that part to tell you how to do this is to re-write everything and make basically what I am working on now. All products and categories need to be identified to appear on each domain/subdomain/what have you. Then all the filters of the data have to exist to show the right information on the right shop. That is why this is so fun to write. Everything has to be controlled so there are in essence X number of stores. But in reality there is 1 store and the customer is seeing a peice of it. Link to comment Share on other sites More sharing options...
lawsy Posted December 15, 2002 Share Posted December 15, 2002 What Ive done Linda, is add a store_id to all the relevent DB entries, so basically all the products, catalogs etc know where they are ment to be.. Ive then added a store table detailing all the information i wanted attached to the store, along with , ofcourse the store_id.. This approach seemed the most logical without the over creation of tables that you would later regret.. But this is where Im stuck ( for the time being ) . I need a routine that will say, hey your store number 1.. ( store_id = '1' ) and seeing your store number one, I'll only display things associated with you.. I think Im on the right track, and what im trying to acheive is alot more simply than needing a login creation and independant stores per that login.. Im babbling arnt i.. sorry.. Any ideas ? or am I forced to plod alone in this dreadful darkness, blindfolded with the stench of damp manure lingering strong .... :cry: Link to comment Share on other sites More sharing options...
lawsy Posted December 15, 2002 Share Posted December 15, 2002 snazzle frazzle.. Damn avatar's not displaying... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.