Ubercart

I just went down the same path as you, and now have file downloads working. It took some cleverness with the Conditional Actions (details below.)

The following business logic works for my site (Drupal 6.14 and UC 6.x-2.2) which is using Paypal Web Pro to process paypal and credit cards. It allows file downloads without the duplicate payment emails that can arise from using Paypal. (Which is what all the Paypal goo is about in the first three CA's)

There is no easy way to export CA's (that I know of) so I invented a CA pseudo-code to record the logic in a compact format. Just seeing it all in one place was a big help. (If you have questions about the pseudo code, just ask. I think it's pretty self explanatory.)

Trigger: Customer completes checkout

E-mail admin checkout notification
IF 
	(Payment Method == Paypal AND order status == In Checkout)
	OR
	(Payment Method != Paypal)
THEN 	
	Send an e-mail to the administrator(s)


Decrement stock upon order submission (Order)
IF 
	(Payment Method == Paypal AND order status == In Checkout)
	OR
	(Payment Method != Paypal)
THEN 
	Decrement stock of products in order
	//[admin] Decremented stock upon order submission


E-mail customer checkout notification
IF 
	(Payment Method == Paypal AND order status == In Checkout)
	OR
	(Payment Method != Paypal)
THEN 
	Send an e-mail to the customer



Update order status upon checkout completion with full payment (Order)
IF 
	order balance <= $0 
THEN 
	order status = Completed
	//[admin] Updated order status upon checkout completion with full payment.



Trigger: A payment gets entered for an order

Update order status on full payment (Order)
IF 
	order balance <= $0
	AND	
	order status != Payment Received
THEN 
	order status = Payment Received
	// [admin] Updated order status on full payment.



Trigger: E-mail for granted files 

Notify customer when a file is granted (Order)
IF 
	order status == Completed
THEN
	Send an order email regarding files
	//[admin] Notified customer that a file was granted.




Trigger: Order status gets updated

Renew purchased files (Updated order)
IF 
	order status == Completed
THEN 	
	Update all file expirations for this order
	//[admin] Renewed purchased files


Move payment received to completed (Updated order)
IF 
	order status == Payment received
THEN 
	order status = Completed
	//[admin] Moved from payment received to completed.

