How do I clear / empty the stats table in X-Cart?

[Abbott]

One of the more frequent occurrences in the X-Cart program is the logging of statistics. For tracking and trending how busy your website is, this can be crucial information, however for most people the stats tables are clogging up space and slowing down the mysql database.

If you don't needs the statistics and a log of everything in your X-Cart you may want to disable the feature of tracking. You can do this from the Administration Back End. Full instructions are included in the X-Cart Manual.

To clear the tables and bring your cart's speed back to it's former glory, follow these steps:

1) Go to /cpanel
2) Click the MySQL Database section.
3) Click the button to access the phpmyadmin
4) Click on the database you want.
5) It shows all the tables in the main part of the screen. Put a checkbox in each of the tables that have the word "stats". For Version 4.3.x these include the following tables;


stats_cart_funnel
stats_customers_products
stats_pages
stats_pages_paths
stats_pages_views
stats_shop

We also recommend to clear the xcart_referers table too!

6) Once there is a checkbox in each of the tables, on the bottom right use the dropdown menu and pick "Empty Table"

This will delete the contents of those tables and your cart's speed should return to normal again.