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