How to find amount of stock in specific warehouse?

Amazon mislabeled some of my products because they supposedly could not scan the bar codes. (Which is weird because the packaging hasn’t changed in a decade, and we have never had this problem before)

I have been able to track down where all the mislabeled inventory is.

  1. How do I see how much of a particular ASIN is at a specific warehouse? I have been poking around reports and can’t seem to find this information.

  2. How do I create a removal order of JUST the inventory at a particular warehouse?

There is no way I can get support to understand and then make the warehouse do a bin check to ensure the product is labeled correctly. The less stressful option is to pull back the offending stock

Thanks for your help!

2 Likes

I don’t believe you can.

4 Likes

Not possible. Trust me I would have done this with returns over the past 8 years if I there was any way possible.

Also, you realize that inventory is always getting shuffled, and what you know today might well no longer be true tomorrow.

Gotta get them all, or none.

6 Likes

The Inventory Ledger probably offers up the closest approximation of this, but even it is somewhat problematic, largely for the reason our friend @aerides astutely states:

3 Likes

But the shuffling is tracked by the same Inventory Ledger. If you sort the darn thing by date, you can see the moves.

Here’s a question, how to get Amazon to destroy stock, all with a specific unique FNSKU, that has expired in the time that it has been “lost” in various Amazon warehouses? Can one say “everything you find with this FNSKU is expired, so do NOT put it into inventory”?

1 Like

You would have to periodically create a new SKU and then stop selling that SKU/FNSKU.

2 Likes

Link:

https://sellercentral.amazon.com/reportcentral/LEDGER_REPORT/0

3 Likes

Yes, did that, but as Amazon finds items, they automatically put the stock into inventory. I don’t want to close that FNSKU, but I don’t use it any more, and the inventory is zero, except for lost stock Amazon finds.

1 Like

If you delete the SKU from your inventory it won’t sell. It’ll just go to stranded where you can then dispose of it.

2 Likes

I have basically realized all this. I wanted to ask them to do a bin check across the network, but there are way too many ways people could do a half ***ed job of it and just look at the label and not cross reference it to the actual product the label is on. Soooo… pulling all the stock back it is.

2 Likes

I don’t think they’ll do that anyway. I think they check at most a few units during a bin check, it’d be far too labor intensive to check every unit.

1 Like

What sucks about all of this is that no matter what, Amazon would blame me for their screw up. Yeah, I know, it’s the cost of doing business with the Devil himself, but still sucks.

4 Likes

OK, but if they lost it, and the expiration date comes up before they find it, then they own it, and cannot charge me for destruction, nor can they sell it as an “Amazon Whorehouse Deal”, correct?

2 Likes

No, it’ll just go back to your inventory, maybe as fulfillable, or expired (if they may have noticed it is expired).

If they previously reimbursed you for it they can take back the reimbursement now that they found it. The fact the item is now expired is your problem.

1 Like

What? They can lose something until it is expired, and have zero liability for finding it a year or 2 later?

2 Likes

yes. If they find something they previously reimbursed you for, they will claw that back no matter what they find now.

2 Likes

And hence we see the wisdom of creating a separate entity for doing Amazon sales. Looks like it is time to shut down the current entity, and start up another. As Steve Miller Band sang “Go on, take the money and run”.

1 Like

:arrow_heading_up: :arrow_heading_up: :arrow_heading_up: :arrow_heading_up:

THIS.

From where many of us sit, This IS THE Way.