Cannot override basic routing rules?

[coltonw]

The issue:

We have 1 fulfillment center in Canada and 1 fulfillment center in the USA. When one fulfillment center runs out of stock, we want to keep overselling in that warehouse and not send that one item to a different country to ship.

I.e. customer lives in Canada and orders products A,B,C,D. Products A,B,C are in stock in Canada, but Product D is 0 stock but a shipment is on the way. We want to have product D oversell to -1 for Canada, and when it arrives the next day, we send out all A,B,C,D from Canada, to the Canadian address.

However, what is happening is that the routing system will automatically send Product D to the USA where we have 100 stock. Now we are shipping A,B,C from Canada and D from USA. It is doing this automatically and we must go in and manually change fulfillment locations. This has been arduous.

This seems extremely simple, but I just spoke with Shopify Plus support and they said there is no way around this, and that I need a developer to help create a custom app. Does anyone have insight into this? Does such an app exist already? I imagine I am not the only person with this simple problem?

I've spent an hour or two looking at apps and browsing support articles - not much luck yet.

Thanks kindly,

[Maxime_Obius]

Hi @coltonw 

In Settings / Shipping and Delivery, you need to set Fulfillable Inventory to "Sell only within configured shipping zones".

I made a video to verify if your Shopify setup is properly done : 
1. setup two different locations, one for each of your fulfilment centers (ie: eCom Canada & eCom USA)
2. select the variants that are stocked at each of your location
3. setup your shipping profile for each of your locations (ie: CanadaPost for eCom Canada & USPS for eCom USA), and ensure they are mutually exclusive
4. finally, ensure you set Fulfillable Inventory to "Sell only within configured shipping zones"

If this is helpful, please hit Like and Mark it as solution! 