Meltable Season is Approaching! How to Identify Your Meltable ASINs

"To meet product quality standards during the warm summer months, we won’t accept meltable inventory at our fulfillment centers between April 15 and October 15, 2023.

Meltable refers to all heat-sensitive products, such as chocolate, gummies, and select jelly- and wax-based products.

Meltable products that are stored or arrive at our fulfillment centers after April 14, 2023, will be disposed of for a fee. For more information, go to FBA removal order fees. To avoid disposal, you can either submit removal orders or aim to liquidate your meltable inventory before April 15 by running sales.

If you believe your ASIN should be exempt from the list of meltable ASINs, you can provide confirmation that the product can be stored at a maximum temperature of 155 degrees Fahrenheit for extended periods.

To confirm whether your inventory is on the list of meltable ASINs at-risk for disposal, submit a removal order, or request an exemption, go to Meltable FBA Inventory."

Once you have the spreadsheet with the list of meltable ASINs from Amazon at the link above, import it into a new Google Sheets file. You can then compare this to your active inventory by exporting your list of active inventory.

To do this, navigate to the Seller Central menu and select Reports>Inventory Reports:

Once there, select Active Inventory in the drop down menu: 

Click Request Report and wait for the report to process.

Once it is ready, click the download button and open the file. This will be a .txt file. 

Select All of the information and Copy it.

Next, create a new spreadsheet in Google Sheets and paste the information into this spreadsheet. 

This will display the information in columns, and include a column for ASINs. 

Copy the information in the ASIN column and paste this into a blank column in the meltables spreadsheet you created earlier. 

You can also navigate to the bottom of the meltables ASIN column and add the ASINs from your active inventory to the same row.

Once you have your active inventory ASINs in the same row, or in another column in the same Google Sheet, you can use conditional formatting to identify duplicates.

The duplicates would be ASINs in your Active Inventory that are on the meltables list, and the items you would need to have removed if you don't want Amazon to dispose of them. 

This article from Zapier details how you can use conditional formatting in the Google Sheet to find the duplicates.