No best sellers after PayPal IPN

[Jamaz]

Hi,

 

Ever since I installed the PayPal IPN module (which is great) the website doesn't seem to be able to record best sellers. If the customer pays via another payment cheque or postal order then, the item is recorded in the best sellers. Why do you suppose this feature is disabled for PayPal IPN?

 

Hope you can help.

 

Thanks,

 

James

[Jamaz]

Anyone know the answer? Or even where to start looking? :thumbsup:

[Jamaz]

Hi,

 

Gents, really need help with this one. Stock is being bought from my shop, but isn't being recorded on my bestsellers since I installed PayPal IPN.

 

Whats gone wrong? :'(

 

Jamaz

[FalseDawn]

A quick scan through the ipn code reveals this in the before_process() function:

 

// Update products_ordered (for bestsellers list)

tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'");

 

 

So the only reason that your bestsellers would not be updated is if this code is missing/incorrect, or the before_process() function in the ipn_module is not being called (unlikely as it would not work)

 

Have you actually checked in the database to make sure it is not updating this table. Did you test with the sandbox first?