WooCommerce utilizes the “wp_posts” table to store products, images, posts, orders, etc., and uses the table IDs (primary key) as the IDs for these entities, including orders. These IDs are unique, integer-based, and auto-incrementing, which means we cannot change or set fixed values for them without potentially causing issues.
To preserve order IDs in WooCommerce, we need to override this functionality. Specifically, we should use a different parameter for the order IDs instead of the “wp_posts” table IDs. The simplest way to achieve this is by using the Sequential Order Numbers plugin. You can install this plugin on your WooCommerce site either before or after the migration process, and the original order IDs will be displayed accordingly.
In addition to the aforementioned functionality, Sequential Order Numbers plugins also allow you to add prefixes to your order numbers, and set a starting number for new orders once your WooCommerce site is live. Therefore, they are highly recommended for your WooCommerce store.
During the migration process, you can choose any Sequential Order Numbers plugin that suits your needs. We will customize the migration tool to ensure it is fully compatible with the plugin you choose, at no additional cost.