Overview

You want to update the Product Zone displayed under the Product Management section in the CSR Portal for a specific product code.

<supportagent>

Prerequisites

• Access to the Jump server.
• Access to the CIS database.

</supportagent>

Solution

The Product Zone of a specific product can be updated via the CIS database. To request a product zone to be updated, create a support ticket, making sure to include the Product Code/Name and the new Product Zone.

<supportagent> Once the information has been provided by the client, the Product Zone can be updated in the database following these steps:

1. Find the current ProductZoneId and the ProductID of the provided product. Replace the product code with the value provided by the client.

   Select ProductZoneID, ProductID, *
   from Product where productcode='<Product code provided>'

2. Find the ProductZoneId of the desired Product Zone. Replace the name for the value provided by the client.

   Select ProductZoneID 
   From ProductZone
   Where Description = '<Product zone provided>'    

3. Update the ProductZoneID.

   Update Product
   Set ProductZoneID = <value acquired in previous step>
   Where ProductID = <value acquired in first step>

</supportagent>

Testing

To verify the product zone has been correctly updated:

1. In the CSR portal, go to Administration Menu> General > Rate Package and Product Management.
2. Go to the Product Management tab.
3. Enter the product code and click on search.
4. Product Details will be displayed. Check the Product Zone under additional info.