Cleanup Monthly AmazonQ SKUs

Problem

As part of this initiative to deprecate monthly SKUs, multiple monthly AmazonQ plan SKUs have been removed from the Zuora Product Catalog. However, these removed SKUs are still defined in our application.yml file, potentially causing confusion and issues when the code tries to reference non-existent plans.

Additionally, there may be existing orders in staging that reference these now-removed product rate plans, which need to be cleaned up to maintain data consistency.

Examples of affected configuration:

ultimate_duo_amazon_q_monthly:
  duo_amazon_q_charge_id: 'c4496641beb94b6945d4cc83c77600ff'

Proposal

  1. Remove all references to AmazonQ monthly SKUs from application.yml
  2. Create and run a rake task to identify and delete orders associated with the removed product rate plans. Cleaning up via console might be an option as well given this cleanup is scoped to staging environment only, as these values were not yet in production.

Relevant discussions

Edited by Vladlena Shumilo