A product can sell hundreds of units every month and still lose money for a business. At first glance, strong sales figures may suggest that everything is working well. However, once you account for purchasing costs, warehouse expenses, delivery charges, discounts, returns, and other operating costs, the actual profit may be much lower than expected.

This is a common challenge for growing businesses, particularly those managing large product catalogs, multiple warehouses, or different sales channels. Businesses exploring ERP Solutions in Dubai can benefit from integrated financial and inventory data that helps them understand which products contribute to profitability and which quietly reduce it. Instead of relying only on sales volume or revenue, companies can use Enterprise Resource Planning (ERP) systems to evaluate the financial performance of individual products and make better-informed decisions.

The real value of ERP financial data lies in its ability to connect information that would otherwise remain scattered across spreadsheets, accounting software, purchasing records, and inventory systems. When these details are analyzed together, businesses can identify hidden costs, investigate declining margins, and determine whether a product deserves more investment or a different strategy.

Why High Sales Do Not Always Mean High Profit

Sales revenue is an important business metric, but it does not tell the complete financial story. A product may generate substantial revenue while delivering only a small contribution toward covering business expenses.

Consider a product that sells for AED 200. If its purchase cost is AED 130, the initial gross profit appears to be AED 70. However, additional expenses may include AED 15 for shipping and handling, AED 10 for sales commissions, AED 8 for packaging, and AED 12 in average return-related costs.

After these expenses, only AED 25 remains before other applicable operating expenses.

If the business offers frequent discounts or experiences higher-than-expected returns, that remaining margin can disappear quickly.

This is why businesses need to look beyond revenue and examine the costs associated with selling each product. ERP financial data helps bring these figures together, making it easier to distinguish products that generate genuine value from those that simply create sales activity.

1. Analyze Product-Level Profit Margins

The first step in identifying unprofitable products is to examine how much profit each product generates after accounting for its direct costs.

An ERP system can combine sales transactions, purchase prices, inventory valuation, and relevant expense records to provide a clearer picture of product profitability.

Calculate gross profit and gross margin

Gross profit measures the difference between sales revenue and the cost of goods sold.

Gross Profit = Net Sales Revenue − Cost of Goods Sold

Gross margin expresses that profit as a percentage of net sales revenue.

Gross Margin (%) = (Gross Profit ÷ Net Sales Revenue) × 100

For example, imagine two products with the following results:

Both products generate the same revenue, but Product A produces significantly more gross profit.

Product B is not necessarily unprofitable at this stage. However, its lower margin means there is less room to absorb additional selling and operating costs.

Compare margins across the product catalog

Review margins by SKU, product category, brand, and product variant. Look for items that consistently perform below your target margin or have experienced a sudden decline.

An ERP dashboard can help finance and sales teams identify these products without manually reviewing thousands of transactions.

The objective is not simply to rank products from highest to lowest margin. It is to understand why certain products perform poorly and whether the problem can be corrected.

2. Include Hidden Costs in Product Profitability

One of the biggest mistakes businesses make is calculating product profit using purchase cost alone.

A product may appear profitable because its selling price exceeds its purchase price. However, several additional expenses can reduce or eliminate the expected return.

Identify costs beyond purchasing

Depending on the business model, relevant costs may include:

• Inbound freight and import duties.
• Customs clearance and transportation charges.
• Warehouse storage and handling.
• Packaging and labeling.
• Sales commissions and marketplace fees.
• Delivery subsidies and fulfillment expenses.
• Returns, refunds, and damaged inventory.
• Product-specific promotional discounts.

For UAE trading companies, landed costs can be especially important when importing goods from international suppliers. Freight, insurance, customs duties, and other import-related charges can materially change the actual cost of inventory.

ERP financial data can help allocate appropriate costs to products, shipments, or inventory batches, depending on the system's capabilities and configuration.

For example, a company importing electronic accessories might discover that a product with a healthy purchase-price margin becomes much less profitable after freight, customs charges, and local distribution costs are included.

Separate direct and shared costs

Not every business expense should be assigned directly to an individual product.

Direct costs can often be traced to a specific item or transaction. Shared expenses, such as warehouse rent, general administration, or facility utilities, may require an allocation method.

