Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 11-21-2002 01:36:20

dchau
Member
Registered: 08-19-2002
Posts: 10

pending orders

I want to modify CCP so that it deletes all orders with Status of "Pending Payment" after 2 days.  How can I do this?

I see under Global Setting where I can keep all orders and shopping cart settings.

Offline

 

#2 11-21-2002 02:15:47

jjt123
Member
Registered: 11-22-2002
Posts: 116

Re: pending orders

I dont have an answer for you but I do have a question. My site processed our first on-lin Order last night. CCP shows the payment as pending, my VeriSign Admin site shows the payment as having been approved, as well as my mercant account. Whats up with "Pending Payment"? Should CCP indicate "Processed"? Instead of pending?
Thanks
JJT
San Antonio

Offline

 

#3 11-21-2002 23:41:54

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: pending orders

Verisign should show the order as completed, and would if Verisign returned the user to your site.  Check the thread here:

<A HREF="https://forum.kryptronic.com/viewtopic.php?id=1085">https://forum.kryptronic.com/viewtopic.php?id=1085</A>

For information on setting up Verisign correctly.

__________________________

Nick Hendler
Webmaster, Kryptronic, Inc.


Nick Hendler

Offline

 

#4 11-21-2002 23:47:30

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: pending orders

In the file: ./cgi-bin/library/common/cron.pl

After the code:

###

$sql_statement = "

DELETE FROM tracking
WHERE tracking_epoch<'$date_diff'

";

&database_call('tracking','DELETE',$sql_statement);

###

Add the following:

###

$date_diff = "2";
$date_diff = ($date_diff * 60 * 60 * 24);
$date_diff = ($epoch_seconds - $date_diff);

$sql_statement = "

DELETE FROM tracking
WHERE tracking_epoch<'$date_diff'
AND tracking_status='P'

";

&database_call('tracking','DELETE',$sql_statement);

###

That will delete pending payment orders that are at least two days old when cron runs (every five days).  If you want cron to run more often, change the line at the top of the file:

my $cron_days = "5";

To a lower number.  Changing it to '1' would have cron run every day.  Be careful, though, cron does consume resources - that's why it's set initially to only run every 5 days (6 times a month).

___________________________

Nick Hendler
Webmaster, Kryptronic, Inc.


Nick Hendler

Offline

 

Board footer