Paypal IPN Digital Downloads Fix EASY

[nicklars]

I am pretty sure this will work but am not sure please correct me if I am wrong.

 

I went in to the database and took a look at the orders_status table to find the id of the completed orders status.

 

 

Then I went into includes > functions > general.php and changed the select orders query just a little bit.

 

 

GOTO line 1268 (in the function tep_count_customer_orders)

 

Change:

$orders_check_query = tep_db_query("select count(*) as total from " . TABLE_ORDERS . " where customers_id = '" . (int)$id . "'");

To:

$orders_check_query = tep_db_query("select count(*) as total from " . TABLE_ORDERS . " where customers_id = '" . (int)$id . "' AND orders_status='3'");

 

 

This will prevent the orders from showing up on the customer's account unless they are set to the proper order status! Which usually means confirmed or delivered. It's really up to you.