[ SOLVED ] Reset all orders (numbers)

[LuukDriessen]

Hello,

Last weeks I tested my site.
Now I want to reset all orders and ordernumbers.

Ofcourse I can delete them in the backend. But I think I need to delete the orders in the database.

So I opened virtuemart_orders and changed auto_increment from 100 to 1. but this isn't the correct way because it doesn't work.

Is there someone who can help me?

I didn't find the solution to this problem on this forum. Only for VM1 versions.

Thanks in advance!

Joomla: 2.5.8
Virtuemart: 2.0.18a


*EDIT*

I cleaned up 3 tables and reset the auto increment for virtuemart_orders.

orders_items
orders_histories
virtuemart_orders

What am I doing wrong?

[LuukDriessen]

http://forum.virtuemart.net/index.php?topic=107570.0