You may have noticed that the IDs for certain records begin at relatively low numbers. For example, Order IDs and Customers IDs begin with 1 or 100. You may wish to change the starting base number of certain values within your store to better keep track of customers, orders, or simply for marketing purposes.
You can increment the ID numbers for the following elements within your store:
- Order IDs
- Purchase Order IDs
- RMA IDs
- Customer IDs
Please note that any changes you make are permanent. IDs within your store can be incremented, but they cannot be decremented.
Also note that in order to increment IDs, you'll need to close your store while you make updates. While the store is closed, customers will not be able to access your site and will receive your store's maintenance message when they go to the store's domain.
Incrementing ID Numbers
To increment ID numbers, do the following:
- In your Admin Area, go to Settings > Maintenance.
- Click Close My Store.
- Click on the Auto-Increment Current OrderID Numbers link.
- From the Table menu, select the group of IDs you want to increment.
- From the Numbers to add, select the interval to add to the table's IDs (1, 10, 100, or 1000).*
- Click Add This Value.
- Return to the Maintenance page and click Open My Store.
*The value you chose will be added to the ID number of the next element created in the selected table.
For example, if your most recent Order ID is 50, the next order placed in your store will be assigned an ID of 51 by default. If you chose to increment the Order IDs table by 1000, the next order will instead have an ID of 1051, followed by 1052, 1053, 1054, etc.
Repeat the above process until you're satisfied with the ID number for the table you selected.
Please note that incrementing IDs using this method does not affect data already in the system – only new data created within the specified table.
There is no limit to the number of times IDs for any of the 4 tables can be incremented.