1 Order with Inventory from 2 warehouses - Needs two separate labels - Order splits automatically

[ColeGolfs]

We have 1 warehouse in the USA and another located in Canada. We sell products from both in our shopify store, and just recently began implementing their "multiple location inventory" features which are very handy as it splits the items on each order based upon which warehouse needs to fulfill it. My issue is with each warehouse getting their shipping labels and knowing what items to ship as it is not feasible to go into each order manually and create two separate labels as there are too many orders to make this possible. We had previously been using Shipstation which pulls in the Shopify order, but does not receive any details from shopify regarding the different shipping locations of the items, and lumps them together. As for right now, I am having to split these orders in shipstation manually, and create the labels for the USA warehouse. I then have to go into a second Shipstation account for the Canadian locationg (They make you use separate accounts for different countries) and have to manually create each order for the items being fulfilled by Canada Warehouse. I know there must be some other sellers which have multiple warehouses and do not have to do everything manually. I would really appreciate some input as to what others do with having two warehouses and needing to create shipping labels for each. Thank you so much!

Here is the order after import within shipstation showing that is is still combined:

Picture showing that the order is still all together within shipstation after import

Here is the order in Shopify showing that it is split based on warehousing location prior to import into shipstation:

Picture of Shopify order prior to importing into shipstation

[adhdmohit]

I am having the exact same issue as you. Any chance you were able to get it to split in shipstation? Hope we can figure this out... my other solution is to have the other warehouse ship first. 

[ColeGolfs]

We have worked with both Shipstation and Shopify on this issue. As of
4/20/2020 Shipstation does not support this feature. When shipstation
fulfills an order, they send a notice to Shopify to mark the order as
fulfilled. The issue is that the message they send to shopify is not item
specific, so it fulfills the entire order regardless of what you do or how
the order is split in shipstation. I would happily move to another shipping
manager if anyone manages to solve this issue.

[saml12345]

Did anyone resolve this? I'm encountering the same issue and was told that the current best workflow was the split the order in shipstation then fill the complete part. Not sure it'll split across accounts easily 

[NyteShade713]

Have you tried programming the Ship from location into Shipstation?

[ColeGolfs]

Yes, there is no workaround within shipstation. We have moved to using an inventory management system called duoplane. Now all orders go from shopify to duoplane. Duoplane then sends the associated items and orders to the proper shipstation accounts as it is programmed where the items are located. With the current setup in Shopify and Shipstation, an inventory management system seems to be the only answer. 

[saml12345]

I found a workaround, I setup an azure function that that listens for webhooks from SS, the basic flow is: 

- SS auto-action on order import = set location to "NO SHIP-FROM LOCATION" 

- listen for "neworder" webhook from SS

- query shopify for complete data on that order

- filter out fulfilled rows 

- get location/per row(line item)  

- if count of unique location ID's > 1 = set SS tag "multi-locaiton shipment" - prompts warehouse to split manually. In my case this is sufficient, you could probably expand it to split the order for you though. 

- else match SS ship-from with Shopify location and update order in SS 

[Robbie3]

We have the same issue.   Below is our scenario...

• We run an ecommerce store selling earrings. 
• We also attend 1 trade show a month and sell there.
• So we have 2 inventories.
• When we're not at a weekend trade show, we'd like to be able to fulfill from our trade show inventory because it's stored at the same location as our ecommerce warehouse. 
• The problem
  • When you fulfill from two locations it creates two shipping labels.  
  • When you tell Shopify to fulfill from one location it no longer accurately updates the trade show inventory.  It only deducts from the location you're fulfilling from.  

[saml12345]

@Robbie3 re-reading your post now.

Could you maintain one inventory most of the time and temporarily remove items for the trade show and then re-add them once the trade show is over? (anything that doesn't sell at the show gets re-added to the primary inventory after) 

Could you adjust your inventory in Shopify prior to shipment prior to shipment so that the +1/-1 issue doesn't happen? 

I messaged you about a programatic solution, but this might be easier at the end of the day. 

[Robbie3]

@saml12345 Thanks for taking the time to respond and help.  I sure appreciate it.  We have thousands of variants that we take to a show so adding/removing, duplicating products, etc. just would be to time intensive.  But, good thinking outside of the box!

I'm going to look into the Azure functions to see how that might work.  I think Ship station would work though... After rereading the post here it seems the flaw for the thread poster is actually our solution!