EN
Inventory and Products

How Do You Simplify Your Product Catalog? A Guide to Core, Mid and Long-Tail Products, Management Cost per Product, the Net Contribution Table, Criteria for Products to Drop and the Break-Even Point

How do you simplify a product catalog? Core and tail products, management cost per product, net contribution and the tipping point: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why does the catalog grow, and what does it cost?
  3. Lesson 2: How do you separate core, middle and tail groups?
  4. Lesson 3: How do you calculate monthly management cost per product?
  5. Lesson 4: How do you build the net contribution table?
  6. Lesson 5: Which products are removed, and which are kept?
  7. Lesson 6: What is the effect of removal, and what is the tipping point?
  8. Lesson 7: How do you remove products from the catalog in a controlled way?
  9. Lesson 8: How do you track catalog simplification?
  10. What are the most common mistakes in catalog simplification?
  11. How does NetKasam make catalog simplification easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Make every product earn its place with numbers
  14. Frequently Asked Questions About Simplifying a Product Catalog

As the catalog grows, it feels like the business is growing: more products, more options, more chances to sell. Yet every new product means a card, photos, a description, a price, stock counts, marketplace matching and customer questions. While most sales come from a small group of products, a long tail of the catalog may be producing nothing but management cost. Simplifying the product catalog means seeing this tail in numbers and deciding which products to remove and which to keep.

This article is not a lecture but an 8-lesson hands-on course. We will answer the question how do you simplify a product catalog using a sample business with 400 active products: splitting the catalog into core, middle and tail, calculating the hidden management cost per product, the net contribution table, the criteria for products to remove, the effect of removal on sales and the tipping point, taking products out of the catalog in a controlled way, and tracking metrics. At the end there is a mini quiz with an answer key. All figures are sample values chosen to illustrate the method; follow the same steps with your own data.

What will you be able to do by the end of this training?

In short: You will split your catalog into three groups, calculate management cost per product, build the net contribution table, decide with criteria which products to remove, and find the decision's tipping point.

Course mapSix steps of catalog simplification
  1. 01
    GroupSplit products into core, middle and tail by share of revenue.
  2. 02
    CostFind the monthly management cost per product.
  3. 03
    Net contributionSubtract management cost from contribution.
  4. 04
    SelectIdentify the products to remove with four criteria.
  5. 05
    TestCalculate the tipping point with a sales loss scenario.
  6. 06
    ApplyDeactivate the product, clear the stock, track.

The course's 8 lessons: (1) why the catalog grows and what it costs, (2) core, middle and tail groups, (3) management cost per product, (4) the net contribution table, (5) which products are removed, (6) the effect of removal and the tipping point, (7) how products are removed in a controlled way, (8) tracking metrics.

Lesson 1: Why does the catalog grow, and what does it cost?

In short: The catalog usually grows on its own; adding products is easy, removing them is hard. Every product carries a hidden cost paid to manage the catalog.

When you start working with a new supplier, a few products are added "as a trial." A customer asks about a product and it gets stocked. When sales open on a marketplace, all products are transferred there too. Each addition looks reasonable on its own, but none of them has a removal date. After a while, 200 of the 400 products sell only a few units a month, yet each still needs a product card, photos, shelf space, counting and price updates.

The cost shows up in two places. The first is direct labor: product card maintenance, counting, price and stock synchronization, customer questions. The second is indirect: as the number of products grows, counts take longer, the warehouse gets messier, shipping errors increase and the money tied up in inventory grows. For the cost of that tied-up money, see the article how to calculate inventory cost. Beyond everything else, good sellers can get lost in a long list.

Lesson 2: How do you separate core, middle and tail groups?

In short: Rank products by revenue from largest to smallest; the products bringing in the first 70% are core, the next 26% middle, and the remaining 4% tail.

In the sample business, monthly revenue is ₺2,000,000 and there are 400 active products. When we rank products by sales over the last 6 months, the table looks like this:

