Help! - Local Pickup at Multiple Locations with One Central Warehouse Location for ALL Inventory

Highlighted
New Member
1 0 7

Help!

We have 4 coffee shops and an online store primarily selling coffee beans. We handle all inventory and fulfillment in our central warehouse, and in order to defray prohibitive shipping costs for local customers, would like to enable them to pick up an online order at one of our 4 physical shops. We stock and distribute other products to our shops from the warehouse as well; it would be relatively easy to simply package online orders at the warehouse and  include them in our existing deliveries to each designated shop 2 or 3 times/ week for free customer pickup.

However, we cannot physically keep online store inventory at each of 4 stores and fulfill from each; this would be far more complex/costly. Our fulfillment resources are at the warehouse, and we’d need to hold and redistribute far more inventory (which has a short shelf life), and Shopify seems to require independent inventory at each location. We have considered simply setting each shop’s inventory to 0, and enabling ‘oversell’, for the warehouse; however, this would require manually decrementing inventory for each order. Furthermore, if we truly ‘oversell’, our supplier’s processing / packaging time far exceeds our existing 2-day turnaround.

We have been trying to approach this from multiple angles:

- Shopify pickup option for multiple locations (above issues).

- Only Shopify: enabling local pickup from our warehouse location, and finding a way to allow customers to select one of our 4 actual pickup locations from a drop-down somewhere (?) but we’ve been told that we can’t edit or add anything to the checkout form.

- Finding a way to back into what we need using Shopify’s ‘delivery’ option; no luck as of yet.

- Multiple third party apps, e.g. pickup, delivery, inventory… none of which seem to fit the bill.

In summary, we’re desperately seeking a way to maintain a central inventory while enabling customers to select any one of 4 pickup locations. We’re hitting the proverbial wall on this, and are surprised; it doesn’t feel like this would be unique/niche functionality. We’re relatively small, but many national online retailers allow customers to allow local in-store pickup? Have any of you successfully dealt with this issue, something similar, or happen to have any ideas? Are there any other third party app recommendations? We would welcome any and all ideas and are happy to provide additional clarification as useful. Much appreciated, and thanks in advance! 

Highlighted
Excursionist
14 0 1

I'm following this - we have the exact same issue.  I don't want to click every inventory item to show it is in more than 1 location, but this seems to be the only quick fix.

0 Likes
Highlighted
New Member
1 0 0

This is also my problem...Following to await some replies.....Also in the search it says 4 replies - but I only see 1 reply......is that information inaccurate on the forum search facility?

0 Likes
Highlighted
New Member
1 0 0

HI!!!

Facing a similar problem here :(((( were you able to get a resolution on this?

0 Likes
Highlighted
New Member
2 0 0

Following as also dealing with the same problem

 

0 Likes
Highlighted
Tourist
4 0 2

Yes same here!!

 

One warehouse multiple pick up locations. Warehouse delivers products to location for customers to pick up. So we don't need inventory at each location only at the warehouse. 

 

Help!!!!!!!! (lol) need a solution asap

Highlighted
New Member
1 0 0

I'm having the same issue.

We also have one central stock location and an extra pick-up nearby. This pick-up has no stock, products are moved there as needed.

We're going to try and create an app that gives the pickup location a fictive stock that is always synchronized to the real stock location.

0 Likes
Highlighted
New Member
1 0 0

Following! I’m stuck between Squarespace and Shopify. I can’t seem to find anything that works exactly how I want it to.

0 Likes
Highlighted
New Member
1 0 0

We have exactly the same issue - on central stock that's available for pick up at three different locations. Hope someone has a solution for this!

0 Likes
Highlighted
New Member
1 0 0

Hi guys,

I end up using a webhook, that will execute every time an order is pay. This webhook executes an API we developed. This api uses the shopify APIs in order to update the stock of the other locations. So, it goes something like this:

- We have 5 locations for local delivery

- To all of our products we assigned the same amount of stock. So in real life, we only have 10 units of Product A, but in shopify we have 50, 10 for each location.

- So if someone buys 2 units of Product A on Location 1, we have to update the other four locations to 8 units. So at the end all the 5 locations hace 8 units eatch

To achieve this, as mentioned in the beginning we develop an API, that uses the shopify APIs. We had to use the following APIS:

 

https://{0}/admin/api/{1}/products/{2}/variants/{3}.json
https://{0}/admin/api/{1}/orders/{2}/fulfillment_orders.json
https://{0}/admin/api/{1}/inventory_levels.json?inventory_item_ids={2}
https://{0}/admin/api/{1}/inventory_levels/set.json

Im aware this is not a real solution, but is the only way we were able to achieve this. This means you will need a server, a domain and a SSL certificate in order to publish your api and call it from the shopify webhooks. 

Hope this can help someone.

0 Likes