I am building out an e-commerce site for a screen printing ink manufacturer. They have around 300 SKUs and warehouses in two locations - one on the east coast, one on the west.
Generally when customers order, there is a time sensitivity. Additionally, the product can be heavy and incur large shipping costs. For these two reasons, it is important for customers to know what stock is available at which warehouse location and to order accordingly. Ideally, they are able to see what is available at the 'other' warehouse, as well - in case they are less time sensitive and are ok with inventory coming from this location.
I think there are a few different options as to how to approach this. I'd be curious to hear if others have faced such a situation (surely) and how they handled it.