I’m not really sure why you want to change the ID for orders, but to answer your question, all orders will be included in the {prefix}_posts table, which is the same table for your posts, pages and all other post types you have in your installation.
You can sort the data by clicking the post_type column. The orders should be under the shop_order I recommend not to change any ID’s though, as it might result to conflict of your data.
Hope this helps!
Thank you and I understand your concern. The main reason for doing this it to maintain the consistency in the OrderID from old system to the new.
Normally I do not like to touch this at all but in my job that is what they would like as I have been successful changing it for another system we have. I wish it could be done thru WooCommerce but it is not so I have go thru this route.
I also must mention the following. This is first time for us using this platform. If successful then we could use it on another site we have and if the OrderID is not changed then we would have duplicates across two WooCommerce sites that is the last thing we want.
We do not have any orders at all so I will look into what you said but without any orders do you think we could still have a conflict?
Thanks for taking the time to respond and Happy Holidays,
Victor
As far as I know, as mentioned by @wooassist; by default there is no special table assigned only for the orders within the Woocommerce, it use the same table as all the other posts, pages of WordPress…
So; that makes the Order-ID to be non-sequential, like a random increase.
But there are some extensions for just that purpose to make the Order-IDs sequential and add controls for the user to determine,
-Order Number Start From
-Using Hash Before Order numbers
-Using Order Number Prefix/Suffix
-Skip Free Orders
etc.
OK thanks I will look into that instead of making changes in the database itself.
Regards,
Victor
