Tổng Bài đăng:
4
Karma:
38
Đã tham gia:
13/05/2016
Vị trí:
Canada
I'm in the process of testing/setting up a new store, but I would like to remove any of my test orders from the system when I am ready to go live. How can I do this?
MVP
Các lập trình viên được chứng nhận
Tổng Bài đăng:
1052
Karma:
8801
Đã tham gia:
12/06/2015
Vị trí:
Bangladesh
you need to make empty Order,OrderItem and OrderNote Tables.
Tổng Bài đăng:
4
Karma:
38
Đã tham gia:
13/05/2016
Vị trí:
Canada
I assume that there is also another table to clean (the items in the order), correct?
MVP
Các lập trình viên được chứng nhận
Tổng Bài đăng:
1052
Karma:
8801
Đã tham gia:
12/06/2015
Vị trí:
Bangladesh
I think these three tables are enough.
Tổng Bài đăng:
5
Karma:
123
Đã tham gia:
16/06/2017
Vị trí:
India
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)
Tổng Bài đăng:
54
Karma:
338
Đã tham gia:
10/09/2014
Vị trí:
New Zealand
Needs one more table deleted TRUNCATE TABLE OrderNote DELETE FROM GiftCard DELETE FROM OrderItemDELETE FROM RewardPointsHistory DELETE FROM [Order] DBCC CHECKIDENT (OrderNote, RESEED, 0) DBCC CHECKIDENT (GiftCard, RESEED, 0)DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0) DBCC CHECKIDENT (OrderItem, RESEED, 0) DBCC CHECKIDENT ([Order], RESEED, 0)
Tổng Bài đăng:
311
Karma:
2556
Đã tham gia:
15/04/2010
Vị trí:
United States
Is this still a valid list for nopC 4.1? TIA...
Tổng Bài đăng:
125
Karma:
892
Đã tham gia:
29/03/2019
Vị trí:
United States
The better thing to do is create a full database backup BEFORE start your tests, so you are free to test everything as you want. When you finish it, just restore your database backup. Easy peasy!
Tổng Bài đăng:
311
Karma:
2556
Đã tham gia:
15/04/2010
Vị trí:
United States
True enough, but won't help in my situation. The info would still be useful. Thx.