PayPayl Want Me To Confirm Each Sale

[MikeXRyan]

New problem. OSC programmer explained the PayPal payment option this way: He said it was all set up, just put in my company PayPal email address and when customer pays for digtial download, PayPal confirms and digital download url is sent to customer via email.

 

That didn't happen on test run.

 

This is what is happening: customer buys, via PayPal option, product which is set up for digital download. Payment is sent off to PayPal. Customer receives email from PayPal ackowleging PayPal payment sent.

 

Customer waits.

 

I go into PayPal and check payment status. It is waiting for me to accept or deny. This should *not* happen. Payment should be accepted immediately automatically as I understand it. I accept payment and we wait. Customer does not receive email providing download link.

 

What are the proper steps, i.e., how should this feature work? Can anyone tell me where my snags are and how to correct them?

 

I went to PayPal to see if there was something there that had to be toggled but found nothing. I checked PayPal to see if OSC's PayPal feature is acceptable and it is. BTW, am I in right forum for this type of question? (I'm so confused!) :huh:

 

Mike

[MikeXRyan]

I went into the Admin Menu to look at payment procedures. Under the PayPal module these are my settings:

 

Enable PayPal Module - True

E-Mail Address (company Paypal email address.com)

Transaction Currency - Only USD

Payment Zone - none -

Set Order Status - Pending (Options: default, delivered, pending, processing)

Sort order of display - 0

 

Are they correct for the type of transactions we are trying to use? All I can think of here is the "Set Order Status" area which came to us as defaulted to Pending. Perhaps it should be something else?

 

Again, what is happening is: customer buys digital download item, pays using PayPal, completes order and awaits email with download url.

 

Customer doesn't receive download url. I check PayPal and find payment is waiting to be accepted or denied. I look in Profile to see if there is an option to make PayPal account accept payments instantly but see nothing. How is process supposed to work? I would assume once customer clicks on PayPal pay button and payment is received by PayPal then system generates email to customer with download url.

 

That's not happening. How to fix?

 

Any help would be greatly appreciated.

 

Mike :'(

[♥Vger]

Install 'Downloads Controller' from the Contributions section. The customer will see a message on Checkout Success saying that thei download will be released when payment is confirmed.

 

If you have received the money then go to your Admin panel, go to Customers --> Orders and update the order status to Delivered. The customer will get the email with the download link and can also download it from a link in their 'My Account' page.

 

Vger

[MikeXRyan]

Install 'Downloads Controller' from the Contributions section. The customer will see a message on Checkout Success saying that thei download will be released when payment is confirmed.

 

If you have received the money then go to your Admin panel, go to Customers --> Orders and update the order status to Delivered. The customer will get the email with the download link and can also download it from a link in their 'My Account' page.

 

Vger

 

Well shooty. I went into the Admin panel -> Customers ->Orders and his order was not there. I went back to the Customers panel and checked his Order from there then received this:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

 

select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '8' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

What is that and can I fix it or must I go back to my installer and have him fix it? Is that the reason for the lack of order information?

 

 

One other question: you say to install the 'Downloads Controller' from the Contributions section. I've never installed a module or contributions. Not sure how to do it so I may need some assistance. Are instructions on installation included in the above? If not, where do I turn and will the module do away with me having to go into each customer's order and force the system to send the download url manually? Is that what is meant by "Downloads Controller"?

 

Thanks,

 

Mike

[MikeXRyan]

This is just a follow-up to this reported problem and the rest of our frustration.

 

We went back to the programmer who installed a customized OSC for us for a very hefty fee and he reported "Basically there is nothing wrong. When a customer has finished the order process they have to log into their account. Then select the order history where they will see the download link."

 

So I had a customer go in (again, for the 4th time) and purchase the software test. We went through the whole process together - all the way to PayPal where he paid for it. We then checked his account and it said he had placed no orders. None. I logged in as adminsitrator and went to his account to check his order status and received the error noted above. I went to PayPal and his payment was there, waiting for to be accepted. So I'm wondering, do we have to accept the payment first before a download link is provided??? We went ahead and accepted the payment and had the customer re-log in to his account. Still it says he has no history whatsoever, no purchases at all - after four separate purchases. If he were a live customer he would have paid for four electronic downloads and received nothing - no email of thank you (other then PayPal acknowledging and accepting his payments to our site), no download links and he would have no history of purchases on his account. If he emailed me and asked me to check his orders I can't because all I get is the previous error reported here. We simply can't run a viable business this way.

 

What I understood OSC could do fo us was offer an electronic onlinse shopping cart system that would allow the selection of a digital item, allow for payment through PayPal and receive an email with a download link to receive the purchase. There is no way we can monitor and maintain each and every purchase nor do we wish to deal with irate customers who pay for a product and have no idea they are supposed to go back and log onto their account, go to their history and hopefully find a download url. BTW, there is no 'history' just a link that says "View the orders I have made."

 

Add to this an additional $3 shipping fee piled onto the purchase which belies logic. There is nothing in any of the shipping options set up to charge such a fee yet it appears to be a standard default requirement and we've been unable to change or alter it despite our pleas to the programmer to eliminate. His response is, he doesn't know why it does that (and apparently our customers are going to be charged the fee whether they like it or not).

 

So we're faced with the fourth time in little over two months with another "shopping cart" that does not provide us with the ability to meet the needs of delivering our digital products. I can't tell you how disappointed all of us at Warp City are much less our level of frustration. We've had vendors sell us expensive shopping carts that they claimed would do exactly what we want and need and each time the carts do not live up to promised expectations. The standard reponse has been to claim the problem was on our end, our hosting service, our unix system, our MySQL, etc. Ok, we move it to their hosting services and pay their high cost hosting fees but still they can't get the shopping cart to work 'as promised and advertised'. "Can you burn it to CD and ship it to the customer?" - yes, that's the response of one vendor said when we told him we wanted our money back, as promised, if his cart failed to deliver digitally. It is obvious people will tell you anything to get your money, to lock you into their hosting service with it's high monthly fees and make you dependent on their own high programming fees (we charge $175 an hour to fix "our" shopping cart...)

 

Duh...

 

After a meeting this morning we've decided to scrap OSC and move on.

 

Mike