How can we remove Item entry from CPQ Pricebook when the item is Obsolete in PIM

Summary:

In our current integration with PIM, when Lifecycle stage of an item is updated to Obsolete, CPQ receives Expiration Start Date in a part custom field. In CPQ, we have put a validation rule to stop users from submitting order for expired items. However, the item still remains active in CPQ Pricebook, and this allows the system to add this item in L-I-G. Business is asking for a process to expire these items from CPQ Pricebook as well when the item is Obsolete.

DataZen is the application for Item pricing in our architecture. There is no automation across all downstream or upstream systems for a delete functionality. We only have automation for all systems when there is a new addition or modification in a Item Price.