Overview

We can update the plan type (Flat-fee, Fixed, etc.) for selected products if there's a need and you should create a support ticket for this modification.

Information

Mention the product codes for which you want the plan types updated and mention to which plan type you want the products updated.

<supportagent>

You will need access to the client database at 10.185.40.141.

Plan types for clients are kept in PlanType, with the type names stored in the Description column and the ID in PlanTypeID. Plans mentioned in the Product table refer to plans through the PlanType column.

To update the plan types of a set of plans referred to by their product codes, search for the mentioned products with the following query to make sure the product codes are valid. Check with the client in case any product code is missing.

select * from Product where ProductCode in (<comma separated list of product codes>)

Once it is verified that all the mentioned products are available, you can proceed to gather the appropriate PlanTypeID with the following query:

select * from PlanType

Once the required information is available, you can update the plan types of the products with

 update Product set PlanType=<PlanTypeID as required> where ProductCode in (<comma separated list of product codes>)

</supportagent>