Order missing but Payment processed

09 Jun 2006, 22:57

#1

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Order missing but Payment processed

Hi

I can see someone has paid in Paymate but the order is not there in Zencart I suspect this is because the customer has closed my websites window after the Paymate popup show up so it could not return to my site with the correct session.

Now I would like to know how to create the order for the customer as I can see which product they purchased due to my own data tracking on the site.

I'm coder so I would just like to know the required sql statements for the order creation.

But I'm wondering for the Non coders what would they do in the situation? Cancel the Paymate transaction and ask the customer do it again?

Thanks alls

09 Jun 2006, 23:06

#2

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

Re: Order missing but Payment processed

install the master password contribution
login with the customers email address and your password then complete the order using the stock CC module for payment

this will create the order

09 Jun 2006, 23:12

#3

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

fantastic thanks for this

09 Jun 2006, 23:31

#4

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

Um I had a look around and searched the forums but where is this Master Password contrib?

09 Jun 2006, 23:34

#5

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

Re: Order missing but Payment processed

http://www.zen-cart.com/archived_contributions/admin-tools/master_password.zip

09 Jun 2006, 23:37

#6

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

Ok found a thread and installed it

But Stock CC module? what is that and where to do it?

09 Jun 2006, 23:45

#7

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

I see I have to login as the customer on the front end but if I order I have to select a payment method and pay for it?

I'm hoping the stock CC is not another payment module that I have to install and it shows up on the front end of the website?

09 Jun 2006, 23:46

#8

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

Re: Order missing but Payment processed

the stock credit card module in your admin

turn it on use 4111111111111111 123 08/08

complete the order

turn it back off

09 Jun 2006, 23:55

#9

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

I don't see that payment module

You mean this one?

The Zen Cart FREE CHARGE CARD freecharger

I only have these:

Authorize.net authorizenet
Authorize.net (AIM) authorizenet_aim
Credit Card cc 0 default
Cash on Delivery cod
The Zen Cart FREE CHARGE CARD freecharger
Check/Money Order moneyorder
Paymate paymate 0 Processing
Paypal IPN paypal 0 Processing
Module Directory: C:/projects/topmobilephones/includes/modules/payment/
The Zen Cart FREE CHARGE CARD

09 Jun 2006, 23:57

#10

restless

New Zenner

Join Date:: May 2006
Posts:: 45
Plugin Contributions:: 0

Re: Order missing but Payment processed

This is not a good solution though having to go through the front end and turn on something then turn if off, what if a customer sees that option and tries? That'll be 1 more thing I have to fix.

Sorry if I sound like I'm complaining it's a great cart, just a suggestion.

10 Jun 2006, 03:45

#11

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

Re: Order missing but Payment processed

1. Find a payment solution that dosnt require your customers to leave your site then return to it.
2. Put a tag in bold red letters that they must hit the return to cart link otherwise their order will not be completed. ( works about 1 1/3 of the time ) no one reads directions....

logging in to the front side is the simplest and easiest way to view the cart contents and you will need to complete the order process and get top checkout success to complete the order...

You only need to turn the stock cc module,. named CC not free charger...
on when you get to checkout_shipping
then once you get through confirmation and back to checkout_success ( about 30 Seconds ) you can turn it off again.... this will now complete the order....

14 Jun 2006, 15:46

#12

bjwitten

New Zenner

Join Date:: May 2006
Posts:: 3
Plugin Contributions:: 0

Re: Order missing but Payment processed

Hi, I had a similar situation, however I am NOT the coder. My site went live recently and had my first order! YEH! The order did not show up but the new customer was added. I'm using Paypal for payment and only realized that I had an order when I received an email from Paypal that I had $ added in my account. I can't get a hold of my web designer, any help is appreciated. Thanks

14 Jun 2006, 15:52

#13

merlinpa1969

Totally Zenned

Join Date:: Mar 2004
Posts:: 13,031
Plugin Contributions:: 1

Re: Order missing but Payment processed

your gonna have to call the customer on that one,

one you go into admin make sure that the email address thats in the
admin-> modules-> paypal -> business ID

is the exact same that is in www.paypal.com -> profiles -> email settings -> primary

make sure that its case sensitive...
red Red and RED are all different

16 Jun 2006, 06:35

#14

raskayu

New Zenner

Join Date:: Apr 2006
Posts:: 56
Plugin Contributions:: 0

Re: Order missing but Payment processed

Merlinpa1969:
your gonna have to call the customer on that one,

one you go into admin make sure that the email address thats in the
admin-> modules-> paypal -> business ID

is the exact same that is in www.paypal.com -> profiles -> email settings -> primary

make sure that its case sensitive...
red Red and RED are all different

Hi: I've had the same situation in some orders after to open my store, not much but several (6-7) in a total of 400 orders or so.

I've seen that ALL the cases with such a problem, have been of european customers: german, finnish, french, etc never for people using $USD as currency. So, I ask myself if the issue will have something to do with the change of currencie to euro when the buyer select that option to calculate better their purchase. Just an feeling, not something demonstrable :blink:

Also, I can see when a buyer is adding products to their basket until finish in real time, then when they goes to checkout, the list dissapear. Is there any way to get that list again, so no need to ask the buyer case that a fail in the order occurs and the Paypal IPN payment be received.?
In that way, using the master password option, it would be so easy to generate the order using CC, and no need to ask the buyer for the items they bought. avoiding nerve attacks. :lol:
Of course, I am talking of downloadable items, what is my case :D

Thanks a lot for so good support... The master password addon is TOO DAMN SIMPLE and very effective... Thanks for that too. :D

21 Jun 2006, 06:48

#15

raskayu

New Zenner

Join Date:: Apr 2006
Posts:: 56
Plugin Contributions:: 0

Re: Order missing but Payment processed

Merlinpa1969:
the stock credit card module in your admin

turn it on use 4111111111111111 123 08/08

complete the order

turn it back off

Hi Merlin, I've tried this a while ago with a new order problem and it doesn't work.:no:

I always get the message that the credit card begining by 4111 is not a valid credit card.

I've tried adding 123 at the end and using 123 as security code in the field below of the expire date..

The CC module never accept it.

Any ideas?:down:

21 Jun 2006, 11:40

#16

grayson

Totally Zenned

Join Date:: Oct 2005
Posts:: 516
Plugin Contributions:: 0

Re: Order missing but Payment processed

Merlinpa1969:
1. Find a payment solution that dosnt require your customers to leave your site then return to it.

Unfortunately this is not always possible. The Dutch iDeal payment system, for example, which is a popular payment method for online consumers in the Netherlands, was designed by the participating banks so that the customer must leave the store to visit the bank's internet banking page. Moreover, the banks opted *not* to provide automatic notification to the store upon payment completion, so there is no automated feedback to use to finish processing an order even if the customer doesn't return.

I sailed around this problem in the iDeal module for Zen Cart by prematurely storing the order to the database with an order status of 0 (zero), which is not a valid ZC order status, just before the customer leaves the store to visit the banking site. If the customer returns, there are two orders (the premature placeholder order, and the real order--for reasons unique to the iDeal payment system, there is no way to reuse the placeholder order via e.g. JeffD's External Order Number Generator if the customer returns after paying). If the customer does not return, you still have the placeholder order to fall back on if it turns out they did indeed pay (and thus meant to place the order). An admin Transaction Viewer automates cleanup of failed/expired transactions and the associated zero-status orders, as well as conversion of zero-status orders to real orders when applicable.

Something similar might work for other payment modules where people are experiencing problems.