Overview

You want to update the rollover products for a list of product names.

The rollover product of a product is one onto which a customer of the current product will be rolled over once the current plan expires. The rollover product cannot be changed for a selection of users of a product before their current plan expires, and the only way to change what products users go onto is to change the rollover product.

 

Solution

Create a support ticket and share the following information:

• Target ProductIDs or ProductCodes or Product Names
• Rollover ProductIDs or ProductCodes or Product Names

We will update the rollover product for the given products and inform you.

<supportagent>

Pre-requisite

• Access to the Client database
• Access to the client-specific CSR site (for Testing)

 

The rolloverproductid in the product table specifies the product identifier on to which the customer of the existing product will be rolled onto.

1. The current rollover product of a product can be found out with

   select ProductID, RolloverProductID, * 
   from Product 
   where ProductID = <target_productid>

2. In case the client has shared ProductCodes, then locate the target ProductID and the rollover ProductID by running the below query, substituting the ProductCode as required.
   If the product name is given, consider it as the value for the parameter ProductCode.
   

   select ProductID 
   from Product 
   where ProductCode='<ProductCode of target or rollover product>'

3. To update the rollover product, run

   update Product 
   set RolloverProductID = <desired rollover productid> 
   where Productid = <target_productid>

</supportagent>

 

Testing

Check the Rollover Product on the CSR site using these steps:

• Log in to the CSR site
• Navigate to Administration -> Rate Package and Product management
• Click on the Product Management tab
• Enter the Product Code in the corresponding field and click on Search.
• In the resultant information, click on the Product Code hyperlink to display the product details. 
  The field Rollover Product under the section Rollover Product displays the updated rollover product code.