URL path according to Magento Export CSV = marigold-gifts-luxury-lap-tray-sea-shells.html
Actual URL = marigold-gifts-luxury-lap-tray-squirrel-and-a-bird-bath-24050.html
Using myPhpAdmin we have truncated (i.e. cleared) the core_url_rewrite database, then re-indexed in Magento, cleared all caches and logged out / logged in - the URL data is entirely unchanged and the actual page url is still wrong.
Would appreciate any ideas as to what needs to be done to fix this.