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

JRogers410
Visitor
1 0 31

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! 

Replies 38 (38)

BTO2
Excursionist
21 0 6

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.

SuperMario71
Visitor
1 0 1

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?

Crystalbynewage
Visitor
1 0 1

HI!!!

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

zee_r
Shopify Partner
1 0 1

same. 

Moose907
Visitor
2 0 1

Following as also dealing with the same problem

 

KatieL11
Tourist
4 0 8

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

Nik7
Visitor
1 0 1

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.

WetKnotFarms
Visitor
2 0 1

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

StreamStudio
Visitor
1 0 1

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!

kritochin85
Visitor
1 0 2

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.

PaulNewton
Shopify Partner
6274 573 1319

There are many apps that can sync inventory for various reasons.

One https://usemechanic.com  allows scripting for more complicated situations.

They even have a library of premade scripts including for inventory sync'ing

https://usemechanic.com/task/sync-inventory-for-shared-skus 

 

If you need such custom solution I can be contacted at paull.newton+shopifyforums@gmail.com 

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


webdeveloperfbs
Visitor
2 0 0

Hello, after searching multiple forums thought I share an easy solution for multiple pickup locations without an app, or installing code or using multiple location inventory tracking.

Inside Shopify > Products > Scroll to Quantity > Choose Edit Locations and from here you can select the locations that will display on checkout.

You have to do this for every product but still a good workaround. Hope this helps.

Locations-Grab.jpg

TVR_UK
Tourist
6 0 0

Don’t you need to put stock in each location as well?

SLB2
Visitor
3 0 0

Wouldn’t you still need stock at both locations ??? Looks like a lot of us have the same issue 

WetKnotFarms
Visitor
2 0 1

This is not a work around. This is what I was doing, but run the risk of over selling. If the item is not stocked at the place someone is checking out, then cart abandoned.

SatoriAcademy
Visitor
1 0 0

Have you ever gotten a solution?  My situation is exactly as you have stated.

jfiojfoi5476
Visitor
2 0 0

Its pretty similler case here in my project have to send or recieve my jigsaw products but i am facing the same difficulties i dont know how to find its solution its happening from four or five months if someone has an idea plz share with me 

Scarfee
Visitor
3 0 0
Also want to know the answer to this!

TheSilo
Visitor
3 0 2

Following

SeanMullins
Tourist
4 0 4

Hello, 

We have the same issue! We have a working solution, but it is not ideal.

Here's our situation and what we do for our team at www.shush-fashion.co.uk

We have 11 stores and central warehouse to service our website. Our customers can order online and use "Click and Collect" from any of the stores.

What we did was edit the shipping rates, to include our Click and Collect locations. While it is not 100% the solution, it is a workaround we are currently using until Shopify sort this out. Here's what our Shipping Zones look like.

 

SeanMullins_0-1624203005565.png

 

anisgr75
Tourist
3 0 2

I'm using the same solution of editing the shipping profile to the pickup location but it's very confusing for our customers when they have to choose between ship and pickup?

Ship means home delivery so they choose pickup and stuck with the warehouse pickup choice only.

TILTIL
Shopify Partner
5 0 12

Following! We also have daily deliveries to our retail stores and would like to pick and pack the orders in our central warehouse, but let customers pick it up at one of our retail locations. It’s possible to put pickup as a shipping option, but a bit confusing.

hobsonb3
Visitor
1 0 2

Hey all,

We just started using this app below for a student store that needs to have multiple pickup locations but keeps the inventory in one central warehouse.  Their customer support team is very helpful during the set-up and the user experience makes a lot of sense. 

One thing I'll point out is that it makes users selects pick-up days and time windows, which is great if you want to set exact times for pick-up.  If you don't you have to set it so people pick a day (with a large time window say 8-4pm) and then tell people that you will email them when their order is ready.  That's what we're doing.


https://apps.shopify.com/safe-curbside-pickup

Kromannian
Tourist
4 0 8

Just wanted to surface this again. This is a fairly large limitation of the pick-up functionality — currently it's not really useful for us, unfortunately.

Excan-Nick
Excursionist
12 0 2

Just another merchant here looking to share inventory between locations. Disappointed Shopify seems to have just developed the bare minimum for local pickup functionality.

SeanMullins
Tourist
4 0 4
Unfortunately they don't appear to be assisting, despite the several
requests and comments on this ticket.

I make the assumption that they prefer making money from the third party
developers that have created apps to manage this.

Unfortunately for us, despite our best efforts we have had to resort to
paying more for said app to manage this.

I feel your pain.
Excan-Nick
Excursionist
12 0 2

What app did you end up going with?

SeanMullins
Tourist
4 0 4

https://apps.shopify.com/store-pickup-2

 

It has been a godsend!

SeanMullins
Tourist
4 0 4

Unfortunately they don't appear to be assisting, despite the several requests and comments on this ticket. 

 

I make the assumption that they prefer making money from the third party developers that have created apps to manage this. 

 

Unfortunately for us, despite our best efforts we have had to resort to paying more for said app to manage this. 

 

I feel your pain. 

PaulNewton
Shopify Partner
6274 573 1319

@SeanMullins wrote:

I make the assumption that they prefer making money from the third party developers that have created apps to manage this. 


It's a bad assumption, creates false expectations and is a trap.

Shopify cannot be all things to all businesses, no ecommerce platform can.