Note: All the orders move to completed when the payment is received which is what you want for non-shippable orders. I had stressed for a while that shippable orders (or orders with both shippable and non-shippable components) should not go to Completed until after they shipped. Then I realized that UC makes it easy to look at your orders and see which had shipped (there's a little icon that shows up) so I just let it go and let Paid == Completed. If someone's got a fix for that, I'd be interested in your pseudocode.... ;>

Note: I was only able to get this working after a lot of research (yay forums!), a lot of trial and error, and one instance of someone looking and my CAs and saying: "fix that, right there."

Thank you. Did it work with sandbox also? Because I had no success with it. But this is probably the lack of IPN support there, as the payments inside sandox also do not change their status. They remain "under payment review" forever.

I tried live too, but unfortunately I only have one Paypal account, and Paypal won't let buying with the sellers account. I have to make another account.

Also, why do you decrement stock? At first, I even didn't have the stock module switched on, as I didn't see it necessary for downloadable stuff.

I made now another account and tried live payments, but they still remain 'pending'.

I tired both IPN off (as Ubercart should be able to make it automatic) and on (with IPN URL as http://mysite.com/paypal/ipn )

The only modifications I made to the CA-s given by weavegeek, is that instead of plain Paypal, I checked the option which includes the cards for the first option, and for the other of the OR condition, the negate (!=), I chose just plain Paypal. I also just let the email to be sent to the administrator and put the decrement into the same predicate. But that couldn't have changed it. Other predicates I entered just as written.
Could it be, that IPN is not working yet?

EDIT: One more question, did you create new predicates, or did you just edit the existing built-in ones?

Thanks a lot for this schema, managed to get it to work with normal credit card payments by leaving out the first few steps. What a relief!

I'm having a little trouble because the site I am working on has two types of payments, and the other one is to pay by purchase order, where people are invoiced rather than paying up front. The problem I am having is that now when I manually change the order status to Completed, it is no longer sending out the File Downloads email automatically. Is there an additional condition I can use to send the email with the File details when I change the status myself? Any help would be greatly appreciated.

I did have to modify the above a bit to avoid multiple emails. Mostly it was working around all the various ways Paypal could return state.

An "email notification send" flag that the CAs could check against would be very handy.

I'd love to see an "invoice email sent" as well as a "file notification email sent" flag. Would make my CAs a lot more robust and cleaner.

Just sayin...

So here is a weird issue, When I have a file download priced at .01 pennies, the order will be set at completed and my download will be ready. BUT when the cost is $10, or $1, the order stays in pending. What is the deal with that?

Somehow this process haunts me

I first checked the process with "bank transfer", setting the order-status manually to "payment received".
With the additional "conditional action" from Cathey (http://blip.tv/file/1757864) "Move payment received to completed" it worked. The status gets automatically set to "completed"
Only I got 2 notification-mails send-out.

I changed the "Move payment received to completed" action to set the new status for the "original order" (instead of "updated order") and now I get exactly one email.
NICE!

Now I tried the Paypal-Payment after some issues (e.g. i had secured my site with a .htaccess-password) I now got the order automatically go to the state "Complete". Very fine!

But in case of payment via paypal the notification email is not sent.
Do I have to make changes in the conditions of "Notify customer when a file is granted"??

Edit: What's interesting: although in the admin-comments the action "Notify customer when a file is granted" has left a comment, no email was sent.
Using Paypal-Express didn't even leave that "notify customer"-comment ...

This is really annoying.

First of all thanks for your suggestions. The article helped me to get it to work but...

If a user is logged in and orders a product, then the mail with the files to download is sent. So good so far.

But in my scenario it is possible that someone is not registered but then orders a product. In such a case the order will be associated with an account (provided that the entered email-address matches an account) or a new account will be created. But in this case only the email with the general order information is sent but the email with the downloads is missing. Even if the user logs in then there are no files listed. If I now repeat the order (as logged-in user) then it works again.

Has anyone a solution for my problem?
Sorry for my english, not my nativ language.

Thanks
Jones

I'm having a similar situation but something's off. Also using Paypal Website Payments Pro.

If a customer pays with Paypal, everything works OK

If a customer pays with credit card, though processed with Paypal, even though the status is set to Completed from Payment Received, the files downloads are not granted automatically.

Any suggestions?

Any luck getting the generated e-mail to send when an order's status is changed manually?

I'm also having another issue where we get some people paying by fax. Is there an easier way than generating an order for them, and having them log into their user section? Perhaps some way where I could automatically generate the download link for a file, or generate the email when I've manually created the order.

I also followed the instructions from Cathey's (http://blip.tv/file/1757864) screencast on a fresh Drupal 6.20-dev / Ubercart 6.x-2.x-dev installation. Everything worked flawlessly except the email notification. I run into the same problem like other people in this thread. The customer is getting two "File Downloads for Order# ..." and "Your Order at ..." emails.
I found the reason for this misbehaviour. If you use "PayPal Website Payments Standard" as payment method the trigger "Customer completes checkout" is fired twice. The first time it get fired if you hit the "Pay Now" button after you have logged into Paypal. The second time it get fired if you hit the "Return to Merchant" button. This must be a bug. Until now I have no time to test it with "PayPal Express Checkout" as payment method.
I use the following workaround to get rid of this misbehavior.
Edit all predicates for the trigger "Customer completes checkout" or at least "E-mail customer checkout notification" and "Update order status upon checkout completion with full payment" to avoid sending duplicate messages to the customer.
Add condition "Check the order status" NOT "Completed".

Now, a second handy hint.
If you use other payment methodes, too. Please edit the "move payment received to completed" predicate and add condition "Check the payment method" IS "PayPal"

I hope it helps somebody.

Bye
Rene

Wow this should not be an issue! After customizing my shop and getting everything else up and running I go to test the functionality of the file downloads by buying a file using PayPal Sandbox and the file isn't even listed under downloads and it's NOT sent in the Email either.

Why include a feature that doesn't even work correctly? What are the steps to get this to work? Please include it in the official instructions/read me file so we don't have to thumb through Google and endless forum threads to see that there is a problem. If this software has been released, there should be no troubleshooting involved for its' list of working features.

I enabled file download and have the proper permissions set. That should be all I have to do.

THANK YOU

Everything is fine until I try to return after the payment is made.
This is what I get as an error message. "EntityMetadataWrapperException: Unknown data property order_total. in EntityStructureWrapper->getPropertyInfo() (line 294 of /Users/arthursoles/Documents/drupal/drupal-7.0-travelguide/sites/all/modules/entity/includes/entity.wrapper.inc)."
Any help on this. Am using Drupal 7 to a Acguia Drupal Stack and PayPal Sandbox.
Art

I've explained some issues related to Ubercart, Anonymous Checkout & UC File purchases here:

http://drupal.org/node/1227076

--
Ubercart & Drupal Commerce Theme Development