I have imported in a large number products into a store that is not live (Magento CE:1.9) but now need to correct their URLS.
Ideally I want to correct the correct URLS via an CSV import (system > import> data flow profile)
If I truncate the 'core_url_rewrites' table and then check in the admin (catalog > url re writes) it appears that the re writes have gone.
If I then import in the new URLs they appear in the admin (Product > URL path) but then reindex the URLs, they do not update to the new ones - the original ones are retained.
It appears that the 'core_url_write' contains the custom re-writes not the system (or other) ones.
How can either remove the fully remove the product URLs, or even completely remove the product and their URLs so they can be re imported and use their corrected ones.