Apps fulfill deeper requirements than the basic features a platform offers.

Shopifys built to meet the overlapping minimum needs of over a million different businesses.

i.e. most features are built to the least common denominator not the most specific.

 


@SeanMullins wrote:

Unfortunately for us, despite our best efforts we have had to resort to paying more for said app to manage this. 


Apps, services, lawyers & accountants MAKE a business money; viewing those things as a negative  instead of as investments to improve a businesses processes only serves to creates a weird mindset that first resents and then falls into the trap of avoiding using available solutions that can streamline operations or outright increase revenue.

Avoid that trap.

 

 

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


PaulNewton
Shopify Partner
6274 573 1319

Really in this situation merchants may need a group of apps|services to build this process , or to build a custom app.

Hoping a single off-the-shelf app meets all requirements, or expecting shopifys entry-level local pickup feature to solve specific business logistics rules is not the approach here. 

 

 

@Kromannian 

Some common apps 

https://apps.shopify.com/local-delivery-1 

https://apps.shopify.com/click-and-collect by zapiet

These apps mainly work by gathering location information early in the /cart instead of checkout(which isn't modifiable on standard plans).

 

@Excan-Nick just another merchant here looking to share inventory between locations

See my response about using an automation app like usemechanic to sync inventory

 

More advanced usage would be to create custom draft orders, such as swapping in variant.ids for a location chosen on the cart page if different from what's in the customers cart.

 https://tasks.mechanic.dev/create-a-draft-order-from-the-cart 

 

 

There's also creating a custom carrier service app to surface location selection in the checkout.

https://shopify.dev/api/admin-rest/2021-10/resources/carrierservice

 

While Shopify Plus stores can modify checkout liquid to try and present location information but that doesn't create shipping choices on the fly so even those stores may need a carrierservice app.

 

 

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


kingstore
Shopify Partner
175 5 31

@JRogers410 @SeanMullins @Kromannian Given the complexity of this order process it's likely you need to combine possibly two different apps together. One which will handle the interface to select a pick up location, and another to manage the inventory and logic for order allocation. 

 

You can't accomplish this easily because it's more of an advanced logistical setting where this would apply, even if it is a 'smaller' operation. That said, there are a few solutions out there that might handle a part of this.

My suggestion is to work with a developer to handle the storefront interface side, then utilize SKUSavvy on the backend to handle a central inventory, then allocate orders to their respective warehouse for pick up. 

 

SKUSavvy is a Shopify WMS app that will manage all inventory across any warehouse or store, as well as enable you to pick and pack orders for delivery at a secondary store for pickup. Your central stock is managed with bin locations so you can use any mobile device to put-away products to bins, replenish bin locations, reorders product based on movement, pick order batches on warehouse layout map, pack orders, and print shipping labels (for orders not being picked up). For this reason, we put this option in for a few merchants that are requesting it. 

 

If it's something you'd like to customize for your (and perhaps others) store, please reach out and we can see about finalizing an optimal solution.

kingstore_0-1645034451867.png

 

The best Shopify Inventory Management App: Purchases, Bin Locations, Visual Inventory, Warehouse Management, Pick Pack Ship, Cycle Counts, and more.
Get your first SKUSavvy Mobile Inventory and Order Fulfillment account free for 50 orders
Schedule a call

KristenDScott
Excursionist
33 1 47

Hey there... I don't know if you have figured out a way to fix this, but I think I've found a sort of workaround. I changed the language of the check out process to include both the words "shipping" and "drop-off service", so the customer hopefully knows to choose it when checking out (instead of pickup). We still have a local pickup at the shop, so I keep that.

 

We have a drop off service at a location where I don't want to create a new inventory, so I created a free shipping rate that has the name of the location on it. What you do have to modify are some of the language parts of the check out process, which can be found in the Languages area when you go to customize your site. I like to find it on the Themes page/Actions button (next to Customize)/ and then choose Edit Language. There you can start to modify any part of the Cart verbiage/language to reflect your delivery service. Hope this helps.

User_999
Shopify Partner
18 0 1

Rather than using the "local pickup", which takes stock from stores and limits customer collection options when stock can be moved between stores. Is it possible to use the normal shipping rates and setup a free rate titled "collection from store X", and another "collection from store Y".... etc etc then stock is allocated from either store?

Are there any issues with doing this?

KristenDScott
Excursionist
33 1 47

@User_999 Yes, there is an issue if you use the "Send Notification to Customer" and "Mark as Picked Up" features. Once you have an order that is configured for shipping, there is no way to change it in order to use those features. You have to manually alert the customer that their order is ready. 

BTO2
Excursionist
21 0 6

We only have one pick up option - so I don't know if this will work for 4, as in your situation.  We deliver from the warehouse to the store - as people order online.  They can purchase for pick up at the store.  On our end, that means that every product is available in all locations and that we click in Shopify "track quantity" and "continue selling when out of stock"... With a negative number of products - we know how many we sold that were picked up.  Unfortunately, we have to manually zero these out once a year.

jeakley
Not applicable
1 0 0

Exactly the same problem.  You would have thought it would have been figured out.  We pay for POS for all of our stores and our warehouse.  We pay enough to shopify to warrant a solution.  I really doesn't seem like a big ask.

 

Freesoulpt
Visitor
2 0 1

Did anyone heard back from Shopify on this limitation?