VP-Cart Shopping Cart

Welcome, Guest ( Customer Panel | Login )

All Forums

VPCart Forum

Suggestions for future release

Order processed Time

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Alan F
VP-CART New User

102 Posts

Posted - September 04 2006 : 03:56:58

Hi

I think a good addition and a useful feature would be for the orders to display the time they were processed

So the record would read This order has been processed 04 Sep 06 11:00

I am guessing this is an extra field in the orders table and a small sub routine ;-)

Regards

Alan
www.design365.co.uk

support
Administrator

4679 Posts

Posted - September 04 2006 : 16:46:48

Dear Alan,

This can be achieved rather easily by modifying just one line of code in VPASP.

Try the following:

1. Open up shopa_displayorders.asp in a text or html editor
2. Locate the sub routine Sub MarkProcessed around line 463
3. Locate the following line in this subroutine:

sql= "update orders set oprocessed = 1, ocardno = 0000 where orderid =" & item

4. Change this line to read:

sql= "update orders set oprocessed = 1, ocardno = 0000, ocomment=now() where orderid =" & item

This change will insert a timestamp into the orders table ocomment field to alert you as to when the order was processed. You could also add your own field to the table and modify the script accordingly if you don't want to use the ocomment field.

Thank you.

Michael
VPASP SUPPORT