Reset ecommerce stats only (Piwik 1.12)


#1

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 Aubry) #2

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


#3

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


(Matthieu Aubry) #4

Run sql query

DELETE where idgoal < 1

Cheers!


#5

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