Pending Order Downloads

[josecarlos_pb]

Pending Order Downloads

-----------------------------

 

Contribpage: http://www.oscommerce.com/community/contri...search,download

Description : Will check order status and if it is Pending will not show a download link.

Written by Jeff Thornton

 

This forum is for everyone that use this excellent contribution

 

Thanks by this excellent idea!!!

[GoTTi]

so is this like the downloads contorller?

[GoTTi]

PERFECT.

[GoTTi]

THIS IS GREAT WITH THE PAYPAL IPN MOD. PLEASE READ MY INFO ON HOW TO BRING TOGETHER THESE TO FOR DIGITAL DOWNLOADS!!!

 

http://www.oscommerce.com/forums/index.php?showtopic=247742

[josecarlos_pb]

Sounds good GoTTi !!!

I use it with WPP

It works good with this contribution too :D

Farewell Ocspeople :blink:

[AlexStudio]

THIS IS GREAT WITH THE PAYPAL IPN MOD. PLEASE READ MY INFO ON HOW TO BRING TOGETHER THESE TO FOR DIGITAL DOWNLOADS!!!

 

http://www.oscommerce.com/forums/index.php?showtopic=247742

Nop, if the payers paid by eCheck, and not cleared until a certain days, the download link already expired.

[AlexStudio]

And a warning for those who want to use this with official PayPal IPN module:

 

The official PayPal IPN module put pre-mature orders in database with order status Preparing[PayPal IPN], so before the IPN received, no orders are Pending. There for the download link is working immediately after the pre-mature order been placed, payers don't even need to login to PayPal.

 

The Downloads Controller is much better than this one.

[GoTTi]

alex, your wrong. the download link is NOT available using this method, and following the instrucitons i provided with the mod.

 

when the status is set to Preparing[Paypal IPN], that status ID number and name just need to be added to the line that is controlling the digital download, like i explain in the instructions. once that line and status ID is entered, when the paypal IPN places the order in that specific order status mode, that download is NOT available untill updated to the newer status.

 

and in reference to the echeck option, the best thing to use in this situation is this mod, order editor, that i use: http://www.oscommerce.com/forums/index.php?showtopic=54032 so if i a link expires, you can just edit the customers order when you process the echeck payment, or actually ANY order they might put in with a money order or whatever they want, and you can just update the expired link date or just a new digital download to their order.

 

very easy now.

[AlexStudio]

alex, your wrong. the download link is NOT available using this method, and following the instrucitons i provided with the mod.

 

when the status is set to Preparing[Paypal IPN], that status ID number and name just need to be added to the line that is controlling the digital download, like i explain in the instructions. once that line and status ID is entered, when the paypal IPN places the order in that specific order status mode, that download is NOT available untill updated to the newer status.

 

and in reference to the echeck option, the best thing to use in this situation is this mod, order editor, that i use: http://www.oscommerce.com/forums/index.php?showtopic=54032 so if i a link expires, you can just edit the customers order when you process the echeck payment, or actually ANY order they might put in with a money order or whatever they want, and you can just update the expired link date or just a new digital download to their order.

 

very easy now.

You customized the condition checkings in the download module and put 'all' other status in that single line to be blocked. It was done in DC 5.3 by only checking for the orders_status_id which didn't reach certain value. Same thing, but much better in DC.

 

You still need to manually update those orders for eChecks cleared but downloads expired. DC handles these automatically. I have to say your mod works, but no better than DC 5.3. The one thing DC 5.3 lacks is a good user guide telling people how to set it up correctly. It's not my contrib, Linda wrote it a few years ago. It still is the best solution available.

[multibeatrecords]

For those curious new users who:

 

- are looking for a way to control access to pending downloads

- want to restrict access to Pending orders, to only allow access after Processing or Delivered status has been switched

- ... and who are confused by the COCKFIGHT between Super_Download_Shop_v1.0 and pending_downloads_v2.10

 

I humbly suggest:

 

Super_Download_Shop_v1.0 - click here

- this is the macho download file manager for people selling software, especially in bundles, who need flexible, configurable software packages for sale

- more complicated

- more power

 

pending_downloads_v2.10 - click here

- this is the quick, effective fix

- it works multi-language with the update from Matthias C. Hormann

- it requires copying and pasting a few highlighted lines of code into only (3) stock files.

- this is great for people selling audio files or non-software-packages.

[ryanbehrman]

In http://www.oscommerce.com/forums/index.php?sho...=download+later Cyber2000 gives a code snippet to change in download.php :

 

// Check that order_id, customer_id and filename match
$downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.order_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != ''");

 

This fixes the problem by only allowing the download if status is set to delivered. It works for me but I have not started implementing PayPal IPN yet. My question: Is the code above a suitable alternative to the suggestion in this thread, and which of the two is better to use? I am about to start implementing PayPal IPN.

[ryanbehrman]

For those curious new users who:

 

- are looking for a way to control access to pending downloads

- want to restrict access to Pending orders, to only allow access after Processing or Delivered status has been switched

- ... and who are confused by the COCKFIGHT between Super_Download_Shop_v1.0 and pending_downloads_v2.10

 

I humbly suggest:

 

Super_Download_Shop_v1.0 - click here

- this is the macho download file manager for people selling software, especially in bundles, who need flexible, configurable software packages for sale

- more complicated

- more power

 

