Two Stores (different Hosting) - Link Tables?

[yvnolan]

I have two stores, Store A & Store B.

The stores are hosted on separate hosting servers with their own databases.

However I sell the same stock in both stores. If a customer buys 2 items from store A the stock is reduced in store A. However I am looking to find a way of also updating the same stock in store B.

Any ideas? Many thanks...

[Jack_mcs]

Use the same database for both.

 

Jack

[rchilson]

Use the same database for both.

 

Jack

 

If you use the same database for both stores, is it possible to just display one vendor's product in the second store? For example, in Store A we want to sell products from both Vendor A and Vendor B and in Store B we only want to sell products from Vendor B. How would I limit Store B to only display products from Vendor B?

 

I assume that if you used the same database for both stores, both stores would have access to the same customer data as well and the order numbers would be consecutive regardless of from which store the order was placed.

[Jack_mcs]

I think this is possible, although I have never tried it. You would need to change the code in at least one shop to point to the the second set of products tables, which would have to be renamed, of course. But then you might have the problem of the orders tables referencing the wrong product number. I just wouldn't want to risk it personally.

 

Jack

[cannuck1964]

If you use the same database for both stores, is it possible to just display one vendor's product in the second store? For example, in Store A we want to sell products from both Vendor A and Vendor B and in Store B we only want to sell products from Vendor B. How would I limit Store B to only display products from Vendor B?

You would really need to add in an additional field to the DB table products and categories. Then in the admin tool add in a drop down for the categories and product editing, where the drop down had Store A, Store B, Both.

 

This (filter) placed in all calls to display products/categories filter out what is not needed, based on the new fields. A new define could be added so you define which store the customer is browsing, and base this filter with it. This could be expanded to meet more shop requirements.

 

As for the customers table, I would not worry about it too much, as most customers would try to login and find they are already signed up at both, maybe an issue, but not one which would keep me up at nights ;)

 

Peter M.