What is the best way to mass replace an item on all the BOMs and Work Definitions in Cloud?

Summary:

What is the best way to replace an item on all the BOMs and Work Definitions in Cloud?

Use Case is as follow: Component/Material A is used in 100s of Finished goods. Supplier who supplies Component/Material A has stopped its production. Organization has finalized a new supplier and want to replace Component/Material A (which was discontinued) with B (new material/component) in all the BOMs and/or Work Definition. What is the most efficient way to achieve this? (edited)

Content (required):

Version (include the version you are using, if applicable):

22B

Code Snippet (add any code snippets that support your topic, if applicable):