Every time a user registers in our WooCommerce system, he is automatically assigned a progressive numeric ID: therefore the first user will have ID 1, the second ID 2 etc.
The user ID will later be used for many internal WooCommerce procedures, but will also be important for subsequent invoicing and accounting management procedures.
However, it may happen that you need to use different ID values than those proposed by default by WooCommerce.
For example, it may be that the values from 1 to 1739 are already used by our accounting program, and reusing them could lead to problems and errors in accounting.
Or it may happen that you use different installations of WooCommerce, and for each one you want to use certainly different IDs (therefore: one with values starting from 10,000, another with values starting from 20,000, the third starting from 30,000... .)
To change the user ID numbering base you must:
- access our WooCommerce database with phpMyAdmin
- access the _users table (note: the prefix of the _users table changes from installation to installation)
- select "insert"
- create a fictitious user, specifying the following values:
- ID: set the new desired numerical value - 1 (for example: by entering 29,999 users will be created with IDs starting from 30,000)
- user_login : any string, for example fakeuser
- user_pass: any string
- user_ncename: the same value used for user_login
- user_email: any email address (preferably non-existent)
- At this point, all users who will subsequently be created will have a progressive ID subsequent to that of the newly created fictitious user.
