News:

Support the VirtueMart project and become a member

Main Menu

[ SOLVED ] Reset all orders (numbers)

Started by LuukDriessen, January 31, 2013, 11:51:12 AM

Previous topic - Next topic

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?