Portal Home > Knowledgebase > Customer > How To Convert All Existing Customers to Commercial

How To Convert All Existing Customers to Commercial

1. You may go to the SQL Management Studio and select the desired database.

2. Back up the database

3. Execute the script below

UPDATE CustomerShipTo SET AddressType='Commercial'WHERE AddressType='Residential' or AddressType is null

4. Run the application and check the Customer updated Address Type.

 


NOTE: We have tested this feature. Make sure to understand the information correctly because it will affect all existing customers by changing the Address Type of the customer to "Commercial".


 

Applicable Products:

Connected Business 13 and higher


Also Read