Total de publicaciones:
4
Karma:
38
Unido:
13/5/2016
Ubicación:
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
Desarrollador Certificado
Total de publicaciones:
1052
Karma:
8801
Unido:
12/6/2015
Ubicación:
Bangladesh
you need to make empty Order,OrderItem and OrderNote Tables.
Total de publicaciones:
4
Karma:
38
Unido:
13/5/2016
Ubicación:
Canada
I assume that there is also another table to clean (the items in the order), correct?
MVP
Desarrollador Certificado
Total de publicaciones:
1052
Karma:
8801
Unido:
12/6/2015
Ubicación:
Bangladesh
I think these three tables are enough.
Total de publicaciones:
5
Karma:
123
Unido:
16/6/2017
Ubicación:
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)
Total de publicaciones:
54
Karma:
338
Unido:
10/9/2014
Ubicación:
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)
Total de publicaciones:
311
Karma:
2556
Unido:
15/4/2010
Ubicación:
United States
Is this still a valid list for nopC 4.1? TIA...
Total de publicaciones:
125
Karma:
892
Unido:
29/3/2019
Ubicación:
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!
Total de publicaciones:
311
Karma:
2556
Unido:
15/4/2010
Ubicación:
United States
True enough, but won't help in my situation. The info would still be useful. Thx.