New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Introduce customer download logging and reporting #12517

Closed
mikejolley opened this Issue Dec 5, 2016 · 1 comment

Comments

Projects
None yet
1 participant
@mikejolley
Member

mikejolley commented Dec 5, 2016

Currently, downloads are only tracked by a numeric count on each download permission. This count is used to know when a user has hit the download limit. There is no tracking of when and who downloads products.

We can improve this by:

  • Adding a dedicated table for logging who downloads what (User, download, IP)
  • Use this data for reporting
  • Use this data for tracking how many downloads are remaining per permission.
  • Consider changing download IDs from file hashes to something more constant (real IDs) so tracking is consistent
  • Dedicated download IDs so download links (with hashes) don't break if a filename is changed. Right now we have to update records based on hash.

This was the original request:

Be good to have access to stats on how many times a download link has been used? We've got a store with digital products and occasionally for minor updates we just replace a file and direct people re-download it from their account page. We'd like to know how many people are doing that.

Related requests:

http://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/5196626-ip-logging-for-virtual-items-downloads
http://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/19160839-digital-product-download-log
http://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/5196695-lock-downloads-to-ip

@mikejolley mikejolley added this to the 3.0 milestone Feb 6, 2017

@mikejolley mikejolley modified the milestone: 4.0.0 Mar 17, 2017

@mikejolley mikejolley changed the title from Better download logging and reporting to Introduce customer download logging and reporting Jun 30, 2017

@mikejolley

This comment has been minimized.

Show comment
Hide comment
Member

mikejolley commented Jul 15, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Jul 31, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Jul 31, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 3, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 5, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 5, 2017

[woocommerce#12517] Replace download_id on customer download and prod…
…uct download with static UUID instead of filename based hash, to preserve download links, logs, and permissions across filename changes

procifer added a commit to procifer/woocommerce that referenced this issue Aug 11, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 11, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] Order download permissions: Use i18n number forma…
…tting on download count and proper escaping on report links

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] Move download log table to const and helper, outp…
…ut download log report titles in standalone function, reorganize download log data store read for code readability

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] When tracking downloads, increment/decrement down…
…load count and downloads remaining in SQL to avoid race conditions with updating in PHP

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] Deprecate process_product_file_download_paths fun…
…ction since download log ids should no longer change based on file paths

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] In deprecated function call for update_download_i…
…d, use __METHOD__ instead of hard coded function name

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

[woocommerce#12517] Remove calls to action woocommerce_process_produc…
…t_file_download_paths since download ids should no longer change. They are now static UUIDs.

procifer added a commit to procifer/woocommerce that referenced this issue Aug 23, 2017

@mikejolley mikejolley modified the milestone: 3.3.0 Sep 6, 2017

@mikejolley mikejolley self-assigned this Nov 13, 2017

@mikejolley mikejolley closed this Nov 15, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment