You can have the X-cart Site map Advanced generate a sitemap to your html catalog instead of php pages.
To do this, you just need to pick one of the extra tpl files given instead of the default fts_sitemap.tpl. Just rename your fts_sitemap.tpl to ft...
Due to a recent update in MySQL, the "LIMIT -1" syntax no longer works. You need to open your fts_sitemap.php and find this line:
$product_limit = -1;
And change it to this line:
$product_limit = 9999999;