Orders not showing up after doing an upgrade

[len7560]

Hi all,

I have a client with a pretty busy store. Everything runs great, for the most part. They had 3 orders process but not show up in the admin and they received no order email. The customers did and were charged. 1 was paypal, one was linkpoint (the third, I don't know).

What's really strange is that the order # the customer's got were out of order and duplicate numbers. The store is currently at # 1333 and these customer's were assigned 785, 786, 788. (These orders did not show up as orders, the originals with these numbers did). One of the customer's had purchased before and I found him in the admin. It showed that he logged in but not a purchase on the date he did (5-11).

One other customer who I searched by name showed no results. He purchased and showed his confirmation email but doesn't even show up in the database as a customer. . .

There were 11 other orders on the 11th. . . Any idea what's going on?

Thanks,

Lennie

[crazycucumber]

My first impressions would be that there is a duplicate , possibly test database / site that somehow got referenced instead of the live one.

I only say that , as it happened to me once when i copied the wrong configure files into the site , oooops

I would have a look in the tables with phpmyadmin and see what those order numbers look like , if they appear at all !

[len7560]

Yeah, I thought of that. The cart was upgraded on 4/23/07. Thise order numbers are in both the test database and the active one. No sign of the orders or customer in either one.

[len7560]

Now this has happened again. . .

The customer places an order, completes checkout (this time linkpoint) but this time doesn't get a confirmation email, so he goes online and logs in to see the status of his order. Nothing there, so he calls.

He is a returning customer, I can see his previous orders but not this one. No linkpoint record, no zen-cart record of the order yet the charge went through.

These are so random but I need help.

Thanks,

Lennie

[DrByte]

What do you mean "no linkpoint record ... but the charge went through" ?

How do you know the "charge went through" if Linkpoint shows you no record ?


Additionally,
What version of Zen Cart?
What payment modules are active?
What contributions/addons/mods are installed?
What special customizations have you done?
What is your URL?

[len7560]

Ah hah. . . I can answer these:


What do you mean "no linkpoint record ... but the charge went through" ?

In ZenCart --> Admin --> Customers dropdown, there are fields for both Paypal transactions and linkpoint transactions. The missing transactions do not show up there but the money shows up in my clients account.

How do you know the "charge went through" if Linkpoint shows you no record ?

Explained above.


Additionally,
What version of Zen Cart?

1.3.7 (was upgraded at the end of april, just before this began.)

What payment modules are active?

Paypal, linkpoint and check/money order.

What contributions/addons/mods are installed?

Sales report mod is the only one I believe. (SALES REPORT Version 2.0 By Frank Koehl)

What special customizations have you done?

Templates only

What is your URL?

http://www.electricdreams.com/Shop/ (store)

Thank you so much!

[DrByte]

As an aside, you might want to peek at your shopping cart page ... some of the default text is showing ...

You may want to add some instructions for using the shopping cart here. (defined in includes/languages/english/shopping_cart.php)

[DrByte]

In ZenCart --> Admin --> Customers dropdown, there are fields for both Paypal transactions and linkpoint transactions. The missing transactions do not show up there but the money shows up in my clients account.

So ... you're saying that if the storeowner goes to his Linkpoint account, he *does* see the transaction, but in Zen Cart there is no history under the customers->creditcard review page?

If he looks in Linkpoint account, what does it say about the status of the transaction? What about AVS or CVV status ? Were there any warnings about these transactions?

[len7560]

So ... you're saying that if the storeowner goes to his Linkpoint account, he *does* see the transaction, but in Zen Cart there is no history under the customers->creditcard review page?

Yes exactly. I just looked in the linkpoint account. Both transactions are there (both now marked shipped). But they appear nowhere in the zen cart admin or the database . 1 of these transactions gennerated a confirmation email to the customer with an out of sequence order # (duplicate) and the other generated nothing.

If he looks in Linkpoint account, what does it say about the status of the transaction? What about AVS or CVV status ? Were there any warnings about these transactions?

There didn't appear to be any warnings about these transactions as they now have both been shipped. I am not familiar AVS or CVV status. . .

The third missing order was processed by paypal. The store generated an email to the customer, again with an out of sequence order # (duplicate) but no record in Zen Cart. . .

Very random.

[DrByte]

Do you have copies of the generated emails ?
How do they compare with "good" emails ?
Is *everything* correct ? Including Store URL ?
Do the greetings, and the text of the emails match *exactly* what should be expected?