I have just over 8k products listed on my wordpress site using WooCommerce.

Some product links work fine, vast majority for some reason have an unwanted space and - though ( -) resulting in 404, when i edit the link to remove these 2 characters the link becomes functional again.

The link appears like this inside wordpress editor-

www.mydomain/product/ -randomproduct

On the frontend, the link appears as this:

Www.mydomain/product/%20randomproduct

I'm wondering if theres a way for me to bulk edit all the bad links to remove the 2 problem characters and fix my links.

Thanks for any help received.

I have just over 8k products listed on my wordpress site using WooCommerce.

Some product links work fine, vast majority for some reason have an unwanted space and - though ( -) resulting in 404, when i edit the link to remove these 2 characters the link becomes functional again.

The link appears like this inside wordpress editor-

www.mydomain/product/ -randomproduct

On the frontend, the link appears as this:

Www.mydomain/product/%20randomproduct

I'm wondering if theres a way for me to bulk edit all the bad links to remove the 2 problem characters and fix my links.

Thanks for any help received.

• woocommerce-offtopic
• permalinks

• Welcome to the portal Ali22 ! :) – jgangso Commented Nov 19, 2020 at 8:15

1 Answer 1

You can check how the site_url is stored in the wp_options table - make sure there is not a space after the url.