Businesses should choose allocation methods that reflect how resources are actually consumed. Allocating every shared expense equally across all products can distort profitability and lead to poor decisions.

A practical approach is to calculate direct contribution first, then use a consistent and transparent method to estimate fully allocated product profitability where appropriate.

3. Use ERP Data to Investigate Discounting

Discounts can help attract customers, clear excess inventory, and increase order volumes. However, frequent discounting can also hide weak pricing decisions.

A product may appear successful because it sells quickly, even though discounts leave very little profit on each transaction.

Compare list prices with actual selling prices

ERP sales records can help businesses compare standard prices with realized prices after discounts, rebates, and applicable adjustments.

Review products that regularly sell below their intended price. Then investigate whether the discounts come from approved promotions, individual sales negotiations, seasonal campaigns, or pricing errors.

For instance, a distributor might sell a product for AED 150 against a standard price of AED 180. If its total variable cost is AED 135, the business earns only AED 15 before other costs.

At the standard price, the same product would generate AED 45 before those additional costs.

The difference is substantial, especially when hundreds of units are sold.

Measure the profitability of promotions

Before repeating a promotion, compare its additional sales and contribution with the discounts given.

A promotion that increases sales volume but reduces total contribution may not be worthwhile. On the other hand, a discount can make commercial sense if it helps clear aging stock, reduces storage costs, or attracts profitable repeat business.

The important point is to evaluate promotions using financial outcomes rather than sales volume alone.

4. Identify Products With High Return Rates

Returns can turn an apparently profitable product into a financial burden.

When a customer returns an item, the business may need to process a refund, pay reverse logistics costs, inspect the product, repackage it, or write it off if it cannot be resold.

Some returned items may also lose value because of damaged packaging, missing components, or changing market demand.

Connect returns with product-level financial data

Use ERP reports to compare return rates, refund amounts, replacement costs, and return-related expenses across products.

A product with an unusually high return rate deserves further investigation. The underlying cause could be poor quality, inaccurate product descriptions, unsuitable packaging, supplier defects, or customer expectations that do not match the actual product.

For example, a home appliance might generate strong sales but experience frequent returns because customers struggle with installation. Improving instructions or providing clearer product information could reduce the costs without changing the product itself.

It is also important to distinguish between return frequency and return value. A small number of expensive returns can have a greater financial impact than many inexpensive ones.

5. Examine Slow-Moving and Aging Inventory

Products that remain in storage for extended periods can tie up working capital and create additional expenses.

Even when their recorded inventory value remains unchanged, slow-moving items may become less valuable over time. Technology products can become outdated, seasonal goods can lose demand, and certain materials may deteriorate.

Use inventory aging reports

ERP inventory reports can categorize stock according to how long it has remained unsold. Common aging intervals include 30, 60, 90, and 180 days, although the appropriate periods depend on the product category and sales cycle.

Combine aging reports with product-level sales, margin, and purchasing data to identify items that require attention.

Look for products that have:

• High inventory quantities but consistently low sales.
• Declining demand across recent periods.
• Repeated purchases despite existing excess stock.
• Low margins that cannot support further discounting.
• Expiration, obsolescence, or impairment risks.

A slow-moving product is not automatically unprofitable. Some spare parts, specialist components, and seasonal products naturally sell less frequently. The key is to determine whether the financial return justifies the capital and storage space tied up in inventory.

Where appropriate, finance teams should also assess whether inventory write-downs or impairment adjustments are necessary under the applicable accounting requirements.

6. Compare Profitability Across Customers and Sales Channels

Sometimes the product itself is not the problem. The way it is sold may be reducing its profitability.

The same product can deliver different financial results depending on the customer, sales channel, delivery location, order size, and payment terms.

For example, selling a product to a large wholesale customer may involve a lower unit price but minimal delivery and selling expenses. Selling the same item through an online marketplace may involve platform fees, promotional spending, packaging, and individual deliveries.

The wholesale transaction could therefore produce a higher contribution despite generating less revenue per unit.

ERP systems can help connect product transactions with customer accounts, sales channels, and relevant expenses.

