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

22 Sep 2009, 8:13 PM

#1

New Zenner

Join Date:: Jun 2009
Location:: Scottsdale. Arizona, USA
Posts:: 36
Plugin Contributions:: 0

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

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!

22 Sep 2009, 8:53 PM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

Are you referring to IPN history details?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

22 Sep 2009, 11:57 PM

#3

pjbonarrigo

New Zenner

Join Date:: Jun 2009
Location:: Scottsdale. Arizona, USA
Posts:: 36
Plugin Contributions:: 0

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

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

See attached
pjb

23 Sep 2009, 6:00 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

23 Sep 2009, 3:00 PM

#5

pjbonarrigo

New Zenner

Join Date:: Jun 2009
Location:: Scottsdale. Arizona, USA
Posts:: 36
Plugin Contributions:: 0

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

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

23 Sep 2009, 5:04 PM

#6

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

23 Sep 2009, 5:10 PM

#7

pjbonarrigo

New Zenner

Join Date:: Jun 2009
Location:: Scottsdale. Arizona, USA
Posts:: 36
Plugin Contributions:: 0

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

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.

23 Sep 2009, 5:20 PM

#8

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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

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.
Right. The real issue is ... one should never delete an order :blush:

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

29 Jun 2010, 7:12 PM

#9

osaeed

New Zenner

Join Date:: Jan 2010
Posts:: 51
Plugin Contributions:: 0

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

DrByte:

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.

Halal Items
http://www.halalitems.com