Meta key _order_number duplicated in tables wc_orders_meta and postmeta

  • Resolved rokaklih

    (@rokaklih)


    8 months, 3 weeks ago

    Hello!

    The problem we are facing with is that for one submitted woocommecre order yesterday 7. 3. 2024 at 19.30, it created 2 meta keys for “_order_number” in both tables wc_orders_meta and postmeta.

    You can see it on on the image -> https://imgur.com/a/utpNQaH.

    Which caused an error of external API, and now we have over 200 orders with error.

    I have read in your plugin changelog that in version 1.5.8 you have fixed the mentioned problem: “[Fix] – Improved the file create and lock methods to avoid the duplication of sequential order numbers.”

    My question is, if there was something going on at that time yesterday or is this problem not related to your plugin?

    Looking forward for your answer!

    Best regards,

    Rok.

    • This topic was modified 8 months, 3 weeks ago by rokaklih.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support WebToffee Support

    (@webtoffeesupport)

    Hi rokaklih,

    Thanks for reaching out to us.

    It seems there is a confusion. To maintain compatibility with HPOS, we are saving the sequential order number to both the wc_postmeta and wc_order_meta tables using the _order_number meta key. We can confirm that it will not cause any issues. We appreciate your understanding.

    Thread Starter rokaklih

    (@rokaklih)

    Hi @webtoffeesupport,

    I understand that you’re saving _order_number meta key in both tables, because of compatibility with HPOS.

    But I don’t understand why we had two _order_number meta keys in wc_postmeta and two order_number meta keys in wc_order_meta for one order. Because of that our external API stopped working.

    My question is why did the duplication of _order_number meta key happend in both tables?

    Plugin Support WebToffee Support

    (@webtoffeesupport)

    Hi?rokaklih,

    We couldn’t replicate the issue when we tested the scenario on our end. Can you share your WooCommerce system status report (WooCommerce>status>system status report) with us to have a better understanding of your system environment? You may share the details directly via this link if you have any privacy concerns.

    Thread Starter rokaklih

    (@rokaklih)

    Hello,

    I’ve send you the woocommecre system report privately on the link.

    Looking forward for your answer.

    Best regards,

    Rok.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Meta key _order_number duplicated in tables wc_orders_meta and postmeta’ is closed to new replies.