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:
Here is the order in Shopify showing that it is split based on warehousing location prior to import into shipstation:
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.
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
We have the same issue.
@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.
@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!