Prestashop redirecting to old URL

Solving prestashop 1.6 Redirecting to old URL after migrating.

After migrating from test to Pro sites Prestashop kept redirecting to test URL even after changing database table PS_configuration PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL values.

Solution was to visit backoffice Preferences > SEO & URLs section WHere the shop URL can be defined.

Changed it to the new values and fixed the issue!