Serial Posted April 19, 2004 Share Posted April 19, 2004 (edited) Update: I have just reinstalled all additional stores files. They are working correctly now. I might have made some error with php files while midifying them. (So, my previous issue is resolved.) New issue: * Every admin from each store could see and full access to all categories from their store admin panel. Is it normal? I wish they could only see the categories and products assigned for their store. Is there a way to make it happen? Thank you. Edited April 19, 2004 by Serial Quote Everything is possible. Link to comment Share on other sites More sharing options...
mmsnet Posted April 20, 2004 Share Posted April 20, 2004 Update: I have just reinstalled all additional stores files. They are working correctly now. I might have made some error with php files while midifying them. (So, my previous issue is resolved.) New issue: * Every admin from each store could see and full access to all categories from their store admin panel. Is it normal? I wish they could only see the categories and products assigned for their store. Is there a way to make it happen? Thank you. im also having this problem.... so far, all the admin can be login and modify other ppls product ... :angry: :( Quote Link to comment Share on other sites More sharing options...
Guest Posted April 20, 2004 Share Posted April 20, 2004 I believe thats how its supposed to work, you need to see them all in order to assign them to one store or another. Cya Stot Quote Link to comment Share on other sites More sharing options...
Serial Posted April 20, 2004 Share Posted April 20, 2004 Hi Stot and everybody, I understand that the Admin from the main site should be able to see all the categories but I don't want all other Admins from those additional stores to be able to view and modify other stores' products. This is a hole. Very dangerous. Is there any way to fix it? Thank you. Quote Everything is possible. Link to comment Share on other sites More sharing options...
hobbzilla Posted April 21, 2004 Author Share Posted April 21, 2004 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 I will be releasing a new version soon with this fix as well as some other changes. I'm sorry it has been touch and go with me.. I got married on March 13 and have been in and out of town for the past few weeks.. not to mention all the projects due at work... ARGHH: what a great newlywed period. I guess life doesn't stop for those in love!! Anyway.. hang tight. I'll be on it soon! Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted April 21, 2004 Author Share Posted April 21, 2004 This i believe is a vital issue because everyone knows how annoying duplicates are.. no one really has space to afford unneccessary duplicates. I like to use symbolic links (ln -l) myself ;) Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted April 21, 2004 Author Share Posted April 21, 2004 (edited) New issue: * Every admin from each store could see and full access to all categories from their store admin panel. Is it normal? I wish they could only see the categories and products assigned for their store. Is there a way to make it happen? As of right now there is no "Lesser Admin" Just one admin to rule them all! You would probably be best to not update the admin for each store and only have the super-admin on one store. I personally do not need the "lesser admin" which is obviously why it hasn't been developed. It is already on my future features list.. but there is really only sooo much time in the day! There is ALWAYS a way to make it happen! :) It just gets hard juggling *paying* job, developing oscommerce modules - gratis, being newly-married, and wanting to watch American Idol (did I just say admit to that last one?)... donations motivate.. but if you just can't wait to have it done gratis, you might have to hire a coder to finish the rest and hopefully contribute back to the community! Edited April 21, 2004 by hobbzilla Quote Link to comment Share on other sites More sharing options...
Guest Posted April 21, 2004 Share Posted April 21, 2004 Congrats on the marriage dude! Well once our store is up and running your contrib will be tested by about 3000 people a day from the day of launch, and I tell ya what, Ill let you have any item off the store as a wedding gift, hows that for motivation? ;) Cya Stot Quote Link to comment Share on other sites More sharing options...
nyderrn Posted April 23, 2004 Share Posted April 23, 2004 Hi, Just installed this awsome contribution today and I was wondering if there is an easy way to assign the products to a store. I already have almost 2000 products and it seems that I have to assign each product to a store individually. Is there a way to do it with SQL or Easy Populate? Thanks, Tim Quote Link to comment Share on other sites More sharing options...
nyderrn Posted April 24, 2004 Share Posted April 24, 2004 Hi, When I try to edit, get an invoice, or a packingslip from orders.php I get sent to a blank page with no errors. I've been checking orders.php, invoice.php, and packingslip.php for typos I may have made while adding the contrib. I can't seem to find anything. Anyone have any ideas or similar thing happen to them? Thanks, Tim Quote Link to comment Share on other sites More sharing options...
nyderrn Posted April 25, 2004 Share Posted April 25, 2004 Hi, Found my problem. It was a ; instead of a , in classes/order.php. DOH, I love it. But, anyway is there an easy way to put products into a store without going to the catagories/product page and ticking the box? If there's not, then I'll bite it and start the mindless journey through my products adding them to my store1. Words can not express how great this contribution is and I am glad you created it. Thanks, Tim Quote Link to comment Share on other sites More sharing options...
shutiri Posted April 27, 2004 Share Posted April 27, 2004 Hi. I would like to do a multi-shop site which takes the products from several sites and dbs. It would work this way: Let's say I have 10 clients, each with its own site (site1.com, site2.com...), each one with its own oscommerce shopping cart and its own db. Then I would like to create one site (bigsite.com) that would show all these catalogs, categories and products and would be able to search in all these stores for specific products. Can I do this with this contrib ? thank you. shutiri. Quote Link to comment Share on other sites More sharing options...
peterr Posted April 27, 2004 Share Posted April 27, 2004 Hi, I think a lot will depend on whether or not the 10 sites (domains) are all on the same server or not. Peter Quote Link to comment Share on other sites More sharing options...
shutiri Posted April 27, 2004 Share Posted April 27, 2004 let's say they are ;) what do I have to do ? Quote Link to comment Share on other sites More sharing options...
Guest Posted April 27, 2004 Share Posted April 27, 2004 So you want lots of little stores with select products then one big store with ALL the products? If so thats pretty easy using this contrib all working from 1 db. Just follow the setup guide in the contrib. Cya Stot Quote Link to comment Share on other sites More sharing options...
shutiri Posted April 27, 2004 Share Posted April 27, 2004 nop... I'll do several sites with several dbs. and then a big shop with all the info from all these sites and dbs. thanks shutiri Quote Link to comment Share on other sites More sharing options...
peterr Posted April 28, 2004 Share Posted April 28, 2004 Hi, I think a lot of what you want to do, will depend upon what you can do technically. That is, your objectives will not so much be addressed by whether osCommerce can do it, but whether, for technical reasons, you can even actually connect to all the db's. Even if they are on the same server, a lot will depend on how the hosts have the security setup, how MysQL is setup, and a whole lot of other things. I speak a little from experience, as I do web hosting and (some) webmaster work. So, ..... you need to test first whether you can actually connect to the 10 db's from one site, and do all you want from that one site, in terms of updating the 10 databases, or even arranging the one site in exactly the category/product layouts you need. Peter Quote Link to comment Share on other sites More sharing options...
brett Posted April 30, 2004 Share Posted April 30, 2004 Hey All, I am pretty sure I did mostly everything correctly, but it's obvious I didn't. Every time I try to type in the store config table under admin>catalog>stores, I get the following error. Any ideas? 1064 - You have an error in your SQL syntax near 'TO yankees_configuration' at line 1 RENAME TABLE TO yankees_configuration [TEP STOP] Thanks, =brett= Quote Link to comment Share on other sites More sharing options...
peterr Posted May 1, 2004 Share Posted May 1, 2004 Hi Brett, 1064 - You have an error in your SQL syntax near 'TO yankees_configuration' at line 1 RENAME TABLE TO yankees_configuration It has to be of the format: RENAME TABLE old_table_name TO yankees_configuration; ... where old_table_name = the name of the table you are going to rename. Peter Quote Link to comment Share on other sites More sharing options...
brett Posted May 3, 2004 Share Posted May 3, 2004 hey peter, thanks for the help. I figured it out later that i needed to create a new configuration table that wasn't YANKEES_CONFIGURATION = yankees_configuration, but rather CONFIGURATION = yankees_configuration. but now, i get the most interesting error of all~! 1064 - You have an error in your SQL syntax near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS' at line 1 select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS [TEP STOP] .......i think this is because of my featured products mod. any ideas? Quote Link to comment Share on other sites More sharing options...
peterr Posted May 4, 2004 Share Posted May 4, 2004 Hi, I'm a bit rusty on SQL, but you can't have the 2 'order by' fields defined like you have, they need to be seperated. Peter Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted May 4, 2004 Author Share Posted May 4, 2004 Hi, Just installed this awsome contribution today and I was wondering if there is an easy way to assign the products to a store. I already have almost 2000 products and it seems that I have to assign each product to a store individually. Is there a way to do it with SQL or Easy Populate? Thanks, Tim Tim, I personally use an excel spreadsheet, then do a few search and replaces and append the INSERT into products ..... and it works very nicely. If you have a large product base.. yes clicking "STORE" button for each category & product is not the fastest thing in the world. I am planning on incorporating a selection at product creation time that would allow you to assign stores then. Also of interest might be the modification of the all_prods contrib to then tick a box to select the products you want.. then select the stores you want the selected products to belong to. Quote Link to comment Share on other sites More sharing options...
Guest Posted May 4, 2004 Share Posted May 4, 2004 (edited) Hi i have a very small problem i was wandering if anyone else has had ? I installed this contribution on to a fresh install of os, so i cant see how i could manage to mess it up. Buy hay we all know these things happen :D In my administration under catalog->stores If i try to rename my site, upload an image (basicly press save) I get this error 1050 - Table './frs/uksite_configuration.frm' already exists RENAME TABLE uksite_configuration TO uksite_configuration [TEP STOP] It doesn't really matter because i can just use mysqlAdmin - but it would be nice if it worked Has anybody got any ideas? Thanks in advance Sam Edited May 4, 2004 by Nimmit Quote Link to comment Share on other sites More sharing options...
brett Posted May 4, 2004 Share Posted May 4, 2004 hey sam, from what i've gathered, this is a slight bug in the contrib. the contrib is setup to create a NEW table, but since you've already created it in mySQL it doesn't know what to do. I have a similar problem and I'm just going to overlook it right now since it doesn't really have any functionality problems. the contrib is still great and works well for most people, so i'm gonna stick with it too... hopefully i can work it out soon. anyway, on to my question: check this out: http://www.proteamshop.com/catalog http://www.proteamshop.com/yankees I cant get products to show up in the yankees site, but they will show up in the /catalog/ site if i enable them. Does anyone have any ideas? thanks in advance~ =brett= Quote Link to comment Share on other sites More sharing options...
brett Posted May 4, 2004 Share Posted May 4, 2004 hmm, interesting. so what i did was DELETE the yankees_configuration table, then recreate just the STRUCTURE of the table. Then i went into the admin on osC, went to stores, deleted the yankees store. Then I added the yankees store again, with the URL and set it to yankees_configuration and default table option selected. The errors I was having were magically fixed. It's because the contrib needs to create the table values itself rather than allowing the user to input them manually using phpmyadmin or anything like that. Now all i have to do is get the featured_products contrib working :) ....I haven't even started that yet. let me know if anyone is interested in the updated files to work with featured_products. I should have it fixed up in a few days. Thanks for the awesome contrib... once again, my career is saved :) =brett= Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.