[Issue] required_options not updating correctly

[m2-assistant]

This issue is automatically created based on existing pull request: #38715: required_options not updating correctly

---

Description (*)

When a product no longer has a required option this isn't reflected in the DB / frontend.

Related Pull Requests

N/A

Fixed Issues (if relevant)

N/A

Manual testing scenarios (*)

1. Create a product, with custom options.
2. Make one or more of the options required.
3. Save the product.
4. run select * from catalog_product_entity where entity_id = ENTITY_ID; , validate required_options == 1
5. Make all the custom options not required.
6. Save the product
7. run select * from catalog_product_entity where entity_id = ENTITY_ID; again.
   IF BROKEN: required_options will still be 1
   IF FIXED: required_options will be 0

Questions or comments

Haven't tested this via the API only via the MAP. Have validated that when the product doesn't have any required custom options required_options isn't passed in the payload. (So it's not the UI that's broken)

Contribution checklist (*)

• Pull request has a meaningful description of its purpose
• All commits are accompanied by meaningful commit messages
• All new or changed code is covered with unit/integration tests (if applicable)
• README.md files for modified modules are updated and included in the pull request if any README.md predefined sections require an update
• All automated tests passed successfully (all builds are green)

[m2-assistant]

Hi @engcom-Dash. 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!

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[engcom-Dash]

Hi @adamzero1

Thanks for reporting and collaboration.

Verified the issue on magento 2.4 dev instance and the issue is reproducable.

Steps to reproduce:

1. Create a product, with custom options.
2. Make one or more of the options required.
3. Save the product.
4. run select * from catalog_product_entity where entity_id = ENTITY_ID; , validate required_options == 1
5. Make all the custom options not required.
6. Save the product
7. run select * from catalog_product_entity where entity_id = ENTITY_ID; again.
8. IF BROKEN: required_options will still be 1
9. IF FIXED: required_options will be 0

The required_opetions not updating correctly.

Please refer the attached screenshots.

[github-jira-sync-bot]

✅ Jira issue https://jira.corp.adobe.com/browse/AC-11972 is successfully created for this GitHub issue.

[m2-assistant]

✅ Confirmed by @engcom-Dash. Thank you for verifying the issue.
Issue Available: @engcom-Dash, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.