Multiple database

[phantompressents]

Hi

I have a couple of OSC stores and wanted to combine the products of the smaller store into the bigger store.

 

so for instance the main store would have a clothing catagory and within that would be the items from another store/database.

 

this means i can update one stores products and it will update in teh main store aswell.

 

do any of you no of a contribution that can support this idea of any forum topics that mention this ive had noo luck searching for it.

 

any help much appreciated

[masat]

You might take a look at the mall contribution. I've downloaded the contrib but have not had time to check it out.

 

How ever what you want to do should be doable. As I understand one store will have all products showing and the other will have only one category with products from one of the other stores categories.

 

If this is correct you will need to modify the product query in the store with the lesser product base. This will take some time and patients but it can be done.

[phantompressents]

Cheers masat i'll check it out

[phantompressents]

You might take a look at the mall contribution. I've downloaded the contrib but have not had time to check it out.

 

How ever what you want to do should be doable. As I understand one store will have all products showing and the other will have only one category with products from one of the other stores categories.

 

If this is correct you will need to modify the product query in the store with the lesser product base. This will take some time and patients but it can be done.

 

 

I couldnt find any contributions that i thought you ment do you have a link you could post.

Cheers

[phantompressents]

also i think i need to make clear.

 

rather than a multiple store with one database setup

 

this would be a

 

multiple database with one store setup!

[vasttech]

The short answer is yes it can be done. The long answer is it requires some major changes to osC. First and foremost you will need to create a second database class to access the other database concurrently. That way you don't get class redeclared errors. Second you would need to rewrite all the functions and pages that access the database with some logic to check both databases and not just the one.

 

We do something similar but not like that. We have a system with 2 databases and one store. The second database is a corporate database server that tracks customers and orders. The primary osCommerce database handles the products and everything else. So for us it is a little easier in that we know we are always going to do customer transactions on the one database and product transactions on the other server. I definitely wouldn't recommend it for the faint at heart or someone who has little PHP/mySQL experience. It took us close to 6 months to get it working just right and all the kinks worked out.

[phantompressents]

hopefully it could be a feature of future osc releases.

Im sure if your building from scratch it wouldnt be to difficult to add the function in.