products_quantity?

[ZeroAquaduct]

I have 2 stores with 2 databases (on the same domain). Am I able to have 1 single stock level, i.e., products_quantity? I'm thinking maybe I could point Store 1 to Store 2's products_quantity and have 1 single products_quantity. That way, my overall stock level will be more accurate.

 

I'm a real noob at this, so I'm not sure whether this can be done or not.

[ZeroAquaduct]

Anyone?

[hankfrid]

Why don't you put both stores on the SAME database altogether? I think there is a contribution out there to allow multiple Admin account signons, if you needed them.

 

HankFrid

[ZeroAquaduct]

Why don't you put both stores on the SAME database altogether? I think there is a contribution out there to allow multiple Admin account signons, if you needed them.

 

HankFrid

 

Thanks for the reply, HankFrid. I wanted to have 2 databases instead of 1 because my stores are just too different. For example, one store has products measured in kg and cm, while the other is in pounds. Also, both stores use different payment and shipping methods. There are actually more differences.

 

I looked at the different virtual mall setups, but going with 2 installs is the best method, since I have only 1 flaw left -- that's the stock level tracking (what this post is trying to solve). All other methods have 2-3 flaws. :(

[hankfrid]

All right....so how technical are you? Do you want one to be the master, as far as quantity goes?

 

The only thing that I could think of is to set up a little SQL function off of your second database that would read and update the quantity from the first database. But then what are you going to do when restocking occurs? Does one shop really do the re-ordering for both stores?

 

HankFrid

[Guest]

You could do it similar to a shared login - where you tell one store to look at the db products table for the other store - you would have to store all the products in one database - however - why not have it so items get displayed in pounds and in grams and where shipping options are intuitive based on say country etc.

[ZeroAquaduct]

All right....so how technical are you? Do you want one to be the master, as far as quantity goes?

 

The only thing that I could think of is to set up a little SQL function off of your second database that would read and update the quantity from the first database. But then what are you going to do when restocking occurs? Does one shop really do the re-ordering for both stores?

 

HankFrid

 

Oh, thanks for the reply HankFrid! I didn't even know this post had been replied to until now. :oops:

 

I'm fine with HTML, but I'm still learning PHP and SQL right now, so I won't be able to write that myself.

 

Yes, one store does the ordering. So it's really one central location for the stock of both stores.

 

I've been thinking about this and it does seem a little too hard to do. I wonder if this can be done?

[ZeroAquaduct]

You could do it similar to a shared login - where you tell one store to look at the db products table for the other store - you would have to store all the products in one database - however - why not have it so items get displayed in pounds and in grams and where shipping options are intuitive based on say country etc.

 

Thanks for your reply, bluephoenix. It's OK if there's only one database for the products, as long as the rest of the store configuration is separate. However, am I able to separate the grams and the pounds if I have only one database?