How do I sell same product from different locations and update stock levels

destileriabarak
New Member
3 0 0

I have same product on two locations.

Im looking on how to use Shopify as my inventory system linked to Quickbooks.

So example if I sell beer and i have 100 cans on location and same beer 50 on location B.
So when a customer orders we will deliver the beer from whatever is the closest location and then the inventory must reflect that.

Because when i look at products i can only choose that product to be on one location, so i dont get how i can achieve above control.

Replies 5 (5)
JoesIdeas
Shopify Expert
1646 141 421

I don't think there's a way to do this natively with Shopify but if you're open to using an app, Order Automator can do this.

 

The app is customizable, and I'm the lead developer so if you need help just message me or in the app support ask for Joe. We can create a custom rule based on your parameters to have orders / products automatically change location depending on the shipping address.

 

• Creator of Order Automator (automation app to save you and your team time on admin tasks)
• Shopify developer for +10 years
• Contributor at Speed Boostr (Shopify optimization / dev team)
• Guy who likes to help people
destileriabarak
New Member
3 0 0

Thank you, I will have a look at your APP.

 

Its interesting that this feature might not exist as its very basic programming for SHOPIFY to be able to have same product and then stock levels on that product at several locations and upon fulfilling the order there could be a drop down where the person pressing that fulfilment button can choose where the products are fulfilled from and then the stock levels are updated on those locations.

JoesIdeas
Shopify Expert
1646 141 421

@destileriabarak that you can do already - changing locations - here's how: https://help.shopify.com/en/manual/locations/managing-orders#changing-the-fulfillment-location

 

You had asked earlier about fulfilling from the closest location, that's a different challenge and not possible with Shopify without an app.

 

If you're not familiar with setting up locations, here's the documentation on that: https://help.shopify.com/en/manual/locations

 

Try setting up multiple locations, then do a test order and change the location, that may be sufficient for you. If your order volume is low or you have someone doing manual order management I think this solution would be perfect (and free :D).

• Creator of Order Automator (automation app to save you and your team time on admin tasks)
• Shopify developer for +10 years
• Contributor at Speed Boostr (Shopify optimization / dev team)
• Guy who likes to help people
MsSkeptical
Excursionist
35 0 12

Hhhhhmm I'd suggest one way is to use an inventory management tool like Stitch Labs and integrate it on Shopify using Cartrover, which will help you keep track of stock levels and automatically update when products are sold from one location. I remember my friend's furniture store - he sells the same mid-century pieces in the US - but in different states. But he eventually gave up cause it wasn't syncing well.

 

So he went for just creating a separate product listing for each location, and set the stock level to 0 when the product is sold out at that location. This will ensure that customers don't purchase products that are out of stock at a specific location. 

HotWax-Commerce
Shopify Partner
30 2 5

This is possible with the HotWax Commerce Omnichannel Order Management System, which handles the heavy lifting of synchronising inventory across multiple locations (stores and warehouses), allocating inventory to customer orders, and routing them to the fulfilment location nearest to the customer.

After HotWax Commerce Order Management System is introduced into your tech stack, it becomes the one true source of real-time inventory for all systems that require user-facing inventory information (internal or external). From this point forward, Shopify should rely solely on the OMS for up-to-date inventory data.

When an eCommerce order is placed;
Shopify will deduct inventory from the default eCommerce fulfillment location for all new orders. After the OMS imports new orders, it routes them to optimal fulfillment locations (stores or warehouses) and adjusts inventory levels for those locations internally. This ensures that customers get accurate store inventory when placing Buy Online, Pick-Up In Store (BOPIS) orders.


BOPIS orders placed on Shopify will still deduct inventory from the default fulfillment location. Since these orders do not require routing, their inventory will be deducted as soon as they are imported into the OMS. After inventory levels have been adjusted in the OMS, the system will use the same APIs to restore inventory in the default fulfillment location and deduct inventory at the store selected for pick up.

Also, you can learn about how inventory is deducted in case of POS orders and returns and exchanges in this blog in detail- Integrating Your Omnichannel Order Management System With Shopify

Let's talk about how HotWax Commerce can best help you in this scenario. [Connect with us]