Product Cart Database Clean-Up

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

   Hello,

I was just curious what other customers who use Product Cart do to keep their SQL databases clean if using SQL. 

Do you run monthly queries to clean certain data? 

I know that PC has a Remove Customer Sessions and Remove Saved Carts tool but do you go any farther? 

Would like to pick some brains.

Thanks for any information.

Nathan Jessen

  Rings and Things: Beads and Findings

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Topic: Product Cart Database Clean-Up Posted: 04-May-2011 at 4:36pm
	Hello, I was just curious what other customers who use Product Cart do to keep their SQL databases clean if using SQL. Do you run monthly queries to clean certain data? I know that PC has a Remove Customer Sessions and Remove Saved Carts tool but do you go any farther? Would like to pick some brains. Thanks for any information. Nathan Jessen Rings and Things: Beads and Findings

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 04-May-2011 at 4:46pm
	This is not a monthly activity for any of our clients, but I did want to note that we have created a script that purges historical sales data from a specified date. So if you feel that sales history old than X date is of no further interest, and that you want to regain space, we have such a module.

njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 04-May-2011 at 4:54pm
	Interesting...does it remove the information from all tables that include that sales history? Any other tips you might have to keep Product Cart tables clean?

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 04-May-2011 at 5:17pm
	yep - it hist several tables including those related to payment methods, orders, productsordered, etc. There are a couple tables dealing with QBSynch that I have to clear occasionally, and the XML log data can accumulate, but the QB stuff is being addressed in a future release, and the XML logging can be turned off at the admin. No other thoughts beyond that at the moment.