Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › Digital download – how to know if file has been downloaded?
Tagged: digital downloads, Download, file, monitoring downloads, verification, Verify
- This topic has 18 replies, 7 voices, and was last updated 11 years, 2 months ago by admin.
-
AuthorPosts
-
September 24, 2010 at 12:50 pm #1913blogmeistressMember
Hi there
Is there a way of seeing whether a client has downloaded a digital file purchased via eStore? One of my client’s customers bought a product, but is now asking for a refund, claiming he hasn’t downloaded anything. Is it possible to know whether the file actually was downloaded?
I have in the meantime read your article on refund fraud – and will suggest to my client that he includes more specific information in his T&C’s regarding digital downloads and refund policies.
September 24, 2010 at 2:14 pm #24736wzpModeratorWarning — Running With Scissors…
You need a copy of the e-mail that contains the download link(s) sent to the customer.
For each download link, is a “file=” followed by what looks link random characters. This is called the download key.
If it hasn’t been removed from the database yet, use phpMyAdmin to look for a database table named wp_wp_eStore_download_links_tbl. There is a download_key column that corresponds to the “file=” string of the download link sent to the customer. There is also an access_count column that tells you how many times the link was clicked on.
September 24, 2010 at 5:52 pm #24737blogmeistressMemberThanks, will give it a try. Any chance of adding something to the plugin that would allow for this kind of functionality without having to poke around in phpMyAdmin?
September 24, 2010 at 8:12 pm #24738wzpModeratorThat would be up to Amin.
September 25, 2010 at 8:44 am #24739blogmeistressMemberHi again. Well, perhaps you could suggest it to him for the wishlist.
I found that table as you suggested, and located the download keys. But there’s a snag: the access count shows as “0”, but it does so for every single entry in the table – and it can’t be possible that all entries had no downloads (the site has been going for several months, and has made a number of successful sales). Any ideas why this might be?
Thanks!
September 25, 2010 at 3:20 pm #24740wzpModeratorI’ll look into it
September 25, 2010 at 6:23 pm #24741wzpModeratorI examined my own copy of the table. The access_count values show a value from 0 to 5, which is the download limit I have placed on links. I have been running eStore since the first week of September, which I believe was the 4.2.8 version.
Try creating a download link, but don’t click on it. The value should be 0. If you clock on it, the value should be 1. If it stays at 0, perhaps it was something Amin fixed, and you should at least upgrade to the latest version. This is important. the access_count field is what limits people from sharing your links.
September 26, 2010 at 1:49 am #24742amin007ParticipantThere is no known bug for the access count field. It should increment by 1 every time the file is accessed.
October 1, 2010 at 3:23 pm #24743blogmeistressMemberHi Amin
I tried what was suggested, generating a download link for one of the products. It then appeared in the table, as expected, with value of 0. Then I clicked on the link and downloaded the file, but the value is still showing as 0. All files in that table have an access count of 0 at this point.
Am currently on v 4.1.8 of eStore.
Any advice?
Thanks!
October 2, 2010 at 2:33 am #24744amin007ParticipantDid you do a plugin upgrade and forgot to do the “Deactivate” and “Reactivate”?
Please get a fresh version of the plugin from here and let me know if you still see this after you update the plugin:
October 15, 2010 at 9:14 am #24745blogmeistressMemberHi Amin
I have now updated to a fresh version of the plugin (v4.3., deactivated, reactivated, then tried a download. But it’s still showing no sign of any access count other than 0 in the database.
Help!
Thanks
October 15, 2010 at 10:31 am #24746wzpModeratorFor clarification, the file actually did download, correct?
October 15, 2010 at 5:45 pm #24747wzpModeratorI just figured it out, why your counts stay at zero…
You are not limiting the number of times customers can download a particular file…
Under eStore -> Settings -> General Settings -> Digital Product Delivery Settings -> Download Limit Count, you either have left it blank or set to 999.
If there is no limit, eStore doesn’t bother keeping count, LOL!
Mystery solved
June 24, 2011 at 6:59 am #24748gdwallenMemberLet me add my vote to the suggestion that the number of file downloads made by the customer (which is already captured and stored in the MySQL database) be made available, probably with the customer record displayed under Manage Customers (there’s certainly room for another column). Seeing a “1” in the customer record would provide some level of proff that the verification email was successfully sent and received, and the buyer clicked on the link. All this information would provide some peace of mind that the plug-in is working correctly, but also to easily provide some back-up that, yes, you did download the product.
September 13, 2011 at 2:50 am #24749adminKeymasterThe download link access count is stored in the following database table:
wp_eStore_download_links_tbl
This tutorial will show you how you can access that table and get any info you require:
-
AuthorPosts
- You must be logged in to reply to this topic.