Restarting Order ID

Hello

I am currently on alpha version of my site and have generated close to 12 Order ID ( from 1 to 12 )

I will be going live and would like to clear them...so that they restart at Order ID 1

how can I do that

Please help

Also on activity log, I would like to clear it all at once...

Run the query below on your SQL Server.
Make sure you run it on the correct database and delete all records from the Nop_Order table.


DBCC CHECKIDENT('Nop_Order', RESEED, 1)

Where 1 is the next number to use for the seed.
If you want to set the next number to 201100001, for instance, change the 1 in the query according.

Thanks...will try that.

However can you also let me know how I can delete all the activity logs from the backend

On the page /administration/logs.aspx there is a button that will clear the log table.
It is in the right upper corner, just above the list of log entries.

linkXperts wrote:

THANKS !

i everyone, how i have to do for change id of exisisting order?

thanks