Limit inventory (and stock display) to the location (warehouse) assigned to country (shipping zone)

DSF23
Shopify Partner
5 0 4

Hi community,

 

I have following problem that I cannot solve. We have the following setup:

 

–––

 

Markets

I have 3 Markets setup:

  1. CH Market: That covers Switzerland and Liechtenstein
  2. EU Market: That covers the European Union, e.g. Germany, France, Spain, Italy and so on...
  3. International Market: That covers United States, UK, Latin America, Asia and so on... (not sure which countries finally).

Here the setup:

CleanShot 2023-02-26 at 13.11.00@2x.png

 

Locations

We have two locations that act as warehouses for deliveries for online orders. They each have individual stock of the products we sell online. Both warehouses stock the same product items.

 

  1. Zurich: Only ships to Switzerland and Liechtenstein
  2. Berlin: Ships to all the other countries in the EU and in Internationl market

 

Shipping Profile and Zones

I set up the general shipping profile with 2 locations and 3 zones

 

CleanShot 2023-02-26 at 13.33.17@2x.png

 

And the zones look like:

ZoneZurich.png

ZoneBerlin.png

 

Just as a note: The configuration is not final, yet. I'm still setting things up.

 

Geolocation

I have the Geolocation App installed where the user chooses his "country" when accessing the shop.

 

–––

 

Now, to the problems. Lets take following "Product B" for example with following inventory:

 

CleanShot 2023-02-26 at 13.50.14@2x.png

 

 

#1 Stock Display

When a user selected France – where only the Berlin Location ships to – I want to display the user the stock available in the Berlin warehouse.

 

I added a custom liquid block that displays the stock available

 

{% assign current_variant = product.selected_or_first_available_variant %}
<div class="inventoryNote form__label">
{% if current_variant.available %}
{% if current_variant.inventory_quantity > 0 %}We have {{ current_variant.inventory_quantity }} in stock
{% endif %}
{% endif %}
</div>

 

This works but displays the combined inventory from Berlin and Zurich, in the case of "Product B" its the amount of 3 (but it should be 9 at this point).

 

#2 Ordering Products

If a user selects Switzerland as his current country and also ships to switzerland, he can now do this for "Product B" even though there is no Stock in Zurich for this product – e.g. the inventory goes to minus in Zurich. But we do not want to fulfill the order from two locations...

 

Notes:

  • When there is not enough stock in Berlin and Zurich the order is not possible right now, which is correct
  • When the stock goes to 0 for Berlin and Zurich combined, the product is displayed as out-of-stock, which is correct

 

#3 Shipping country

If a user selects France as his country, we want that the user to only be able to select France as his shipping country in the checkout.

 

 

So, I'm stuck with these Problems, Problem #1 and #2 are importan, #3 not so much. I really tried a lot and researched but cannot figure it out. Do I need an app for this or did I configure things wrong?

 

Thanks so much for any help.

 

 

 

 

 

 

Replies 10 (10)
matiasricci
Tourist
8 0 6

I've experienced that exact same problem for years now. The Shopify Team told us we needed to upgrade to Plus, which we did last week. Now we are still experiencing the same issues, we're getting no support at all, and we're stuck into a $24k/year contract.

Quick example of muy problem:
Location A fulfills US & Canada (Market A) only > product X is in stock in that location

Location B fulfills European countries (Market B) only > product X is out of stock in that location
A customer from a European country will see the product X in stock, and will even be allowed to complete checkout, ignoring that there's no stock in that location.

This is leading us to oversell. Shopify seems to be aware of this problem because they've launched this feature > https://help.shopify.com/en/manual/markets/inventory_and_fulfillment. But it's only for selected merchants and we're not one of them.

There's another thread about this topic: https://community.shopify.com/c/international-commerce/inventory-and-fulfillment-with-markets/m-p/19...

DSF23
Shopify Partner
5 0 4

Hi Matiasricci, thanks so much. Sorry to hear that you went for Shopify Plus due to this issue without solving the issue for you, that s.cks. Ok, it really seems that is a "bigger issue" with shopify. I also posted this to support but I did not get any answers (yet). This is really a bit dissapointing altogether, for us, this is a pretty crucial feature. On Reddit somebody recommended looking into an orfder management system like https://orderbot.com/ but I did not do that yet.

 

Regarding this Link

https://help.shopify.com/en/manual/markets/inventory_and_fulfillment

 

When researching about if Shopify is the right solution for our store I actually read this link and this made me check the box in regards to inventory mgmt with two warehouses, I just overlooked that this is only available to selected merchants... I will go on investigating and findind a solution, I will post back If i find out sth.

matiasricci
Tourist
8 0 6

 

That's too bad - I'm sorry. If you want, shoot me an email at matias@unit1gear.com. I'm putting together a list of merchants that are experiencing the same issue to see if we put a group claim/feature request with Shopify.

DSF23
Shopify Partner
5 0 4

Hi matias, great, I will shoot you a mail!

UKPreppingShop
Excursionist
40 0 15

Hi

Were settuing up an EU warehouse with selected products and have hit the same wall....come on shopify spend some of them billions!!!!!!!!!!!!!

MilkyTee
Visitor
2 0 2

This is a major issue for me too, and I’m sure will be for many merchants. Shopify markets seems great but if they cannot split the inventory for each of the markets that will cause huge issues as you’ll end up overselling stock which isn’t available. I hope shopify find a solution to this soon.

CreatureCaster
Visitor
1 0 0

Any updates or official response or other threads regarding this issue. Seems like something that is very obvious... different warehouses ship to different locations, otherwise I'm sure we would all just have one warehouse.

DSF23
Shopify Partner
5 0 4

Hi! We solved it by using the https://help.shopify.com/en/manual/markets/inventory_and_fulfillment feature that works really well. Issue is that in the checkout the user can switch the delivery country and then there is no more stock check for the configured location/wherehouse.. We had to have this feature enabled on request to the support. Hope that helps!

MilkyTee
Visitor
2 0 2

Oh that’s great to hear. Did you just contact shopify and ask for this feature to be added? I wonder why this is t automatically offered to all stores as surely this is an issue which will affect many stores which sell globally?

DSF23
Shopify Partner
5 0 4

yeah, we just asked 🙂 Not sure why its not a standard feature, I think it is marked as a Shopify Plus feature... There are also other Features that are officially marked as Shopify Plus but you can use them with normal plans.