Inventory in multiple fulfillment centers

[sf2000]

Hi all!

Our product is ice cream.  we have 3 fulfillment centers around the country.

Is there a way to make only certain flavors available to people based on their location?  In other words, if we're temporarily out of stock in our California warehouse for vanilla, we wouldn't want people in California to be able to order that flavor.  

But, at that same moment, we might have plenty of Vanilla in our New York warehouse, so people from New York can order Vanilla.

We wouldn't want to have to fulfill the California order from the NY warehouse because of the very high shipping cost.   It would be better for us to just not let the california person order that flavor.

Any apps to do this?  any other ideas?

thanks!!!

[opaque_ex]

ok that cool