Seller accounts meltable inventory
Amazon just sent out a bland email claiming meltable inventory will be removed from seller accounts:
We're writing to let you know that meltable inventory in Amazon fulfillment centers will be removed and disposed of for a fee starting April 15, 2023. You're receiving this email because you might still have inventory in an Amazon fulfillment center that's considered meltable.
There is no indication of which ASINs in our accounts are actually subject to this removal. After sifting through the seller help pages I was able to download an Excel list of all ASINs that Amazon classifies as "meltable" (the list link was buried at the end of one of the help pages). By "all ASINs" I mean a list of ~400,000 ASINs (yes close to half a million) that you are supposed to check against your own inventory ASINs. If you have 50 ASINs you have to search in the spreadsheet 50 times, or write a VLOOKUP formula that searches against a list of half a million cells for each one of your products, hoping Excel holds up.
How difficult it is for Amazon to actually show the ASINs that will be removed on each seller account?? In what year technology does not allow a corporation to write 2 lines of code to show each user account which SKUs are in danger of full disposal??
7 replies
Seller_AXC06kcsKI1qG
I thought that 99% it is more candy and chocolate they are referring to.
Is that what you are seeing?
Seller_oaRU9oxEaQxPL
If anyone is curious for the list of meltable ASINs, it can be found at the bottom of this help guide titled "Meltable ASINs (Excel)": https://sellercentral.amazon.com/help/hub/reference/202125070
An easy way to check is with conditional formatting to highlight duplicates. Download this meltable ASIN list, download an inventory report, add your ASIN list to the bottom of Amazon's meltable list and setup conditional formatting to highlight cells with duplicate values.
Then put a filter on your A1 to search for cells that are colored red. If nothing is red, you're in the clear.
TaylorR_Amazon
Hi @Seller_ODGnET55Q6yM6, I apologize for the difficulties searching the list. I will take your feedback to the team. Thank you for sharing!