Clear All - Sef Alias Data

[SimonHodgkiss]

Hello,

My client has updated a number of VM Category names but the 'Sef Alias' still uses the old data.

How can I delete this data and have VM recreate a new 'Sef Alias' ?

Thanks

[AH]

Edit the categories and create the new sef alias

Dont forget your 303 redirects for all categories and related products

And watch out for any coded links to products in these categories e.g. menu items

[SimonHodgkiss]

Theres over 5,000 can this be done automatically or does it have to be done manually?

303 redirects won't be a problem sites not gone live.

[AH]

Clear one out from the database and see what happens

[SimonHodgkiss]

I couldn't find the table for it?

[AH]

it is the category language table   

prefix_virtuemart_categories_language_suffix

[SimonHodgkiss]

Didn't work just left the box blank.

Any other ideas?

[jjk]

Any other ideas?

An easy to use tool for replacing lots of slugs would be the search and replace feature of HeidiSQL
http://www.heidisql.com/forum.php?t=11916

[AH]

but remember slugs should contain "-"

between distinct words

[SimonHodgkiss]

I still don't think this helps with the issue I am having.

Does anyone else have any other ideas

[GJC Web Design]

but the 'Sef Alias' still uses the old data.

where? in a menu or in the breadcrumbs or generally .. ? i.e everywhere?

the slug is definitely stored in prefix_virtuemart_categories_language_suffix so if you just blank them and resave the cat they have to go thru a process of reforming (to the new cat name) - just tried it - works

[SimonHodgkiss]

Thats interesting, when I blanked it from php my admin it gave me a 404 to that page and didn't recreated the slug.

[AH]

you have to go and maintain the category in admin in order for the slug to re-create

Deleting the slugs from the dbase  leaves them empty and thus a 404

Especially if you have created menu entries!