Bug in multi-warehouse stock tracking and shipping

MackJon
Tourist
11 0 1

Hi,

Just putting this one up in case other people find this issue. I have logged it with Shopify a few months ago, but I haven't seen any fix for it yet. My workaround is working, but it's a pain to admin.

Situation:
Two warehouses, one in UK, one in EU. UK Ships to UK, EU to EU (plus others, but not relevant).
Product cannot cross this border, so stock in the UK cannot compensate for missing stock in the EU warehouse (and vice versa).
Each warehouse has shipping rules so that they can only ship to their locations. 
Each warehouse has their own stock on the product page and the stock level is tracked. 

Issue:
Despite having no stock in the EU warehouse, and no way for the UK to ship to the EU, the product can still be added to cart and purchased. The 'tracked' stock in the EU warehouse then reduces to -1.

Overall, even though the UK has no shipping rule for this item it's given the order.

Workaround: 
I've created multiple shipping rules where now I have stock that can only be sold in the UK, only sold in the EU, or available in both. However, I have to move each of these manually as stock gets low (so I can never sell all the stock). I've also had to remove the default shipping to ship nowhere, just make sure new products don't accidentally get added to the wrong group by default. To add to the complication, I do have some products that can move across the UK/EU border, so I have an extra rule for them too.

Anyway, I'm writing this post to see if anyone else is having the same problem, see if there are other workarounds, but also hopefully find out when it's fixed! 

I just need a product that's in two warehouses to abide by its shipping rules and not bypass it just because it can see there's stock in another part of the world!

Jon

0 Likes
saivismitha
Shopify Partner
137 7 29

Hello @MackJon,

 Have you created shipping profiles for each product based on shipping zones and location?

It can be done in two ways,

1. By using shipping set up.

If you want to resolve this multiple-warehouse complexity, you can fix it by creating 3 shipping profiles for the products by adding shipping zones and shipping origin location(default the shipping address).
While setting up shipping zones add the zip codes and names properly and don’t overlap with unmatching zip codes.

2. By using the third-party carrier app.

I would suggest the multiple-carrier shipping label app. The app helps you to set up automation rules based on certain customized criteria, where you are allowed to choose ships only to selected zip code localities. The app automates the shipping process according to the settings you have made within the app

Customer Success @ PluginHive
Shipping Automation | FedEx shipping | Multi-carrier shipping | Shipment Tracking | Australia Post shipping
0 Likes
MackJon
Tourist
11 0 1

Hi,

Thanks for the reply. Yes, shipping profiles is a major part of how we're working at the moment (currently on 12 profiles with about 30 rules in each) - but it's actually the stock level and shipping profiles that do not play well together. We constantly have to monitor the stock levels of products to make sure they are either in both EU and UK delivery, or only EU, or only UK profiles. 

It seems logical that if there are two warehouses (we use 3PLs) with a profile that says 'Warehouse A can deliver to UK' and 'Warehouse B can deliver to the EU', when one warehouse has no stock it cannot bypass its shipping rule and still allow it to be purchased. That's what is happening at the moment. When the UK warehouse runs out of stock, it just 'borrows' it from the EU even though we can't ship there from the other warehouse.

Jon


0 Likes
coleatkinson
Shopify Staff
Shopify Staff
66 0 33

Hey @MackJon thanks for starting this thread.

This is something my team and I are working to address at the moment. I can keep you updated on this thread as things progress.

Cole Atkinson | Product @ Shopify
0 Likes
MackJon
Tourist
11 0 1

Perfect, thanks for that. 

Overall that was all I was aiming for as when I looked I couldn't see anything on the forum about it, and although I logged a call and knew it was being addressed, there isn't really a means to find out when it is resolved. I don't think this sort of thing will get an announcement in the changelog. 

It'll be great to get it fixed though, it's giving my logistics guy a massive headache with the workaround at the moment, so he'll definitely thank you when it's resolved!

 

Jon

0 Likes
coleatkinson
Shopify Staff
Shopify Staff
66 0 33
Hey Jon,

This will definitely be in the changelog when the update is made. We'll
keep you up to date! Thanks for the feedback and bringing this to the forum.
Cole Atkinson | Product @ Shopify
0 Likes
Stigla
New Member
1 0 0

Hello guys,

I am not having news sadly, but actually want to join into this community to push support for this matter as I experience similar thing right now.

We are designing, manufacturing and selling our products in Serbia, but we would like to ship across EU also. To make it easier, we have decided to open another warehouse in Germany.

For Serbia it does not really matter when costumer purchase product. If we don't have in stock, it taking us up to 5 days to manufacture it and ship it, which is agreement between us and costumers. So we have selected option on the website "Continue selling when out of stock". When item is out of stock, costumers does not know that, we can just make it.

Problem arises now for warehouse in Germany. We depend of stock piles there. If I don't have an item, i can not make and sent from Serbia to Germany within 5 days, actually it can take weeks maybe. So, in Germany I sell items only which are on stock. 

I have tried via inventory and bulk and whatever i have in Serbia, that will reflect to Germany and vice versa. Location setting probably works fine locally, but how it can be improved across multiple counties or like in my case EU and non EU countries.

If Item is not on stock in Germany, i want German person to know that Item is Out of Stock. I have no idea if there is any app or someone who can maybe help how this can be adjusted.

Shopify assist team is really pleasant and they resolved so many issues for me and I am very thankful for them. This one is a bit tricky.

 

Hope someone can help

 

0 Likes