Delete Credit Cards from Customer Orders

[Byron]

We use the simple validation for credit card payments. We manually process the orders and because of credit card and server requirements, we delete the customer orders as soon as processed.

Processing is easy with Weiland's Easy Batch Module, which we use for printing the invoice and the shipping form. However, we would like to retain batched orders for future reference in Miva as a backup.

To remove the credit card information, so we could retain the orders, means the laborious work of opening each order in Miva's order processing, using the password for each order to unencrypt, and open the payment window, where the card number can be deleted. Is there anyway to streamline this operation? Is there a separate file that could be deleted or it's contents erased, via FTP, that holds the encrypted credit card information? We are setup with MySQL. Any ideas?

[dotCOM_host]

Well, I don't have an answer for you, other than in mySQL you could clear the card number field with a simple SQL statement, but... before you do that... it begs a question. Why use a shopping cart for storing old orders online as 'backup'? It's not a storage system, and it's not an accounting system either. It's just a front-end for a shopping cart. Logically you'd want to store all past orders in a completely separate system built for that purpose. Order Manager comes to mind - it can not only give y ou the ability to process all orders off-line, but also store them on your local PCs at the office, rather than in MIVA Merchant.

[Byron]

Since our processing is done manually, there has been a couple of times when the orders were not processed correctly, and we needed to search for a missing order. Still having it on Miva would have been useful. The laborious work to keep a backup on Miva, does not make much sense for the occasional problem unless it was more simple.

[Vic - WolfPaw Computers]

That really isn't a good idea. Keeping the orders on the server just takes up space and creates an unnecessary risk. You should batch the orders then export them to a file, download the file, delete the file, delete the batch, and pack.

Then you can maintain the order history in excel or something locally.

[julie_thompson]

I delete all my orders once they have shipped for the reasons Vic mentioned.

And I, too, find at times I need to quickly search for a customer's order. I manually input my orders into QuickBooks (side note to developers: please, please create a simple QB import!). But I also save my merchant invoices that my store e-mails in my e-mail program. And a simple search for the customer's name in the subject line brings up their order in my e-mail program faster than I can load QuickBooks.

Maybe just saving your merchant invoices in your e-mail program will work? Just make sure to back up your e-mail files periodically.

[bearsnum34]

That really isn't a good idea. Keeping the orders on the server just takes up space and creates an unnecessary risk. You should batch the orders then export them to a file, download the file, delete the file, delete the batch, and pack.

Then you can maintain the order history in excel or something locally.

I have a problem batching orders, they don't batch in the correct order. What do I do about that? I heard it was a miva issue, not sure if they have corrected it yet. I have been out of the loop for a while.

Thanks so much,

[dotCOM_host]

What do you mean they don't batch "in the correct order"? When you create a new batch, all previously unbatched orders will be moved to this new batch. The order numbers may not be all consecutive, but that's normal - some people will abandon their baskets and never complete the checkout process. But whatever you see as unbatched orders should be in the same order once you batch them...

[bearsnum34]

What do you mean they don't batch "in the correct order"? When you create a new batch, all previously unbatched orders will be moved to this new batch. The order numbers may not be all consecutive, but that's normal - some people will abandon their baskets and never complete the checkout process. But whatever you see as unbatched orders should be in the same order once you batch them...

No, I do understand that. Here is what happens when I create a batch, lets say I have 20 orders to batch for that day. When I create the batch, 2 things happen:

1) I have to create more then one batch for the same day.
2) They are not in the same order as they were placed. They are all over the place. Not in consecutive order (excluding the abandon ones).

This is why I have not batch is so long. I was tired of having to change batches to look for an order.

[dotCOM_host]

Okay, that's weird, but perhaps explainable... Shot in the dark here, but when you say you have to create multiple batches in one day, I'm guessing you have several orders and you process them more than once a day - hence multiple batches. When you name batches, MM uses the current date as the beginning of the batch name, and then appends the text you type in to the batch name.

At first I thought perhaps it's because of the way you may be naming your batches. If your first batch was (for example) "06/23/2006: dog" and you then created second batch called "06/23/2006: cat", the second one (cat) could be listed first since "cat" would be before "dog" if you listed batches alphabetically. However, I've tested this myself in a v5 store and even deliverately batching orders and giving them reverse order names still listed them all in the same exact order they were created, not in an alphabetic order... Bummer, I suspected this was the problem, but... doesn't appear to be. Back to drawing board...

You may want to get your host involved or someone with admin access to your store and knowledge of MIVA Merchant, so they can have a look at this. Without physical access, it's a little difficult to troubleshoot these issues sometimes...

[bearsnum34]

Okay, that's weird, but perhaps explainable... Shot in the dark here, but when you say you have to create multiple batches in one day, I'm guessing you have several orders and you process them more than once a day - hence multiple batches. When you name batches, MM uses the current date as the beginning of the batch name, and then appends the text you type in to the batch name.

At first I thought perhaps it's because of the way you may be naming your batches. If your first batch was (for example) "06/23/2006: dog" and you then created second batch called "06/23/2006: cat", the second one (cat) could be listed first since "cat" would be before "dog" if you listed batches alphabetically. However, I've tested this myself in a v5 store and even deliverately batching orders and giving them reverse order names still listed them all in the same exact order they were created, not in an alphabetic order... Bummer, I suspected this was the problem, but... doesn't appear to be. Back to drawing board...

You may want to get your host involved or someone with admin access to your store and knowledge of MIVA Merchant, so they can have a look at this. Without physical access, it's a little difficult to troubleshoot these issues sometimes...

Oh Darn!!! No I would batch every Monday morning using the date. Then it would batch maybe 1/2 of the orders or 1/3 of the orders. Then I would have batch again, using the date and adding 2 or 3 behind it. The orders were never batch all together for the week, nor were the orders ever batched in consec. order.

I have tried everything, talked to my host and I am the admin. I haven't batched orders since Jan 01, 06.

Okay so now back to the org. question: How do I get simple validation to work if I can not get rid of authorize.net? What a headache this is!!

Thanks for your reply by the way!! ":)

[bearsnum34]

Okay got the batching to work! They must of fixed it in the last update!

Question about Simple Validation.....When I add the types of credit cards do I have to put in the Allowable Prefixes for all cards? Based on the Help menu Amex and master card have 2. Does that mean I have to put 2 Amex's and Mastercards in there? Not sure how to set that up?

[Vic - WolfPaw Computers]

No you can comma separate them.

[wmgilligan]

Hi Remik, et all,

There is a known batching bug in V5.
simply stated - batching does not batch all unbatched orders.

bill