SEO keyword database table

[zemadfrenchman]

Hi I've got URL re-writing working for IIS 7 by importing htaccess but only when I manually set a SEO keyword (ie link to my product page only converts to a SEO friendly link if I manually set the SEO Keyword field in the product admin screen for that product). Otherwise it just shows ?productid=XXXX like the default setting. It is not defaulting to use the product name.

I only turned on SEO URLs after importing my product list which may be the cause?

Otherwise a workaround for me would just be to update via SQL the SEO keyword field for each product to have the product name - but I cannot find the correct field for this value. Can someone point me in the right direction?

Thanks!

[abolabo]

hi.
look into "url_aliases" table.