change all _ to - in url

  • Posts: 16
  • Thank you received: 1
5 years 3 months ago #309907

hi
how can i change all "_" to "-" symbol in all of canonical urls?
is there any way through mass actions?

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 3 months ago #309940

Hi,

Yes, with the action "update the values" on the column "product_canonical" with the type "operation" and the value: REPLACE(product.product_canonical, '_','-')

The following user(s) said Thank You: emperor69

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 1
5 years 3 months ago #309960

thanks, is there a way doing this action for "category" urls?

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 3 months ago #309977

Hi,

Sure. Just use the "category" data in your mass action, and select the "category_canonical" column in the "update the values" action and use instead the value:
REPLACE(category.category_canonical, '_','-')

The following user(s) said Thank You: emperor69

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum