Virtuemart is a fantastic store component to sell downloadable files. It allows you to take orders from registered or non-registered users and show backend information about each order. When an order is confirmed, the user will receive an email for which he can download s specific number of file(s) for a specific length of time.
If any thing went sour along the way; such as the user not receiving a download is in an email, you can always track further email in the database using
To find download id and order information from phpmyadmin,
1) Goto vm_order_user_info get name order_id and user_id.
2) Go to vm_product_download.
3) Match obvious user and order_id.
4) The desired entry shows downloadable file, how many downloads are remaining, etc
Alternatively, you can wait until we complete our administrator module which will show all users and download information.
The code to retrieve the download information of all downloads with <mysql or phpmyadmin:
SELECT * FROM jos_vm_product_download WHERE jos_vm_product_download.user_id=jos_vm_product_download.user_id;
SELECT * FROM `jos_vm_product_download` WHERE jos_vm_product_download.user_id=jos_vm_product_download.user_id;
The code to retrieve the download information of one specific user with <mysql or phpmyadmin:
SELECT * FROM jos_vm_product_download WHERE jos_vm_product_download.user_id=usersnumbergoeshere;