Tier Price is not being deleted from Configurable Product

[bhoopatparmar]

Preconditions (*)

1. Magento 2.4.6-p2
2. Magento 2.4-develop

Description (*)

The tier price for the configurable product isn’t deleted when a simple product is converted into a configurable product. The Actual price of a product is removed from the database but the tier price remains there in catalog_product_entity_tier_price. It will show the minimum price for the product at the front end even if any child variant of the product isn’t having any tier price. This can lead to a mismatch in the price. See the attached screenshots below.

Screenshot 1:
Here you can see in the screenshot that the simple product has the tier price in the table catalog_product_entity_tier_price.

Screenshot 2:
After Converting the simple product into the configurable product by creating the variants, you can see in the below screenshot that the tier price remains there. Even after removing the tier price from all its variants, it remains there in the table catalog_product_entity_tier_price.

These things lead in a way to mismatch of the price on a product page.
If you check the product on a category-page/listing-page, you will find the minimum price coming from the tier price available for a product. But when you visit the product page for the same and check all the variants, you will come to know that there is no minimum price available in any of the child variants of the product.

Steps to reproduce (*)

1. Create a simple product with a tier price.
2. Edit that simple product and convert it into a configurable product by creating some variants with a price greater than the tier price and make sure that any variant should not have any tier price.
3. Observe in the database that table catalog_product_entity_tier_price still has the entry for the particular product with the tier price.
4. Visit the particular product on a listing page and product page and observe the price.

Expected result (*)

The tier price of the configurable product should also get deleted when a product is converted from a simple product to a configurable product. It should show the minimum price of the variants instead of a tier price of the parent configurable product at the frontend.

Actual result (*)

The tier price of the configurable product is not deleted when a product is converted from a simple product to a configurable product. It is showing the tier price of a configurable product as a minimum price.

[m2-assistant]

Hi @bhoopatparmar. Thank you for your report.
To speed up processing of this issue, make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, Add a comment to the issue:

• @magento give me 2.4-develop instance - upcoming 2.4.x release
• For more details, review the Magento Contributor Assistant documentation.
• Add a comment to assign the issue: @magento I am working on this
• To learn more about issue processing workflow, refer to the Code Contributions.

---

Join Magento Community Engineering Slack and ask your questions in #github channel.
⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.
🕙 You can find the schedule on the Magento Community Calendar page.
📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, join the Community Contributions Triage session to discuss the appropriate ticket.

[m2-assistant]

Hi @engcom-Bravo. Thank you for working on this issue.
In order to make sure that issue has enough information and ready for development, please read and check the following instruction: 👇

• 1. Verify that issue has all the required information. (Preconditions, Steps to reproduce, Expected result, Actual result).
• 2. Verify that issue has a meaningful description and provides enough information to reproduce the issue.
• 3. Add Area: XXXXX label to the ticket, indicating the functional areas it may be related to.
• 4. Verify that the issue is reproducible on 2.4-develop branch
  Details

  - Add the comment @magento give me 2.4-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.4-develop branch, please, add the label Reproduced on 2.4.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!
• 5. Add label Issue: Confirmed once verification is complete.
• 6. Make sure that automatic system confirms that report has been added to the backlog.

[engcom-Bravo]

@magento give me 2.4-develop instance

[magento-deployment-service]

Hi @engcom-Bravo. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service]

Hi @engcom-Bravo, here is your Magento Instance: https://92c3a507a1b295faff5b1f69236a9cb7.instances-prod.magento-community.engineering
Admin access: https://92c3a507a1b295faff5b1f69236a9cb7.instances-prod.magento-community.engineering/admin_9bc9
Login: 5213daa0
Password: d149b8f41a15

[engcom-Bravo]

Hi @bhoopatparmar,

Thank you for reporting and collaboration.

Verified the issue on Magento 2.4-develop instance and the issue is not reproducible.Kindly refer the screenshots.

In Product listing page tier price is showing as expected but in Product detail page tier is not showing but when we select the Configurable product variants it is showing tier price as expected because the configurable product depends on their childs product so it looks like an expected behaviour.

Thanks.

[bhoopatparmar]

Hi @engcom-Bravo
Make sure that the Configurable product variants don't have any tier price. Once the simple product is converted into a configurable product with some variants and the variants are having the same price as the parent product, it will add the same tier price as the parent product to all the variants. So kindly remove the tier price from Configurable product variants. and then if you check tier price will not get deleted for the parent configurable product.

[engcom-Bravo]

Hi @bhoopatparmar,

Thanks for your update.

Verified the issue on Magento 2.4-develop instance and the issue is reproducible.Kindly refer the screenshots.

Steps to reproduce (*)

• Create a simple product with a tier price.
• Edit that simple product and convert it into a configurable product by creating some variants with a price greater than the tier price and make sure that any variant should not have any tier price.
• Observe in the database that table catalog_product_entity_tier_price still has the entry for the particular product with the tier price.
• Visit the particular product on a listing page and product page and observe the price.

The tier price of the configurable product is not deleted when a product is converted from a simple product to a configurable product. It is showing the tier price of a configurable product as a minimum price.

The issue is in Product Listing Page.

Hence Confirming the issue.

Thanks.