Hi,

This is a good question! You can't delete orders with WWStore. May be for some legal reasons, I don't know?!

First of all, you must understand how the tables are dependent. The table {prefix}WWStore_OrderDetails is linked to the table {prefix}WWStore_Orders by the OrderID column, and the table {prefix}WWStore_Orders is linked to the table {prefix}Users by the UserID column. That means that you must know the user ID to remove his orders. It will be necessary to remove the records of the {prefix}WWStore_OrderDetails table initially. Then, you will be able to remove the records of the {prefix}WWStore_Orders table. Tables can have a prefix name ({prefix}TableName), this is an optional setting when you install DNN. Search for objectQualifier inside you web.config file.

Because you can't undo delete commands, it will be a very good idea to backup you database BEFORE apply the following procedure!

Finding a user ID :

• If your user is a 'normal' one : Go to Admin menu and select User Accounts. Search the user, then click on the pencil to the left of his name. Now you have his profile on screen, the user ID is to the right of is name. Eg: Edit User - ploum (Id: 3). Note this number.
  
• If your user is a SuperUser : do the same from Host menu and select SuperUsers Accounts.

Delete records with DNN :

• Logon as host
• Go to Host > SQL
• Copy the following SQL command and paste it in the text box :
  • delete from {databaseOwner}{objectQualifier}WWStore_OrderDetails where OrderID in (select OrderID from {databaseOwner}{objectQualifier}WWStore_Orders where UserID=XXX)
  • Replace XXX by the right user ID!!!
  • Click on 'Execute'
• Copy the following SQL command and paste it in the text box :
  • delete from {databaseOwner}{objectQualifier}WWStore_Orders where UserID=XXX
  • Replace XXX by right user ID!!!
  • Click on 'Execute'

If you have SQL Server Enterprise Manager (or similar database tools), it's more easy and secure because you can delete rows 'visualy".

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.