Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Purge saved credit cards


jptechnical

Recommended Posts

Posted

I have searched the forums with little result. I have a shopping cart with about 100 orders before the credit card started getting split and half sent via email.

 

I would like to purge those saved credit cards without having to do it by hand.

 

I don't really understand sql queries, I am sure I could learn, but I have so many other projects it would take less time to just purge them by hand.

 

I was hoping someone might be able to suggest a sql query I can run from phpMyAdmin. Or perhaps a php script to run from time to time to purge the records.

 

 

I appreciate any help you can offer.

Posted

What exactly do you want to do? Just blank out the credit card details for these orders (if so, what are the fields?), or delete orders (and associated child records) for orders where the credit card data was stored in full?

 

You can't expect anyone to be confident in writing a query to help you with such a wishy washy requirement definition.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...