Reset order number

jgalvinjr

Right now the order number increments for every order, which is perfect. However, it would be nice to be able to delete all orders, and reset the order number to 1. Is that possible?

Deleting the orders is simple, but the next new order still has the higher order number.

Thanks!

jgalvinjr

A bit more info. I have noticed that there are four database tables for orders: ti_orders, ti_order_menus, ti_menu_options, and ti_order_totals. When I delete all orders from the admin dashboard, it only empties the first table. If I use phpmyadmin to empty all four tables, will that restart new orders at 1? Or is that dangerous due to other dependencies?

Thanks!

ryanmitchell

You can delete the content of these tables if you are happy to lose the historical data.

you can then reset the auto increment index of the tables to have your ID reset. PHPMyAdmin provides a way to do that - do a google search.

jgalvinjr

This was very helpful. Thank you!