wlabs Posted February 25, 2015 Share Posted February 25, 2015 We'd like to track how many times virtual products are downloaded, and from whom they're being downloaded (an IP address would suffice). I don't see a way to do this, but I may be missing it — is there a way to view statistics about the downloads? Thanks. Link to comment Share on other sites More sharing options...
tomerg3 Posted February 25, 2015 Share Posted February 25, 2015 As far as I know there is no stat for it, though all the data is saved in different tables. You should be able to make a MySQL query to get all of them. Link to comment Share on other sites More sharing options...
wlabs Posted February 25, 2015 Author Share Posted February 25, 2015 I'm comfortable making a SQL query, but at first glance I don't see where download stats are saved... the virtual product files all have records in [prefix]_product_download table, but there is no obvious (to me, anyway) place where actual download events would be recorded. Any ideas? Link to comment Share on other sites More sharing options...
lahukalal6789 Posted February 25, 2015 Share Posted February 25, 2015 Thank you, this is great and exactly what I needed! Link to comment Share on other sites More sharing options...
tomerg3 Posted February 25, 2015 Share Posted February 25, 2015 Download data is saved in the order_details table, it will have the product and the number of times it has been downloaded. The visitor (or guest) table should have the IP address, which can be traced to the customer. Link to comment Share on other sites More sharing options...
Recommended Posts