Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can PAYPAL IPN trigger DOWNLOADS so they can only be downloaded after payment is confirmed as received?


apple1

Recommended Posts

I am so stumped. Does anyone know how to make paypal ipn trigger the availability of downloads?

My understanding is that there's a loop hole - users can download products before having paid for them simply by going into their account, even before payment has been confirmed through paypal. To prevent this, I understnd that there IS the download controller contribution as an option, but it only works manually- meaning I have to approve the downloads before they're released. But this tends to take the immediacy out of having an online convenience store. I'd like my system to be able to accept payment through paypal then allow the download. Is there a way for the IPN to be connected and trigger/ allow the download?

My brain is telling me someone else MUST have come up against this before. I'd really love it if someone could advise. It's quite urgent. Thanks so much for you help.

:blink: :-)

Link to comment
Share on other sites

I am so stumped. Does anyone know how to make paypal ipn trigger the availability of downloads?

My understanding is that there's a loop hole - users can download products before having paid for them simply by going into their account, even before payment has been confirmed through paypal. To prevent this, I understnd that there IS the download controller contribution as an option, but it only works manually- meaning I have to approve the downloads before they're released. But this tends to take the immediacy out of having an online convenience store. I'd like my system to be able to accept payment through paypal then allow the download. Is there a way for the IPN to be connected and trigger/ allow the download?

My brain is telling me someone else MUST have come up against this before. I'd really love it if someone could advise. It's quite urgent. Thanks so much for you help.

:blink: :-)

Download controller releases downloads when the order is updated to a certian status.

Paypal IPN will update to the status you tell it too once payment clears with paypal.

Therefore they work great together.

Follow the community build:

BS3 to osCommerce Responsive from the Get Go!

Check out the new construction:

Admin Gone to Total BS!

Link to comment
Share on other sites

Download controller releases downloads when the order is updated to a certian status.

Paypal IPN will update to the status you tell it too once payment clears with paypal.

Therefore they work great together.

 

Thanks Glcustoms for responding, but I'm still unclear. :( Sorry if I'm missing something really easy peasy.

Do you mind going into a little more detail? I'd like to clarify:

 

I hear what you're saying about the Paypal IPN system changing the status. But I question whether the status releases the download link itself. I don't seem to have mastered this second part.

 

So to be clear:

If I go through the process of visiting the paypal page, but NOT paying and then returning to my store, I don't get taken to the success page and their are no download links. This is working correctly- also the status of that order does show as 'pending'. Excellent!

 

Secondly, if I go to the paypal page and actually PAY, and then return to the store, I get taken to a success page which has my download links and the status back at my store does change to 'delivered', which indicates that the payment notification is working and feeding these messages back to my store. Again, this is correct. So IPN works in theory.

 

But what I notice is the following which is problematic:

 

But, if I DON'T pay and then go back to my store and circumnavigate a bit by signing into my account through the MY ACCOUNT TAB area, and I look at the order I just made but didn't pay for, it does show as 'pending' (correct) BUT the download links are ACTIVE. HMMMMM. So although the IPN is informatively correct, it doesn't serve to release or not release the downloads themelves in the my account area.

 

So basically anyone who is smart enough to know to wander through the 'side door' - actively sign into their account can access all downloads they've put in their cart but not paid for. Not the best solution.

 

I'd like to know how I can I get the actual download link (ie not the page with the links) to be available for download ONLY when the IPN changes the status to delivered so they don't show in MY ACCOUNT PAGE. Ie, what is the bridge between the ipn status changing and the download itself?

 

Have I highlighted a problem in your system you were unaware of (sorry ;-) ) or have you got yours to work in the way I'd like mine to? if so, what I'd really like is some guidance as to set the statuses. What statuses did you attribute to your system in the paypal module to make your download only show once payment has been received, or what the php script you added if you had to add one?

 

I really really really appreciate your help.

Kind regards,

Isabella

Link to comment
Share on other sites

please please please can someone help? I have gone through all the notes in the contributions and read through postings for two days. Installed, uninstalled, still doesn't work. If someone has made it work, I'll pay you to set mine up so it works.

Please help!

