VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: LuukDriessen on January 31, 2013, 11:51:12 AM

Title: [ SOLVED ] Reset all orders (numbers)
Post by: LuukDriessen on January 31, 2013, 11:51:12 AM
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?
Title: Re: Reset all orders (numbers)
Post by: LuukDriessen on February 01, 2013, 08:28:40 AM
http://forum.virtuemart.net/index.php?topic=107570.0 (http://forum.virtuemart.net/index.php?topic=107570.0)

;)