eComHD · Amazon listings
Every eComHD child listing that did under $5,000 in the last 12 months. Scored so you can tell what's actually dead from the small stuff that still makes money. Listings already marked Discontinue are left out, so everything here is new. Each row shows its Master SKU.
Cutting by revenue alone doesn't work. Even after dropping the ones already marked Discontinue, 130 of 185 live listings did under $5k last year. That's 70% of the catalog, and most of them are just small, not dead.
Once you also check whether a listing still sells and whether it makes money, only 38 are worth cutting. They call for two different moves. A few whole product lines should go (every color dead, nothing left to keep). The rest are single colors to drop from lines you're keeping. Both lists are below.
Every under-$5k listing gets sorted by two questions: has it sold in the last 90 days, and did it make money over the year. That's enough to tell dead stock and money-losers apart from the small stuff that's fine to keep.
These are whole product lines where every color left is dead or losing money. Nothing healthy is holding them up, so the parent listing and all its colors go together. Each card lists the ASINs and Master SKUs that go with it.
These are single dead or money-losing colors that sit under a product line you're keeping. Drop the color, keep the line. The Parent column shows which line each one belongs to. The ⚑ means Amazon fees weren't fully counted, so that profit number runs a little high. Use the buttons to switch between these, the retire list, and everything live.
how much under-$5k sits in each brand
your hunch, checked against the numbers
You figured the tassel earrings were dead. Half of them were, and those colors were already marked Discontinue, so they aren't even in this list. What's left is a line that still makes money: 12 colors, $23.7k in sales last year, $5.1k profit, with Yellow and Pink still selling right up to now. Only 3 of the survivors are worth cutting. That's the whole reason you cut by color, not by product.
Bottom line: cut 3 colors, keep the line.
Two things to keep in mind.
Profit on the smallest listings runs a little high. Amazon fees are fully counted on 76% of sales. The other 24%, mostly old low-volume orders, is missing some fees, so those listings look slightly more profitable than they really are. If anything, that makes the case to cut them stronger.
Whether to liquidate or just delist depends on stock. A dead listing still holding FBA inventory is a liquidate-or-return call. One already at zero stock you just delist. This report ranks what to cut; it doesn't yet pull in on-hand inventory.