HomeHome Product Discus... Product Discus...SmithCartSmithCartRemoving Payment HistoryRemoving Payment History
Previous
 
Next
New Post
8/10/2011 7:06 PM
 
jw
No Ranking


Joined: 2/28/2011
Posts: 29

Hi I am wanting to know how to be able to delete the payment history, I have been doing test orders etc and I want to be able to remove all this history from the "Manage Payment History" screen. I also cannot see anything past the "billing zip" column so I am not sure if there is actually a delete button at the end. Is there also a way to re-size the table to make it smaller ?

 

thanks very much

 

Joanne
 
New Post
8/11/2011 4:48 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Joanne,

Which version of the Cart and DNN are you running?

You shouldn't have to re-size anything unless the Skin you are using has a very small width.You can delete your payment history by navigating the the Admin Menu, then Payment History section where you will be able to select the transaction you would like to delete, then on the next screen you can choose "select" which will take you the Order Details screen or "Delete" the transaction. Or if you wish to delete multiple transactions you can use SQL server to delete the customer data from the Smith_Customer table.

Thanks,
 
New Post
8/11/2011 6:18 PM
 
jw
No Ranking


Joined: 2/28/2011
Posts: 29

Hi Kevin

I am using a licensed copy of 4.43. I presume I do have a narrow skin as I know some columns are missing on some screens.

 

When I select payment history I get all the transactions, however this is where the problem arises in that when I use the "select" button at the begining of any line the next screen it takes me too has no information in it in any of the colums.

 

thanks

 

Joanne
 
New Post
8/11/2011 7:06 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Joanne,

Due to the amount of data and fields in the backend of the Cart a lot of the pages that display grids of data require a certain amount of space to display the all the information correctly.

As an alternative approach, you can make a copy of your skin, modify the Width to 100% to change with the size of the table and save it to the Host skin folder so you can apply the skin to the Admin screen. Or you could install a different Admin/Edit Skin with a variable width set to 100% so it will change dimensions with the pages.

Thanks,
 
New Post
8/11/2011 8:36 PM
 
jw
No Ranking


Joined: 2/28/2011
Posts: 29

Hi Kevin

I have re-sized the skin etc and can see all the columns etc. However I still have the same issue that there are a number of records in the "manage payment history" screen however when ever you select one the next screen it takes you to titled "manage orders" the fields are all blank.

 

How exactly do I delete all the records through  SQL ? I don't want to stuff it up as I am ready to go live as soon as I can sort this issue and remove all the dummy records.

 

cheers

Joanne
 
New Post
8/12/2011 1:37 AM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
After a successful order the cart stores data in the following tables:

Smith_Customer
Smith_PayHist
Smith_StoreOrders
Smith_StoreOrderDetails

To delete records using sql load SQL Mgmt Studio query analyzer and issue delete statements.

For example to delete all records from payment history:

delete * from smith_payhist

OR

To delete a specific customer

delete from smith_payhist where customerid = 5

Do the same for the other order history tables for the specific records you want to delete.

Please make sure you have a full backup of your database before deleting any data in case you need to restore.
At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartRemoving Payment HistoryRemoving Payment History




Questions? Contact us for answers!

Contact Us!