Meta key _order_number duplicated in tables wc_orders_meta and postmeta

Hi Rok,

As far as I’m aware, that’s the expected behaviour when the site has the new High-Performance Order Storage (HPOS) function enabled. The older system for saving orders relied on the postmeta, while the HPOS method relies on its own standalone database table. For the time being, WooCommerce is set up to be backwards compatible in case some plugins are still using the postmeta approach.

Hi @riaanknoetze,

what do you mean that’s expected behaviour of HPOS enabled?

We do have HPOS enabled and the mentioned plugin for setting order numbers sequential. This problem had occur at only one order.

?? hey @rokaklih

Thank you for reaching back, clarifying things further.

what do you mean that’s expected behaviour of HPOS enabled?

I’d recommend taking a look at the related documentation, linked here, in case you didn’t have the chance to do so already, for further details on this.

I hope this is helpful! Please let us know if you have any further questions or concerns.
We will be happy to help you further.

Hi @anastas10s,

I’ve already readen the related documentation.

Maybe we don’t understand each other.

Let me clearify it again, we had two meta_key _order_number in table wc_orders_meta and two meta_key _order_number postmeta. Which caused our external API to stop working.

My question is why we had two meta_key _order_number in both tables? Is the meta_key _order_number created by woocommecre or plugin Sequential Order Numbers for WooCommerce?

Thanks in advance.

Hi @rokaklih,

Thanks for sharing further details explanation.

The _order_number meta key is typically created by the Sequential Order Numbers for WooCommerce plugin. This plugin is responsible for generating and assigning the sequential order numbers.

However, as you have enabled HPOS, WooCommerce is designed to be backwards compatible and creates order data in both the new wc_orders_meta table and the older postmeta table. This ensures compatibility with plugins that might still use the older postmeta table.

The duplication of the _order_number meta key in both tables should not typically interfere with the functioning of your site or external APIs. If it is causing an issue, it could be a conflict between the plugin and HPOS.

I would recommend reaching out to the plugin’s support for further assistance. They could provide more insight into how the plugin operates with HPOS and whether there might be a setting or update that could resolve the issue.

I wish I could help more, but hopefully, this gets you going in the right direction to get some further insight/information.

Hello!

Thank you for reply and an answer to my question.

I will get in touch with plugin’s support.

Best regards,

Rok!

Hey, @rokaklih!

I’m glad we were able to help and I hope the plugin’s support can assist you further on this issue.

I’ll close this thread now, okay?

Please let us know if there’s anything else we can do to help or if you have any questions.

Have a wonderful day!

Hi @carolm29,

yes you can close the thread.

Thanks!