Using ProductCart - Product Cart Database Clean-Up

Print Page | Close Window

Product Cart Database Clean-Up

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4458
Printed Date: 05-March-2025 at 2:36pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Product Cart Database Clean-Up

Posted By: njessen42
Subject: Product Cart Database Clean-Up
Date 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

http://www.rings-things.com - Rings and Things: Beads and Findings

Replies:

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: njessen42
Date 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?

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |