Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Linking several databases in 1 database?


Melhor

Recommended Posts

Posted

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

Posted

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.

Posted

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

Posted

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.

Posted

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

Posted

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

Posted

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.

Posted

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 ...

Posted

hi Monika,

 

 

thanks a lot for your positive answer. Do you know somebody that could write this script?

 

Thx

 

Kozak

Posted

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 ...

Posted

hi Monika,

 

how do I get contact with them?

I seeking and reading for days but nothing that helps me.

 

thx4support

 

Kozak

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...