Melhor Posted September 11, 2010 Posted September 11, 2010 I want to build 1 mainsite with several subshops. The mainsite need to show all te products of the subshops, it's that possible? Thx Kozak
npn2531 Posted September 11, 2010 Posted September 11, 2010 It would be far easier to do it the other way around. ie Link several shops to one database. Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120
Melhor Posted September 12, 2010 Author Posted September 12, 2010 i tried, but then all the shops getting the same products ! That's NOT what I want. I ONLY want that ONE shop SHOWS the products of the other shops. I dont need to managed the databased, just showing what the other has as categories & products.
Jan Zonjee Posted September 12, 2010 Posted September 12, 2010 I want to build 1 mainsite with several subshops. Sounds like the Multi-Stores multiple shop system addon.
Melhor Posted September 12, 2010 Author Posted September 12, 2010 Sounds like the Multi-Stores multiple shop system addon. I tried, but that's not the solution i need. Multi-stores is easy for ONE user with several different shops. I want several different users, but a TOTAL of their products SHOWN in my Mainshop. I do some research and it must be something with queries on the different databases, but how to implement this in the configure.php? Grtz Kozak
Jan Zonjee Posted September 12, 2010 Posted September 12, 2010 I tried, but that's not the solution i need. Multi-stores is easy for ONE user with several different shops. I want several different users, but a TOTAL of their products SHOWN in my Mainshop. I do some research and it must be something with queries on the different databases, but how to implement this in the configure.php? To me it would seem less work to make sure the owners of the different shops can only update their own products (there is an administrators addon that restricts different admins to parts of the shops, that would be a starting point) than make a shop that queries from different databases. To my knowledge that doesn't exist. At least not as an addon.
npn2531 Posted September 12, 2010 Posted September 12, 2010 What you could do, is have several shops link to one database, and then restrict the products available to each shop. For example, shop A could only query certain products, shop B other products. You could relatively easily use the manufacturers_id field in products table to sort them out. You would have to, however add a little clause to an awful lot of queries throughout the shop. For example in shop A if you changed in specials.php this : $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC"; to this: $specials_query_raw = "select p.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC" 'and p.manufacturers_id='2'; Then for shop A, only products with a manufacters id of '2' would show up on the specials page. The manufacturers id you could manage from the admin with the existing programming. It would be a lot of work, but more tedium than rocket science. Actually the programming for sorting by manufacturers already exists in the shop and more efficient and cleverer way may be to make use of the programming used to create manufacturers sort drop down somehow. Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120
Melhor Posted September 12, 2010 Author Posted September 12, 2010 thanks but thats NOT want I want, because every shop could supply same products from the same manufacturers. I need a querie or something that extract all the categories and products from each shop to copy them to the mainshop. Grtz kozak
npn2531 Posted September 12, 2010 Posted September 12, 2010 I guess I really don't understand what it is you are asking for. Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120
Melhor Posted September 12, 2010 Author Posted September 12, 2010 i have a lot of customers selling second hand cars of all kind of brands. I want that they use and managed each their own OSshop, but all their cars must be shown in one mainshop.
♥Monika in Germany Posted September 13, 2010 Posted September 13, 2010 you can run a synchronizer script that updates your products from all the single databases into one main database (for example nightly). obviously, this requires some custom coding - images need to be copied also etc etc ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
Melhor Posted September 14, 2010 Author Posted September 14, 2010 hi Monika, thanks a lot for your positive answer. Do you know somebody that could write this script? Thx Kozak
♥Monika in Germany Posted September 14, 2010 Posted September 14, 2010 I guess most of the more accomplished developers here could do it ... :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
Melhor Posted September 14, 2010 Author Posted September 14, 2010 hi Monika, how do I get contact with them? I seeking and reading for days but nothing that helps me. thx4support Kozak
Recommended Posts
Archived
This topic is now archived and is closed to further replies.