GroupNumber of productsMonthly revenueRevenue shareMonthly contribution
Core601.400.000 ₺%70,0420.000 ₺
Medium140520.000 ₺%26,0130.000 ₺
Tail20080.000 ₺%4,08.000 ₺
Total4002.000.000 ₺%100558.000 ₺
ChartRevenue by product group: 60 products bring in 70% of revenue
  • Core (60 products)₺1,400,00070%
  • Middle (140 products)₺520,00026%
  • Tail (200 products)₺80,0004%

Prepared with sample values. The groups total ₺2,000,000.

The result from the table is striking: 15% of the catalog brings in 70% of revenue, while half the catalog brings in only 4%. Contribution is distributed similarly; the tail's contribution is ₺8,000, about 1.4% of total contribution. Ranking by contribution rather than revenue is more accurate; we explained how to find product contribution in the article how to analyze product-level profitability. For the method that classifies products by value and sales, see also the article how to do an ABC analysis.

Lesson 3: How do you calculate monthly management cost per product?

In short: Management cost per product is the sum of product card maintenance, counting and warehousing, price and stock synchronization, customer and return questions, and capital tied up in inventory.

This figure should be calculated from your own business's records. In the sample business, the monthly cost per product, derived from staff hours and overheads, is as follows:

ItemHow does it happen?Monthly per product
Product card maintenanceDescription, photo and price updates150 ₺
Counting and warehouseShelf space, counting, loss and picking-error allowance150 ₺
Price and stock matchingSync errors across channels and their corrections100 ₺
Customers and returnsQuestions about the product and return processing100 ₺
Capital tied up in inventoryAverage stock per product × monthly cost rate100 ₺
Total600 ₺

150 + 150 + 100 + 100 + 100 = ₺600. The monthly management cost of 400 products rises to 400 × 600 = ₺240,000. This figure never appears as a single line on any invoice or in the books; it is spread across wages, rent and shrinkage. The method used to allocate overheads per product is explained in the article how to allocate overhead to products. To calculate the inventory carrying rate, you can use the article how to calculate the real cost of a business loan.

Lesson 4: How do you build the net contribution table?

In short: From each group's contribution, management cost is subtracted for the number of products. Net contribution shows which group really makes money.

GroupMonthly contributionManagement costNet contribution
Core (60)420.000 ₺60 × 600 = 36.000 ₺+384.000 ₺
Middle (140)130.000 ₺140 × 600 = 84.000 ₺+46.000 ₺
Tail (200)8.000 ₺200 × 600 = 120.000 ₺−112.000 ₺
Total (400)558.000 ₺240.000 ₺+318.000 ₺
ChartSubtracting management cost from monthly contribution: ₺558,000 in contribution drops to ₺318,000
  1. Catalog's total monthly contribution₺558,000
  2. Management cost of 400 products−₺240,000
  3. Net contribution₺318,000

Prepared with sample values. Total: 558,000 − 240,000 = ₺318,000. Group totals: 384,000 + 46,000 − 112,000 = ₺318,000.

The core group carries all the earnings: ₺384,000 net. The middle group is small but positive at ₺46,000. The tail, however, posts a monthly loss of ₺112,000; that is, the products' own contributions cover only 6.7% of their management costs (8,000 ÷ 120,000). Part of this loss is borne by the core products. You can follow how to treat selling costs in the contribution calculation in the article how to calculate profit margin.

Lesson 5: Which products are removed, and which are kept?

In short: A product is removed only if its contribution is below its management cost and it has no strategic role. All four criteria must be met.

  1. Contribution over the last 6 months is below the monthly management cost. In the example, below ₺600.
  2. Sales are declining or flat. A growing product is kept, even if it is low right now.
  3. It has no complementary role. Products that often accompany another product in the basket, attract first purchases or complete a category are kept.
  4. It can be replaced by a similar product. The customer can meet the same need with another product in the catalog.

When these criteria are applied to the 200 tail products, 140 products meet all four, and 60 are kept because they are complementary or growing. The total monthly contribution of the 140 products is ₺2,800 (an average of ₺20 per product), and that of the 60 kept products is ₺5,200 (about ₺87 per product). 2,800 + 5,200 = ₺8,000, consistent with the tail total.

