[4.x]: How to reset order numbers before going live?

[freder]

What happened?

what's the recommended procedure to reset orders before going into production? there's a bunch of test orders in the db right now and we want to have the numbering start at 1 again obviously.

there's #581 but that won't reset the order numbers, as far as I can tell.

Craft CMS version

4.4.17

Craft Commerce version

4.2.11

PHP version

No response

Operating system and version

No response

Database type and version

No response

Image driver and version

No response

Installed plugins and versions

[lukeholder]

You should be using the order reference setting (that link has an example) along with the seq function to generate a sequence number that you can reset easily.

You also have the reset data command to delete all orders, subscriptions, payment sources, customers etc.