A product becomes not profitable when its COGS and its share of the expenses are higher than its revenue. You may still want to keep the product (it is called a lost leader) because its presence could attract customers to purchase more profitable products, but as a general rule you would want to “fix” this problem in one of the following ways:
Related Questions:
How do I change the price for a product?
How do I change the number of units that I expect to sell?