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
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
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.
Clear one out from the database and see what happens
I couldn't find the table for it?
it is the category language table ;)
prefix_virtuemart_categories_language_suffix
Didn't work just left the box blank.
Any other ideas?
Quote from: SimonHodgkiss on September 22, 2014, 13:05:48 PM
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
but remember slugs should contain "-"
between distinct words
I still don't think this helps with the issue I am having.
Does anyone else have any other ideas
Quotebut 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
Thats interesting, when I blanked it from php my admin it gave me a 404 to that page and didn't recreated the slug.
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!