Thanks

Link to comment
Share on other sites

I misunderstood the first post. I thought you installed download controller. If you install download controller, everything will work just as I stated earlier and your downloads will be secure.

And to be on the same foot here, PayPalIPN will not update the status of an order unless payment clears.

What you took the time to explain in your last post is a very old/well known "flaw" with osCommerce. Downloadcontroller with correct it. The super download shop will as well.

Follow the community build:

BS3 to osCommerce Responsive from the Get Go!

Check out the new construction:

Admin Gone to Total BS!

Link to comment
Share on other sites

Note: if you have RC2/RC2a you do not need the downloads controller...It has a buildt in downloads vs individual order status solution which can be set under localization >> order status

Edited by toyicebear
Link to comment
Share on other sites

Hi there,

sooooo appreciate your help, can't tell you how much! But still no go.

Download links are constantly available in my account.

By the way guys, I did have Downloads Controller installed. I should have made that clear, sorry. All my postings have been at the point of not being able to set the status right within Downloads Controller. And that's part of the reason why I just don't get why it's not working because everyone else seems to have no problems. I'm presuming that's why there are so few posting on this problem. Am I the only dummy?

 

Also, to clarify, I am aware of the orders status area in admin- localisation-orders status and that changing these ticks and crosses in this area should affect the downloads.

 

I think is where the problem might be??? Let me describe what I see on my orders status admin page:

I have a list saying:

 

1 pending,

2 processing,

3 payment processing,

4 delivered,

11 downloads now available,

12 updated,

Preparing [Paypal IPN].

 

(Please note that I put these numbers in as per AlexStudios instructions at http://www.oscommerce.com/forums/index.php?sho...p;hl=AlexStudio

instructions points 11 and 12). together with matching them in myphpadmin as he suggests.

 

Then there's a column called 'Public status' all of these statuses are ticked green, is that right?

Then there is a column called 'Downloads Status'- all are crossed red except for the option 'downloads now available' which I've ticked.

 

Under the setting for the paypal module itself (modules- payment- credit/debit card via paypal) I have set the statuses to :

 

Set Preparing Order Status

Preparing [PayPal IPN]

 

Set PayPal Acknowledged Order Status

default

 

Set PayPal Completed Order Status

11 Downloads Now Available

 

Is all that right? To my thinking what I'm telling the system is "when an order is being processed by paypal, set the status to 'preparing [paypal ipn] and don't let the downloads be available (because there's no tick next to paypal ipn in orders status column) and then when the payment is processed, change the status to downloads now available and allow the download...."

 

So why oh why do I still get live download links in my account page when the status is preparing paypal ipn???

:blink:

 

I must missing something really obvious.

Can anyone else see where I've gone wrong.

Thanks again.

Link to comment
Share on other sites

Hi everybody,

At the risk of sounding stupid or patronising, I thought I'd clearly put down what had confused me for a few days to possibly help someone else with a similar problem.

The solution to my woes was in the Super downloads contribution. How great is it?!

If a newbie is looking for this answer, go to the contributions section, download the latest super downloads package and follow the instructions in the html file exactly. Make sure you DO NOT replace all the files, be sure to only merge in the differences, otherwise you'll lose a lot of vital info. :-) Double check to make sure that all these new bits you upload have the right permissions ( i say this because my files on my server only work with permissions 644, but they uploaded with an auto setting of 666, so I had to change these.)

Also, the thing that made sense to me finally in the instructions provided with this contribution was the concept that each download status is attributed a value in the orders_status table in your database managed my phpMyadmin. You have to go back to your admin section of osc, go to contributions- downloads- Downloads Controller Order Status Value and set this value (I set it as 10), and then this number is like the magic line in the sand. All statuses above this number are allowed to be downloaded and all statuses below this number are not.

The reason I could still access downloads whilst waiting for payments was that the status value that was attributed to paypal ipn automatically when I installed the paypal module was 13- a number above ten. When I changed this to below ten- bingo!

It's amazing how a simple thing can lead you down the garden path for weeks.

Good luck newbies!

I am now a very happy camper!

Thanks to all who helped me along the way. :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...