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