Clear test orders

Total Posts: 6
Karma: 30
Joined: 5/13/2010
Location: New Zealand

Posted: 13 years ago

Is there a way to clear orders entered during testing that does not reset other changes in the database (tax settings, localisation, users etc.)

Thanks
Paul

L.K

MVP

Bronze Solution Partner

Total Posts: 2898
Karma: 23165
Joined: 1/8/2010
Location: United States

Posted: 13 years ago

fairlieagile wrote:

Is there a way to clear orders entered during testing that does not reset other changes in the database (tax settings, localisation, users etc.)

Thanks
Paul

First delete all the orders from the admin section.

after that to make sure everything has been deleted > just open nopCommerce database, find table "Nop_Order"

if still order records are there, just delete those records manually from the table and you're good to go !!!!!

criisys

Total Posts: 5
Karma: 123
Joined: 6/16/2017
Location: India

Posted: 6 years ago

Use this.

TRUNCATE TABLE OrderNote
DELETE FROM GiftCard
DELETE FROM OrderItem
DELETE FROM [Order]

DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (GiftCard, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)

lucifer1

Total Posts: 8
Karma: 50
Joined: 8/28/2017
Location: India

Posted: 6 years ago

i am also encountring same problem. I want to clear all test orders from my database. I am a non coder and hence require something that could be donne from backend or if it could only be done through code than please write the whole procedure....Thankss in advance

ravi.kr

Total Posts: 1
Karma: 5
Joined: 9/21/2020
Location: India

Posted: 3 years ago

Thanks! Works well on nop 4.3

Still have questions or need help?