Tail subgroupProductMonthly contributionDecision
Meets the criteria1402.800 ₺Remove
Complementary or growing605.200 ₺Keep and monitor
Total tail2008.000 ₺

To avoid losing profit when deciding, look at the baskets in which products are sold together. To examine average order value and product relationships, you can use the article how to calculate and increase average order value. To set aside non-moving stock beforehand, the method in the article how to clear dead stock can feed into the same work.

Lesson 6: What is the effect of removal, and what is the tipping point?

In short: Removing 140 products gains ₺81,200 a month. If the contribution of core and middle products falls by more than 14.8%, the decision turns into a loss.

The gain calculation: the management cost of 140 products, 140 × 600 = ₺84,000, disappears; the lost contribution of these products is ₺2,800. The net gain is 84,000 − 2,800 = ₺81,200 a month. The money tied up in these products' inventory is also freed; with average stock of ₺1,500 per product, 140 × 1,500 = ₺210,000 in cash comes back as the stock is cleared.

The real risk is that customers looking for the removed products also give up on the remaining ones. Measure this risk with the tipping point. The contribution of the remaining core and middle products is 420,000 + 130,000 = ₺550,000. If the rate of decline in this contribution is x, the gain is 81,200 − 550,000 × x, and it reaches zero at x = 81,200 ÷ 550,000 = 14.8%.

Decline in core and middle contributionContribution lostMonthly net result
%00 ₺+81.200 ₺
%15.500 ₺+75.700 ₺
%527.500 ₺+53.700 ₺
%14,881.200 ₺0 ₺
ChartThe monthly net result of removal shrinks as the remaining products' contribution falls
  1. Contribution decline 0%₺81,200
  2. Contribution decline 1%₺75,700
  3. Contribution decline 5%₺53,700

Prepared with sample values. Each result: 81,200 − 550,000 × decline rate.

The rule: if the contribution of core and middle products does not fall by more than 14.8% after removal, the decision is profitable. In practice, since complementary products are already kept, this decline is expected to stay around 1-2%; even so, monitoring for the first two months is a must. Map the effect of the removal decision on your sales target onto the calendar using the method in the article how to set and track a sales target.

Recommended readingHow Do You Analyze Product Profitability?

Lesson 7: How do you remove products from the catalog in a controlled way?

In short: Don't delete the product; deactivate it. First stop new purchases, clear the existing stock, then take the product off sale.

  1. Stop new purchases. No new orders are placed for the products to be removed. If there are open orders with the supplier, cancellation or reduction is discussed.
  2. Clear the existing stock. While the product stays on the list, the stock is sold through campaigns, bundles or a change of channel. For the calculation, you can use the articles how to clear dead stock and how to discount without losing money.
  3. Deactivate once the stock is gone. The product is not deleted; past sales, invoice and return records remain, and the product can be reopened if needed.
  4. Take it off sale. The product page and channel listings are closed; if there is a similar product, the product page redirects to it.
  5. Monitor for the first two months. Compare the contribution of core and middle products, basket size and customer questions.

Splitting the removal into three-month waves instead of doing it all at once spreads the risk: 50 products in the first wave, 50 in the second and 40 in the third. After each wave, the tipping point check from Lesson 6 is repeated. Where products are managed with variants on marketplaces, see the article how to manage products with variants on a marketplace to decide which variant to close.

Lesson 8: How do you track catalog simplification?

In short: Track five metrics every three months: number of active products, revenue per product, tail revenue share, tail net contribution and number of newly added products.

IndicatorHow it is calculatedSample value (before)
Number of active productsProduct cards open for sale400
Monthly revenue per productMonthly revenue ÷ Active products5.000 ₺
Tail revenue shareTail revenue ÷ Total revenue%4,0
Tail net contributionTail contribution − Management cost−112.000 ₺
Newly added productsNew cards opened in the periodTracked
Takeaways from the exampleFour numbers from the catalog simplification example
  • 70%share of revenue coming from just 60 products
  • −₺112,000monthly net loss of the 200-product tail
  • ₺81,200monthly net gain from removing 140 products
  • 14.8%contribution decline at which the decision turns into a loss

