We've got almost 3000 products on a new version of our site so rather than enter each Rewrite URL individually I ran an update query in the databse to set the RewriteURL field in the bvc_product table as follows:


update bvc_product set rewriteurl=productname + '-' + sku + '.aspx'



After doing this the product pages are not found. I noticed that if you manual enter the rewriteurl then the value is prefixed with '/' on saving so I updated my values to include the forward slash prefix. Still product pages are not found. Comparing the format of values updated via a query and updated via the BVC admin console the formats are exactly the same. Now really wierd - if I open one of the problematic records in BVC admin and save then the product page is subsequently found under the url alias but the value for rewriteurl in the product table has not changed at all.



I really don't want to visit 3,000 records in the admin console to get around this - can anyone explain what is going wrong?



thanks



Simon