What's the safest approach to change the next starting numbers for order, invoice, and shipment on a live site?
If I want to continue using Magento's default increment type and just want to change the next increment number, this is what I use.
Be sure to only use increment numbers that are larger then ones already used!
This SQL should take care of not accidentially setting an increment ID that was used already.
Not sure about the safety lever but I'm doing it by modifying values in DB directly:
Replace entity type code with "invoice" or "shipping" to do the same for the rest.
If you want to use custom number ranges or formats for increment IDs instead of the default Magento increments, you can also assign a custom increment model.
Then, update the increment model for the entities in a setup script:
Be sure not to return increment IDs that already where used previously!
The best [safest for magento] way to change the order number is to change the next order numbers and not the previous ones. This can be done with a simple database query. These are the ones I used in my site and it is working without any problem for almost a year now.
These queries will change the next increment ids for your magento store. NOTE: Replace X with the next id that you want.
Accept a answer if it works.