The most important rule in tracking is to set criteria for adding new products too: a new product is added only if it complements a core product, replaces an existing product or has measured demand. To size the first order for a new product, see the article how to set the initial order quantity for a new product. Otherwise, the tail grows back as much as you simplified it. To present the report regularly, add a catalog line to the format in the article how to prepare a weekly management report.

What are the most common mistakes in catalog simplification?

  1. Removing products only because their revenue is low. A product with low revenue that completes the basket may be feeding the catalog's core.
  2. Treating management cost as zero. Keeping a product looks free, but it uses labor and capital.
  3. Deleting the product immediately. Inventory and past records are left incomplete; it should be deactivated.
  4. Removing everything at once. The tipping point can't be tested; you need to proceed in waves.
  5. Reading sales data over a short period. A seasonal product looks like tail at the end of winter; look at at least 6-12 months of data.
  6. Not tracking after simplifying. The tail grows long again with newly added products.
  7. Not informing the supplier. Open orders and return rights may be lost.

How does NetKasam make catalog simplification easier?

  • Product-level sales and inventory movements. You see products' sales and outgoing quantities on record (inventory management).
  • Inventory turnover and cost report. You see inventory turnover rates and product expenses and report on your costs.
  • Single-screen order management. You track orders from different channels together and see whether products are sold together (order management).
  • Expense management. You record overheads and use them when calculating management cost per product (expense management).
  • Campaign module. You set up product- or category-specific campaigns to clear the stock of a product being removed.
  • Saved reports. You save the product-level sales report, export it to Excel and calculate the contribution table in your own spreadsheet (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If monthly revenue is ₺2,000,000 and the core group's revenue is ₺1,400,000, what percentage of revenue is the core group's share?
  2. If management cost per product is ₺600, what is the monthly management cost of a 200-product tail?
  3. If the tail's monthly contribution is ₺8,000, what is its net contribution (after management cost) in ₺?
  4. Removing 140 products eliminates ₺84,000 in management cost and loses ₺2,800 in contribution. What is the monthly net gain?
  5. If the remaining products' contribution is ₺550,000 and the net gain is ₺81,200, what is the tipping point as a percentage (one decimal place)?

Answer key:

  1. 1.400.000 ÷ 2.000.000 = %70.
  2. 200 × 600 = 120.000 ₺.
  3. 8.000 − 120.000 = −112.000 ₺.
  4. 84.000 − 2.800 = 81.200 ₺.
  5. 81.200 ÷ 550.000 = %14,8.

Frequently Asked Questions About Simplifying a Product Catalog

What is product catalog simplification?

It is identifying, against set criteria, the catalog products that don't cover their management cost and play no complementary role, and removing them from sale in a controlled way.

Which products are removed from the catalog?

Products whose contribution over the last 6 months stays below their monthly management cost, whose sales are declining or flat, that play no complementary role and that can be replaced by another similar product.

What does the management cost per product include?

Product card maintenance, counting and warehouse labor, price and stock matching corrections, customer questions and return processing, and the cost of capital tied up in inventory.

Is a low-revenue product always removed?

No. Even if revenue is low, products that complete the basket, attract first purchases or are growing are kept.

Should a product be deleted or deactivated?

Deactivated. Past sales, invoice and return records are preserved, and the product can be reopened if needed.

What does the tipping point show?

The rate above which a drop in the remaining products' contribution wipes out the gain from the removal decision and turns it into a loss. In the example, this rate is 14.8%.

Should removal be done all at once?

No. Splitting it into three-month waves and rechecking the tipping point after each wave reduces risk.

How often should the catalog be reviewed?

Every three months. The criteria for adding new products are reviewed at the same meeting; otherwise, the tail grows long again.

Conclusion: Make every product earn its place with numbers

The most useful thing you can do today is rank your products by contribution over the last 6 months and separate out the core that brings in 70% of revenue and the tail at the bottom. The next step is to estimate the monthly management cost per product, see the tail's net contribution, and take the products that meet the four criteria out of the catalog in three-month waves. Checking the tipping point after each wave makes sure the simplification is bringing in profit.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools