Wierd problem with stock values with multiple locations

Highlighted
Excursionist
16 1 2

Will try to explain my problem as simple as possible. We got 5 locations and one of those is our main location managed by a third party logistic firm (3PL). Lets call main location A and dropshipping locations B-E. 

  1. Order comes in for a product that is stocked at B (20 in stock) and has 0 in A. 
  2. 3PL pulls that order into their system as the product has both location A and B on it and deduct 1 from location A (now -1)
  3. We fullfill the order from within Shopify using location B and stock is down with one (now 19). 

Problem becomes exponational as we have 18 as sellable stock, when we infact should have 19. If we sell 10 we will infact have 0 and stop selling that specific product 50% ahead of time (panic). 

We get a return of the above order sent from B and that return ALWAYS goes to A. 3PL recieves the order and notice they have an unfullfilled order (as their system pulled the initial order data before it was fullfilled), issue an order and it goes out to the customer (a second time) and stock goes down with 1 more at A and we now also have to issue a 2nd return to get our product back. (if we even notice)

I don't know where the problem is. The app that pulls the data or the fact that we have to have (do we?) have two locations on all products (as any return will end up at A, no matter what location originally shipped the product). Also seems like the API isn't bi-directional so a Shopify fullfilled product will send a "ping" to the app to delete the dormant rest-order located inside the 3PL system. 

Basically they end up with as many rest-orders as we sell orders where location A is included on the Product (not the order) and that is obviously a catastrophy. 

How can I backtrack this is in best possible way to find what is causing this problem? Critical need of help...

0 Likes
Highlighted

Hi Lostper,

Based on what you have explained it sounds like the issue is how your cart integration is setup to your 3pl. This is how it is typically setup :

                  Shopify Shopping Cart

                                     I

                      Integration Software

                                     I
        3plwarehouse management software 

 

Location A,B,C,E  should have specific SKU’s that they download from your cart based on only what they stock at their location. If not they will download all your orders and diminish your inventory because they’ve pulled products that don’t exist at that location. It is a nightmare to fix but can be done, I recommend that all rest orders be electronically filled and process returns for all of them. When processing the return select the location that actually stocks the items in inventory, as the return address. This should replenish your inventory through the returns process.

I Operate a large 3PL, but we’re never big enough to answer questions. You can contact me directly if you ever need help.

Cheers,

Brian 

619.600.5202

www.3plwinner.com

 

0 Likes
Highlighted
Excursionist
16 1 2

Thx for the reply, but not really. We got an app, it is working, but there is no value to pair with it turns out. 

Found the .json addition (didn't know it worked in admin) 

Problem is much simpler and much bigger. The Shopify API has no info about stock location before you actually fullfill an order. This will make it impossible to do any type of integration or app for any store where you have stock of the same product on more than one location. 

As the key is "null" then every order (where a product has more than one location) will be fetched (correctly) as there is nothing in the API to distinghish the order lines

I have no clue why this isn't in the api per order, before it's fullfilled (as you can choose it in the dropdown in the backend) but it's not. 

We "cant" have unique skus as it's in fact the same products across multiple locations. We have our own stock of products that for example another location (the vendor) offer dropshipping from. So depending of split orders or not, we have to fullfill from different locations. Unique SKU's would add to the nightmare.

 

0 Likes
Highlighted

Check out this link, let me know if it helps.

 

https://help.shopify.com/en/manual/locations/assigning-inventory-to-locations

 

Best,

 

BR

0 Likes