WooCommerce Product Page Redirecting to Another Product Page

@lorro

Thank for your help. I’ve found the table and found wp_old_slug. Should I delete it now?

@mrs.johnson I’ve tried to create products from scratch and the problem persists

I don’t think creating products from scratch will help in this case.

– go to phpMyAdmin
– in the left pane, find the site database
– in the left pane, find the wp_postmeta table and click it
– in the right pane along the top there should be a range of options: Browse, Structure, SQL, Search, Insert and more, select Search
– in the Value field on the meta_key line, put _wp_old_slug, click “Go”
– you should have a list of all your _wp_old_slug entries. In the meta_value column look for the the entries which are being redirected on the front end of the website. Delete these rows in the table.

If you delete a wrong _wp_old_slug row, or all of them, its probably no big deal. It just means someone who bookmarked a product will get a 404 and have to search your site for the new page.

So far, I’ve updated several times my permalinks.

I’ve did what @krissliss told, I’ve deleted all my _wp_old_slug from my _postmeta table.

I’ve also created a new products.

All products redirect to 404 – Page Not Found

@headvisual
A possibility is that when you update permalinks inside WordPress admin, in fact your .htaccess file is not being changed because its permissions settings are too strict.

Using ftp or your hosts file manager software, find .htaccess in your WordPress root directory. Its a hidden file so in some systems you have to find a setting to enable hidden files to be shown. Ensure its permissions are set to 644.

Or try renaming it to put it out of action. Resetting permalinks in admin will make a fresh one.

Lorro,

Following your direction, here is what I’m getting: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0010 sec)

Now I definitely don’t know what to do!

@lorro

Using webroot I search for .htaccess file and all .htaccess files have their permissions set to 644. So I’ve renamed them to put it out of action. So my site stop working. So I’ve renamed them back again.

How do I reset permalinks? In the Wp Admin Panel I only have the option “Save changes”

Are you running a cache plugin? Don’t deactivate it, but its essential to delete any cached pages after making changes.

@headvisual
Yes, in Admin page > Settings > Permalinks: click “Save changes” (even though there may not be any changes). This will make a fresh .htaccess. Some users say two saves are needed for effect.

Ok I’ve found something now.

My permalinks were set to post name.

Now I’ve changed it to default. Saved it and it’s working. I can enter to my products page now! Finally!

But I hate having the permalinks set like this, because it’s ugly =/

Gallery page – mydomain.pt/?page_id=90&lang=en
Product page – mydomain.pt/?product=porta-de-celeiros-doiro-harvest-2013-red-wine&lang=en

Does anyone have any clue of what may be causing this problem? Is there a way to fix this or should I just keep these ugly links?

Do you have two products with the same name then?

Here is one of the products giving me fits: https://www.youreunique.net/product-category/barn-door-hardware/

It is the one for double door

No.

I’m using the plugin – Polylang and – Hyyan WooCommerce Polylang Integration
This way, In my products panel, I have the product Wooden Box set for English and the product Caixa de Madeira set to Portuguese. The name is differente and the ID is also different.
The only thing that it’s the same its the SKU. But it doesn’t let me change it to different values.

I went back to permalinks under settings and under common settings, noticed that what used to be called default is now called plain.

I changed mine to default under common settings and got 404 errors for everything. I’m losing sales because of this! ??

Ok mine is now fixed. Apparently I don’t know how to do a proper search for old slugs but found them by sorting the tables. Thank goodness! Thanks all and happy new year!

If your website is live and you are selling already, do the following steps during the off peak hours.

Take a backup of the database before implementing or deleting anything from it.

Take a backup of all your files. Just create a zip file or an archive file on the server.

Open PHPMyAdmin

To resolve the issue, run an SQL query to view all the _wp_old_slug redirects:

SELECT * FROMwp_postmetaWHEREmeta_key= '_wp_old_slug'

Run this query to delete them:

DELETE FROMwp_postmetaWHEREmeta_key= '_wp_old_slug' ANDmeta_value= 'the-old-post-slug'

Run the SQL query again to check if all the _wp_old_slug are deleted.

SELECT * FROMwp_postmetaWHEREmeta_key= '_wp_old_slug'

Once the _wp_old_slug keys are removed, the product posts should load perfectly again.