Reset ecommerce stats only (Piwik 1.12)

treffer · December 12, 2013, 7:52pm

Hi,

is it possible to reset the ecommerce stats only? I started today to track the ecommerce-things (not correctly). So it would be nice to start at zero again.

Thank you for information!

matthieu · December 13, 2013, 4:37am

Did you use goal before ? if not, then simply delete all rows from log_conversion and log_conversion_item and then delete all archive_* tables, then Piwik will reprocess the data

treffer · December 13, 2013, 9:48am

yes I used goals before. is it possible to keep them?

matthieu · December 13, 2013, 10:49am

Run sql query

DELETE where idgoal < 1

Cheers!

treffer · December 13, 2013, 2:48pm

Hi Matt, I’m too coward to delete archive tables. There is too much data inside. I think I will accept the fact, that there is some unusefull data inside. Thank you for helping.