Database shows another number

  • Resolved ericthomson

    (@ericthomson)


    6 years, 10 months ago

    This plugin worked great to change the next OrderID that shows up in the UI when I imported an order. I just wanted to share an issue when I had to restore my site.
    1. I used plugin ‘Order XML File Export Import for WooCommerce(BASIC)’ to export my orders first.
    2. Then did a restore from my most recent backup. I saw that I was missing the most recent order (10614).
    3. Used Custom Order Numbers for WooCommerce to set the next OrderID to match the missing order (10614).
    4. Used ‘Order XML File Export Import for WooCommerce(BASIC)’ to import the missing order. I validated that the OrderID assigned matched what I set (10614).
    5. I used phpMyAdmin to look at the most recent woocommerce_order_items and I notice this record had an order_id of 10624. So I edited it so that it is correct (10614).
    6. Used ‘Order XML File Export Import for WooCommerce(BASIC)’ to export my orders again, and see that this order is exporting as 10624.

    I don’t get any errors but will keep an eye on this order in case there is any downstream impact. THANKS for a useful plugin.

Viewing 1 replies (of 1 total)
  • dhara61

    (@dhara61)

    6 years, 10 months ago

    Hi @ericthomson,

    Thank you for appreciating our plugin and sharing the above steps in detail.

    Regarding the plugin ‘Order XML File Export Import for WooCommerce(BASIC)’: We have not tested this plugin with our Custom Order Numbers plugin. I think you are facing this issue because this plugin is taking the order number from the database while importing and it is not considering the custom order number that our plugin assigns to the order to keep the IDs sequential. Because of which the order is assigned 10624 ID.

    If you set the order numbers to be in sequential order it is not necessary that the order IDs are sequential in the database too. Data from other post types like posts, pages, products, etc. are also saved in the same posts table so if suppose a new post or product is added the ID sequence will be broken in the database for orders.

    But in the WooCommerce Orders section, our plugin will keep the sequence intact as you have set them to be in sequential order. Hence, the order ID in the database and the one you see in the WooCommerce Orders section will be different.

    Feel free to contact us if you have any issues or queries from our plugin. Happy to help.

    Regards,
    Dhara Shah

Viewing 1 replies (of 1 total)

The topic ‘Database shows another number’ is closed to new replies.

Tags