ProductCart Shopping Cart Software Forums : Product Cart Database Clean-Up https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 12:10:49 +0000 Wed, 04 May 2011 17:17:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4458 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Product Cart Database Clean-Up : yep - it hist several tables including...]]> https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17416.html#17416 Author: Greg Dinger
Subject: 4458
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.
]]> Wed, 04 May 2011 17:17:51 +0000 https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17416.html#17416 <![CDATA[Product Cart Database Clean-Up : Interesting...does it remove the...]]> https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17415.html#17415 Author: njessen42
Subject: 4458
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?]]> Wed, 04 May 2011 16:54:53 +0000 https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17415.html#17415 <![CDATA[Product Cart Database Clean-Up : This is not a monthly activity...]]> https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17414.html#17414 Author: Greg Dinger
Subject: 4458
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.]]> Wed, 04 May 2011 16:46:43 +0000 https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17414.html#17414 <![CDATA[Product Cart Database Clean-Up : Hello, I was just curious what...]]> https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17413.html#17413 Author: njessen42
Subject: 4458
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]]> Wed, 04 May 2011 16:36:31 +0000 https://forum.productcart.com/product-cart-database-cleanup_topic4458_post17413.html#17413