Reducing WooCommerce Order Numbers

  • Resolved dakotadevelopers

    (@dakotadevelopers)


    1 year, 4 months ago

     Reducing WooCommerce Order Numbers 

    Hi everyone! 👋 I’m looking for advice on how to simplify order management in WooCommerce. The situation:

    • The wp_posts ID is already at 98000, and I’d like to reduce the order numbers to 3 digits to make them easier to manage.
    • I enabled High-Performance Order Storage (HPOS) hoping it would help, but WooCommerce still creates records in wp_posts for each order.
      The new wp_wc_orders table uses the same ID as wp_posts, so order numbers remain high.

     How would you achieve this?

    • I’d like the order numbers to start from 1 or 100 in wp_wc_orders and remain independent of the wp_posts ID.
    • At the same time, I need to ensure compatibility with plugins for shipping and payments that reference the wp_posts ID.

    Has anyone managed to reduce their order numbers without affecting WooCommerce functionality? I’d love to hear your solutions!

    Thanks in advance! 👾

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mahfuzur Rahman

    (@mahfuzurwp)

    1 year, 4 months ago

    Hi @dakotadevelopers!

    WooCommerce assigns order numbers based on the post ID (even with HPOS enabled), so reducing order numbers to three digits while maintaining compatibility with shipping and payment plugins isn’t a built-in feature.

    Achieving this would require custom development, as WooCommerce doesn’t have a way to reset or change order numbering separately from the database ID structure. You may want to work with a developer to implement a custom order numbering system that doesn’t interfere with existing references.

    For further guidance, I’d recommend joining our WooCommerce Community Slack: https://woocommerce.com/community-slack/—where developers and store owners share solutions and best practices.

    Thank you.

    Thread Starter dakotadevelopers

    (@dakotadevelopers)

    1 year, 4 months ago

    Hi @mahfuzurwp .

    Thank you for helping. I understand that the best approach will be finding a solution that doesn’t heavily affect WooCommerce’s core functionality.

    The Sequential Order plugin was the closest fit, but it still caused compatibility issues with the shipping plugin the store is using. That plugin references the order ID to import shipping labels into its platform, which results in a double check process for administrators instead of simplifying it.

    I am already a member of the Slack group, but I haven’t received any responses yet.

    Thank you for the support!

    Moses M. (woo-hc)

    (@mosesmedh)

    1 year, 4 months ago

    Hi @dakotadevelopers,

    We’d love to help, but this forum is focused on addressing core WooCommerce issues and features. Your request involves more of a custom customization. Since you’ve already tried WooCommerce Sequential Order Numbers without success, you could also give WooCommerce Custom Order Numbers a try to see if it works better for you.

    However, the best approach would be to consult with an expert. You can hire one from Codeable.io or seek professional assistance from WooExperts.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Reducing WooCommerce Order Numbers’ is closed to new replies.