Build a more complete profitability view

Compare products across dimensions such as:

• Customer or customer segment.
• Retail, wholesale, and online sales channels.
• Geographic market or delivery region.
• Order size and frequency.
• Discounts, commissions, and fulfillment expenses.

This analysis helps businesses avoid removing a product that performs well in one channel simply because it performs poorly in another.

It can also reveal opportunities to revise minimum order quantities, delivery charges, customer pricing, or channel-specific promotional policies.

7. Create ERP Dashboards That Highlight Financial Risks

Manually reviewing financial reports every month makes it difficult to respond quickly when product profitability changes.

An ERP dashboard can bring important indicators together so finance, purchasing, inventory, and sales teams can identify potential problems earlier.

Useful dashboard metrics include:

Set thresholds that reflect your business model. For example, a product margin falling below an agreed target could trigger a review, while a sudden increase in return rates could prompt a quality investigation.

Dashboards are most useful when they encourage action rather than simply display numbers. Each warning should help a team understand what needs to be investigated and who is responsible for addressing it.

8. Turn Financial Insights Into Practical Business Decisions

Identifying an unprofitable product is only the beginning. The next step is to decide what to do about it.

Removing every low-margin product may be a mistake. Some items attract customers who also purchase higher-margin products, complete a product range, or support important long-term customer relationships.

Instead, classify underperforming products according to the cause of their weak financial results.

When to improve pricing

Consider a price adjustment when costs have increased, competitors support higher prices, or discounts have become unnecessarily frequent.

Before making changes, assess customer sensitivity and competitive conditions.

When to negotiate with suppliers

If purchasing costs are the primary issue, review supplier terms, order quantities, freight arrangements, and available alternatives.

However, larger orders should only be considered when the expected savings outweigh the additional inventory holding costs and demand risks.

When to reduce costs

If fulfillment, packaging, returns, or handling expenses are too high, investigate the underlying operational issue.

A packaging improvement or more efficient delivery arrangement may restore profitability without increasing prices.

When to discontinue a product

Discontinuation may be appropriate when a product consistently generates negative contribution, demand is declining, supplier costs cannot be improved, and there is little strategic value in retaining it.

Before making the final decision, consider contractual commitments, replacement products, customer expectations, and the financial impact of clearing remaining inventory.

9. Improve the Accuracy of ERP Financial Data

Even the most sophisticated ERP reports cannot produce reliable profitability insights when the underlying data is incomplete or inaccurate.

Incorrect product costs, outdated selling prices, inconsistent SKU records, missing freight allocations, and delayed transaction entries can all distort financial results.

To improve reporting accuracy:

1. Standardize product codes and descriptions across purchasing, sales, and inventory records.
2. Review how landed costs and inventory expenses are allocated.
3. Reconcile inventory records with physical stock counts.
4. Ensure sales discounts, returns, and credit notes are recorded correctly.
5. Establish a regular schedule for reviewing product costs and margins.
6. Assign responsibility for investigating unusual financial changes.
7. Confirm that dashboards use consistent definitions of profit and cost.

It is also important to distinguish between accounting profit, gross profit, contribution margin, and fully allocated product profitability. These measures answer different questions and should not be treated as interchangeable.

For example, a product with a positive contribution margin may help cover fixed business expenses even if its fully allocated profit appears negative. Understanding this distinction prevents managers from making decisions based on misleading comparisons.

Conclusion

Identifying unprofitable products requires more than checking which items sell slowly or generate low revenue. Businesses need to examine product margins, hidden costs, discounts, returns, inventory aging, and differences across customers and sales channels. ERP financial data makes this analysis more practical by connecting information that would otherwise remain scattered across departments.

Start by reviewing your lowest-margin products, investigate the reasons behind their performance, and establish a consistent process for monitoring profitability. Then use those insights to improve pricing, negotiate better supplier terms, reduce avoidable costs, or discontinue products that no longer make commercial sense.

With accurate data and regular financial reviews, businesses can focus on products that support sustainable growth rather than simply increasing sales volume. ERP 360 can be a useful starting point for businesses exploring how integrated ERP information can support better financial visibility and more informed product decisions.