“Orders” tab returns 404 page

Hello eljnoah,

Thank you for contacting WooCommerce support!

I understand you are encountering an issue with the Orders tab leading to a 404 error page within your wp-admin, even after a recent update to version 8.4.0. I understand how important it is to have swift and clear access to your orders for efficiently managing your online store.

Firstly, let’s confirm whether the URL you are trying to access for viewing all orders is indeed similar to this format:?https://www.yoursite.com/wp-admin/admin.php?page=wc-orders.

To offer the most accurate guidance, I would need to know more about your current setup. Could you please send me a copy of your site’s System Status? This information can provide valuable insights into potential conflicts or settings that may be contributing to the issue.

Here’s how you can retrieve your site’s System Status:

1. Go to WooCommerce > Status in your wp-admin dashboard.
2. Click on the ‘Get system report‘ button.
3. Then click on ‘Copy for support‘.

Once you have copied the report, please paste it into a new Gist at https://gist.github.com. After saving the Gist, you can share the link with me here in your reply.

This information will greatly assist in identifying the root cause of the problem you’re facing. I look forward to your response so that we can work together to resolve this issue.

Have a great day! ??

Hi @doublezed2,

Thanks for your prompt reply!
The URL for the “orders” tab, when I “copy link address”, is https://www.foxislandstudio.com/wp-admin/edit.php?post_type=shop_order, so it’s similar but not the same.

My site’s system status can be found here:

https://gist.github.com/eljnoah/1c92ca6beea82d7bcf673dec0f7381df

Hello eljnoah

Thank you for your reply.

I see that the URL is different from the format I shared.
This format is specifically for WordPress posts storage (legacy) settings.

To confirm this could you share a screenshot of WooCommerce → Settings → Advanced → Features page? Check this screenshot for reference: https://prnt.sc/r71kYHKJzHeE.

I want to see how the Order data storage option is configured.

Looking forward to your reply ??

Hi?@doublezed2,

I see, yes the setting is currently toggled to posts storage (legacy).

https://prnt.sc/EQzTtV7Bw2iD

Hello @eljnoah,

Since you are still using the post table, please navigate to WooCommerce → Status → Tools and delete all HPOS-related tables. You can then go through the migration process again.

Link to image: https://d.pr/i/m6Vvjr

Before you start, please make sure you have a good backup in place of your full site and database. Most hosting companies have this included in the subscription, but you could also consider using a service like Jetpack. If something goes wrong, it’s nice to know that you can restore your site.

Please let us know how it goes!

Hi @babylon1999,

Thanks for your suggestion — the orders page is working after deleting the tables and several following steps.

I deleted the custom orders tables as you suggested.

I then went back to the “Woocommerce > Settings > Advanced > Features” page and clicked the “synch pending orders” link, then toggled on “enable compatibility mode” and clicked “save changes.”

I then switched to “high performance order storage” and “saved changes”.

The orders page now works, and the URL ends in “wc-orders”, as was originally mentioned.

I still have “enable compatibility mode” selected. Should I keep it this way or disable? (see screenshot for current settings: https://prnt.sc/2mGFeGoboM9_)

Hello eljnoah

Thank you for your reply.

I’m glad to hear that the orders page is functioning correctly after taking the steps you’ve outlined. It looks like you’ve done a great job. ??

Regarding Enable compatibility mode, this feature is used to synchronize both the posts and orders table, ensuring that all your orders are properly aligned between the two systems. It’s a useful feature that acts as a bridge during transitions or updates.

After both tables are successfully synchronized, as seems to be your case, you will have the option to switch to High Performance Order Storage (HPOS).

While it’s generally safe to switch off the compatibility mode after synchronization, it’s advisable to maintain compatibility mode enabled for some time to ensure a seamless transition. This extra precaution helps to mitigate any unforeseen issues that could arise from different plugins or themes that may rely on the older data structure.

Keep an eye on how your system performs with compatibility mode enabled. Once you feel confident that everything is running smoothly without any issues for a reasonable amount of time, you can consider disabling compatibility mode. Before making any changes, I always recommend backing up your site, so you can restore it to a previous point if required.

If you have any more questions or need further assistance, please don’t hesitate to let us know. We’re here to help!