Date of product added

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hi,

I may have missed it but is there, or could there be, a field added so that it is possible to
see the date a product is added and/or the date a product is made active in the products detail page? 

(I some times add products well before I make it active so maybe made active would be better.)

This suggestion is made so that it is easily possible to determine how many of a given item is
sold over the period of time it was for sale.

Dave

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Dayv3 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 07-June-2009 Location: United States Status: Offline Points: 11	Post Options Post Reply Quote Dayv3 Report Post Thanks(0) Quote Reply Topic: Date of product added Posted: 06-March-2012 at 8:24pm
	Hi, I may have missed it but is there, or could there be, a field added so that it is possible to see the date a product is added and/or the date a product is made active in the products detail page? (I some times add products well before I make it active so maybe made active would be better.) This suggestion is made so that it is easily possible to determine how many of a given item is sold over the period of time it was for sale. Dave

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply Posted: 07-March-2012 at 12:38am
	Hi Dave, The date added and the date modified are stored in the database. These data are just not used anywhere in the Control Panel or the front end end of the site (save for "New Arrivals" page). To display them on a product detail page is just a matter of calling these fields in the database query on viewPrd.asp and writing them out on the viewPrdC.asp, viewPrdL.asp and/or viewPrdO.asp you may be using for your display. The field name in the products table for the date added is "pcprod_EnteredOn"; for date modified it's "pcProd_EditedDate". There is no field to tack when the product was "activated/made active" as that is not standard functionality. To handle this would require some customizations.

whizzinpc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20	Post Options Post Reply Quote whizzinpc Report Post Thanks(0) Quote Reply Posted: 16-March-2012 at 6:32pm
	Did you figure this out yet? If not, I added this to our product detail page a long time ago. I can give u instructions.

Dayv3 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 07-June-2009 Location: United States Status: Offline Points: 11	Post Options Post Reply Quote Dayv3 Report Post Thanks(0) Quote Reply Posted: 21-March-2012 at 12:15pm
	Sorry for the delay in getting back to you. But, please do send the directions. Dave

whizzinpc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20	Post Options Post Reply Quote whizzinpc Report Post Thanks(0) Quote Reply Posted: 21-March-2012 at 12:52pm
	What version of PC are you on? If you want... just send me modifyProduct.asp from you admin folder... and I will update it for you. Edited by whizzinpc - 21-March-2012 at 12:55pm