Hi everyone,
I don't know if this has been addressed as this is now a 102 page thread, but I've run into a huge issue using this and possibly any other rewrite mod for the urls. I found that when rebuilding the site that has been well indexed for some time, the rewritten urls are based on the id number in the seourl table, so that the search engines hit http://domain/nicelookingurl-p-1111.html which resolves fine with the content for http://domain/NEWnicelookingurl-p-1111.html
As a result the search engines get the new content with the old name (seourl uses the same number 1111 on the new product). In time this may clean it's self up, but before you wack your seourl table think twice about how the renumbering of your products will effect your seo efforts.