BoulderDash Posted January 10, 2004 Share Posted January 10, 2004 Hey there, We're going to go live some time soon and I'd like to clear the following, so that all of the Products we viewed and purchased while building the website aren't counted: - Products Viewed - Products Purchased Would someone please tell me what to clear in the database so that when the website goes live we do not have all of that test data included? Thank you in advance, BD Link to comment Share on other sites More sharing options...
prime Posted February 6, 2004 Share Posted February 6, 2004 Hi, This may be to late for you, but in case anyone else has the same question here is how I reset them. One way is to edit your database (via myphpadmin or similar) then drop and re-add the proper fields. To reset Best Viewed Products - Goto Table products_description then drop and re-add the Field: products_viewed with type = int(5), Null = yes, Default = 0 To reset Best Products Purchased - Goto Table products then drop and re-add the Field: products_ordered with type = int(11), Null = no, Default = 0 Hope this helps. Link to comment Share on other sites More sharing options...
Guest Posted June 30, 2006 Share Posted June 30, 2006 The easiest and quickest way to do this is to run these Queries in phpMyAdmin. update products_description set products_viewed = 0 update products set products_ordered = 0 :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.