One inventory for multiple locations

Highlighted
Tourist
14 0 3

I have a retail business which consists of one permanent store (using Shopify POS) and also sell the same inventory via our online shop (again Shopify).  When 'Locations' were enable I added two other locations as we have stock for sale in another location and we have a regular 'pop up shop' at a variety of locations.

 

I've cancelled the second location, as having 3 inventory lists was causing more problems, as we haven't got the time to manually update.

 

I've still got the third location, for our 'pop up events' but haven't ot the time to manually transfer stock from the first inventory to this third inventory.  So stock is shown as -1 if I sell one item, and this isn't reflected in my original inventory.

 

Is it possible to have one 'master' inventory list for more than one location?  The current situation is causing problems when customers order something which is shows as 'in stock' but has actually been sold at a 'pop up event' but the original inventory hasn't been automatically updated, and we haven't got the time to do this manually.

0 Likes
Highlighted
Excursionist
22 0 4

We have the same issues. Still trying to figure out a work around. 

0 Likes
Highlighted
Shopify Partner
96 0 7

Hi @Lowri_Roberts 

 

We've now had a few clients that have solved the exact same issue with our app, and by syncing their inventory information to Airtable. If you sync your data you can map the inventory at each location to go into a separate column within your Airtable worksheet, and can then modify the quantities quickly and send them back to Shopify. Another useful tool here is Airtable's phone app that allows you to change pop-up inventory levels on the go. Check out our help article on how to track and update Shopify inventory quantities with Airtable.

0 Likes
Highlighted
Tourist
3 0 1

We are experiencing the same issue. Have you found a solution or third party app to sync inventory for multiple locations on one Shopify store?

0 Likes
Highlighted
New Member
2 0 1

Same problem here. I have one (large) inventory I sell from through my online store and at in person events. I take my inventory with me, and sell it through the POS app. 

I miss the way it used to be, and I hate that Shopify made the new locations feature mandatory.

I don’t have separate inventories when I’m selling at POS events, so when I sell something, I want it to become immediately unavailable online so it won’t be sold twice. My products are handmade and aren’t quickly reproduced. I want the inventory availability to be accurate at in person events—not only does it help me quickly find the item for sale in the correct size/color, it also means when I’m ringing up the sale, the customer doesn’t see an error that what they’re purchasing is out of stock.

I need the location from which I’m physically selling to be accurate for sales tax reasons, and it’s also just nice to have for analytics and records—being able to break down sales by location is hugely helpful. 

So far my only workaround is to manually change my store address each time I sell from a new pop-up location, but that’s not ideal, either. Online sales I have during that time show as being ordered from the new temporary location as well, even though they’ll really ship from my actual shop location, not the op-up location.

Please fix this, Shopify!

1 Like
Highlighted
New Member
1 0 0

The issue I'm thinking is that Airtable and Shopify don't sync in 'real-time', correct? If I have 1 item that gets sold quickly, I won't have enough time to mark the other locations inventory to 0.  There will be 10,000 individual products that have no variations and can be picked up from 1 of the 3 locations, depending on the location the user chooses.

How can I remove the product, offered in 3 locations, from the store without having it in stock at the other 2?

Is there a formula I could use for the 3 location columns to say, IF location 1 = 0 then location 2 & 3 inventory = 0 as well?

Even then, can it sync fast enough to not be bought again?

0 Likes
Shopify Partner
2294 116 352

 


@birdsofafeather wrote:

How can I remove the product, offered in 3 locations, from the store without having it in stock at the other 2?

Even then, can it sync fast enough to not be bought again?


'real-time' is highly subjective most apps get triggered by webhooks, or are polling stores for a change, but both those methods can be in terms of minutes  not seconds which is enough time for existing inventory mismanagement to become a real-time problem.

Even with apps that market themselves as "real-time", there will always be a timing issue where out of stock purchases can be made.

Which means ultimately the other parts of the fulfillment process need to be resilient enough to handle that situation gracefully,  such as customer remediation.

If your using automatic fulfillment then that exacerbates existing logistics problem that aren't being solved with custom solutions.

 

Trying to have 1 stock of an item everywhere in shopify locations is trying to use a virtual workaround to solve physical problems.

The only 98%* way to guarantee prevention of selling sold out products is to not have it listed in multiple inventory locations.

*Even with systems like tracking, checkout reservations,etc race conditions apply if the traffic and sales volume is high enough.

If it's a big enough problem then you'd want to either:

  • place add-to-cart, and other calls to action, behind a check inventory gate (where all locations must have positive inventory)
  • build an app to automatically, or on customer action|request,  pre-emptively transfer items  between locations as the item is viewed, or added to cart|checkout
  • item reservation ( https://apps.shopify.com/reserve-in-store-by-fera

 

Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com
0 Likes