Yet another lovely day pulling my hair out about a pretty simple task. I cloned a site to a new domain. I wanted to keep all Woocommerce data with the exceptions of orders and customers. Simple, right? No way! I had to run several queries directly in the database to achieve that. However, there is still the old analytics data showing. Yes, I cleared the analytics cache. Yes, I cleared all transients. I did it in the WP dashboard AND directly in the database. No luck, the analytics data are still there. Where, for crying out loud, is this bloody data stored? Sorry for being so rude. But the idea was to SAVE some time by cloning the site. The idea was not to WASTE time by cleaning up the mess.
Thank you!