pending_downloads_v2.10 - click here

- this is the quick, effective fix

- it works multi-language with the update from Matthias C. Hormann

- it requires copying and pasting a few highlighted lines of code into only (3) stock files.

- this is great for people selling audio files or non-software-packages.

 

Thanks multibeatrecords.

 

Does anyone know if these 2 contributions can co-exist (live side by side)? Or is it a case of one or the other?

[lupis]

So the pending orders contribution will fix the problem with customers who choose paypal to be able to download the product without sending payment.

 

What can I install that will fix the problem for bank transfer, cheque and money order customers being able to download the product without sending payment?

[ryanbehrman]

So the pending orders contribution will fix the problem with customers who choose paypal to be able to download the product without sending payment.

 

What can I install that will fix the problem for bank transfer, cheque and money order customers being able to download the product without sending payment?

 

lupis,

 

pending order downloads works in this situation too. The customer will NOT be able to download the product until YOU (or the website administrator) change the status to 'delivered'. When you receive the payment, you go into the admin console and change the status to 'delivered'.

[lupis]

lupis,

 

pending order downloads works in this situation too. The customer will NOT be able to download the product until YOU (or the website administrator) change the status to 'delivered'. When you receive the payment, you go into the admin console and change the status to 'delivered'.

Sounds like a beauty!

[lupis]

I just installed the modifications.

 

Is it correct that what the modification does is remove the link to the download on the confirmation page?

 

So the words "Download your product here" still show up?

 

Is there any way to remove this text and replace it with something like "Thanks for your payment. When your payment comes through your downloadable product will become available to download in your account." ??

[ryanbehrman]

I just installed the modifications.

 

Is it correct that what the modification does is remove the link to the download on the confirmation page?

 

So the words "Download your product here" still show up?

 

Is there any way to remove this text and replace it with something like "Thanks for your payment. When your payment comes through your downloadable product will become available to download in your account." ??

 

Yes, it is possible, but you will need to change the code. You will need to find the id related to that order status (pending/paypal ipn/etc..) and the in download.php if the order is in that status then show the text, otherwise show the download link. But don't forget that the "My Account" page uses the same download.php file. So check that the text you choose fits with that page too.

[multibeatrecords]

Thanks multibeatrecords.

 

Does anyone know if these 2 contributions can co-exist (live side by side)? Or is it a case of one or the other?

 

Since both muck about with the same code, so you'd definitely not want the headache of trying to merge them. To write your own custom solution, you could analyse both, re-code using the best of both.

 

Having successfully integrated "pending_downloads_v2.10" (LUPIS: text feedback to user with this update DOES change to what you're hoping it does), I realize that in order to create an album's worth of MP3s at high quality, the archive size is massive -- being able to give multiple file downloads for one purchased product is a GOOD THING.

 

Only in the simplest of cases is there no need for the features in "Super_Download_Shop_v1.0".

 

While SDS may create a lot of work for installation, product management, etc, it allows most stores offering downloads the flexibility they actually need, to carry it off properly.

 

pending_downloads_v2.10 on my store:

http://www.multibeatrecords.com/store/index.php?cPath=1_27

 

download the module archives, read the documentation.

 

hope this helps,

MBR

[lupis]

Yes, it is possible, but you will need to change the code. You will need to find the id related to that order status (pending/paypal ipn/etc..) and the in download.php if the order is in that status then show the text, otherwise show the download link. But don't forget that the "My Account" page uses the same download.php file. So check that the text you choose fits with that page too.

I appreciate that. Which file do I need to change? The text comes up on checkout_success. I looked in the english/checkout_success file but not there. I looked in download.php but cannot locate this text.

[lupis]

Cancel that - I found it in english/checkout_success.php.

 

I just deleted the text that was there and kept the bit that says "your downloads will be available in my account".

 

Thanks for the help.

[lupis]

Is there an easy way to make sure that no handling charge is attributed to downloadable products?

[ryanbehrman]

Is there an easy way to make sure that no handling charge is attributed to downloadable products?

 

Not sure what you mean. Where does the handling charge appear? I have downloadable products and they don't have a handling charge.

[dxer]

Not sure what you mean. Where does the handling charge appear? I have downloadable products and they don't have a handling charge.

 

I am re-opening this 2 years old thread because I have similar problem. I did apply all these fixes for this pending order download problem but nothing is changed over here. Whenever order is placed, customer gets link for downloading. Links is displayed on checkout success page and later when he login to his account.

 

What I did is applied following to download.php

  // Check that order_id, customer_id and filename match
$downloads_query = tep_db_query("select date_format(o.date_purchased, '%Y-%m-%d') as date_purchased_day, opd.download_maxdays, opd.download_count, opd.download_maxdays, opd.orders_products_filename from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd where o.customers_id = '" . $customer_id . "' and o.orders_id = '" . (int)$HTTP_GET_VARS['order'] . "' and o.order_status = '3' and o.orders_id = op.orders_id and op.orders_products_id = opd.orders_products_id and opd.orders_products_download_id = '" . (int)$HTTP_GET_VARS['id'] . "' and opd.orders_products_filename != ''");

 

and

// Die if not delivered
require (DIR_WS_CLASSES . 'order.php');
$order = new order ($HTTP_GET_VARS['order']);
if($order->info['orders_status_id'] < 2) die;

 

any further ideas ?