How do I delete/remove PayPal Instant Payment Notification History?

[pjbonarrigo]

I have Zen Cart 1.3.8a.
I have PayPal Express and Web Payment Pro Active
I tested them using PayPal Sandbox.
I am almost done sandbox testing and deleted my test orders.
The PayPal Instant Payment Notifications remain.
Is there a way to delete them or must I use a query?
Almost ready for live testing!

[DrByte]

Are you referring to IPN history details?

[pjbonarrigo]

In the customer menu I have:
Customers
Orders
Group Pricing
PayPal IPN <<<<---- This one

See attached
pjb

[DrByte]

Run this in phpMyAdmin or SQL Patch tool: TRUNCATE TABLE paypal;

[pjbonarrigo]

Thanks Dr. Byte.
I may leave a few entries from recent tests.
So if PayPal is the only table I can delete by id.
pjb

[DrByte]

IMO I wouldn't recommend deleting any of it, but if you're bent on doing it, you should probably also truncate the entries in paypal_payment_status_history and paypal_session in addition to the paypal table.

[pjbonarrigo]

I guess I'll leave it be.
I don't think it will cause any problems.
It's odd that when you delete an order, the associated payment history remains.
Clicking on that history results in an admin error message since there are no associated orders.

[DrByte]

I guess I'll leave it be.
I don't think it will cause any problems.
It's odd that when you delete an order, the associated payment history remains.
Clicking on that history results in an admin error message since there are no associated orders.

Right. The real issue is ... one should never delete an order

[osaeed]

Run this in phpMyAdmin or SQL Patch tool: TRUNCATE TABLE paypal;

THANK YOU Dr. Byte for this sql command. Now I got a fresh clean database.