Clear test orders

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 年 前
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
0
13 年 前
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 !!!!!
FREE nopCommerce Support? Visit www.StrivingProgrammers.com

Best place for FREE nopCommerce Themes & Plugins

www.StrivingProgrammers.com
A trusted community for developers & web-design enthusiast

http://www.StrivingProgrammers.com/blog
Browse hundreds of FREE how-to tutorials
0
6 年 前
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)
Need help in any of these areas-Elastic search| Customization| Plugins| Themes| Upgrade| Server Setup (Hosting) |Consultancy| API? CriiSys just a click way!

Skype: live:iamcriisys
E: [email protected]
M: +91-97261 62202
W: http://www.criisys.com/
3
6 年 前
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
0
3 年 前
Thanks! Works well on nop 4.3
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.