Anzahl der Beiträge:
4
Karma:
38
Beigetreten:
13.05.2016
Herkunft:
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
Zertifizierter Entwickler
Anzahl der Beiträge:
1052
Karma:
8801
Beigetreten:
12.06.2015
Herkunft:
Bangladesh
you need to make empty Order,OrderItem and OrderNote Tables.
Anzahl der Beiträge:
4
Karma:
38
Beigetreten:
13.05.2016
Herkunft:
Canada
I assume that there is also another table to clean (the items in the order), correct?
MVP
Zertifizierter Entwickler
Anzahl der Beiträge:
1052
Karma:
8801
Beigetreten:
12.06.2015
Herkunft:
Bangladesh
I think these three tables are enough.
Anzahl der Beiträge:
5
Karma:
123
Beigetreten:
16.06.2017
Herkunft:
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)
Anzahl der Beiträge:
54
Karma:
338
Beigetreten:
10.09.2014
Herkunft:
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)
Anzahl der Beiträge:
311
Karma:
2556
Beigetreten:
15.04.2010
Herkunft:
United States
Is this still a valid list for nopC 4.1? TIA...
Anzahl der Beiträge:
125
Karma:
892
Beigetreten:
29.03.2019
Herkunft:
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!
Anzahl der Beiträge:
311
Karma:
2556
Beigetreten:
15.04.2010
Herkunft:
United States
True enough, but won't help in my situation. The info would still be useful. Thx.