We have multiple fulfilment locations setup for our Shopify store. We'd like to setup a location rule that when a certain SKU is ordered, all items in that order will be routed to a specific location to be fulfilled.
I know that we can set any individual SKU's location to be fulfilled at a certain location, but what happens if a customer also orders a SKU in the same order that is set to another location ?
When multiple SKU's from different locations are included in a single order, we'd like some logic applied so the whole order is rerouted to a fulfilment location we specify to avoid multiple shipping costs. Is there an app for this? Or even better, is there a way to do this within Shopify?