VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Suggestions for future release
 Order processed Time
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Alan F
VP-ASP New User

102 Posts

Posted - September 04 2006 :  03:56:58  Show Profile  Visit Alan F's Homepage  Reply with Quote
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

4266 Posts

Posted - September 04 2006 :  16:46:48  Show Profile  Visit support's Homepage  Reply with Quote
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
Go to Top of Page

Alan F
VP-ASP New User

102 Posts

Posted - September 05 2006 :  03:23:27  Show Profile  Visit Alan F's Homepage  Reply with Quote
Cheers Michael

Will this become a standard feature or will I have to edit future copies of VPASP

Regards

Alan
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000