HPOS database structure

Howdy @dyin

I have read that the new WooCommerce database structure woud become the default by august. (WC 8.0)

Kindly note that by August 2023 High Performance Order Storage will be enabled by default on all new WooCommerce stores. Check out the post linked here for further details.

I activated HPOS (COT) in WooCommerce and I found that your plugin is still mentioned in the table of those not compatible.
Is this a temporary issue?

I can confirm that WooCommerce Google Analytics Integration is currently compatible with HPOS (COT). For reference, I am linking the screenshot below, from a test installation of mine:

Just to clarify, are you referring to the New product editor, instead, as showcased in the screenshot above, perhaps?

Kindly note that these are currently experimental features, and merchants are to enable them at their own risk.

I trust that points you in the right direction, but if you have more questions, let us know.

We’re happy to help.

@anastas10s I think you are right. I did not select the new product editor and it still put your plugin in the table with those not 100% compatible with all function. It is however logical that they are pointing at something else as it dit not say I had to deactivate it to make HPOS work.

I didn’t know it was only going to be default on new stores. Thanks for that info! I was a little worried I had to test everything now before things went wrong during our busy season (sept-dec).

Should I not use COT/HPOS if it becomes available? I am on a shared server and I did read tables could get large.

Hello @dyin,

Glad to hear Pepe’s suggestion helped! :?)

Should I not use COT/HPOS if it becomes available? I am on a shared server and I did read tables could get large.

Given the substantial performance boost HPOS offers, I recommend transitioning regardless. I guess it depends on whether you are willing to part with incompatible plugins or find alternatives that align with the new system.

For your peace of mind, you can enable HPOS on a cloned environment of your site and monitor everything closely. Most hosting providers offer a staging solution with the plan but you can also use plugins like WP-STAGING.

Cheers!