Issue with Woocommerce custom field xlspadlock_runs_xxxx_xxxx....

twolsey

New member
Hello
I have the following scenario and I am using the Woocommerce Activation Kit.
  1. User places an order via Woocommerce frontend for a downloadable XLSPadlock compiled workbook.
    • Note that the compiled file has "keymaxruns":2 in workbooks.json file set.
  2. User receives email with activation token, downloads the exe file and successfully opens the compiled exe.
    • Note that the download files are being stored in Dropbox.
  3. Web administrator then replaces the file in Dropbox and the user downloads this file again.
  4. When the user tries to activate the new downloaded version of the file, the user receives an error that the max runs has been reached and the workbook cannot be activated. Thus locking the user out.
  5. I noticed in the order details in Woocommerce, the file that was just downloaded and the file that the user just tried to open and activate, the xlspadlock_runs_xxxx_xxxx.... custom field has a value of "0". If the Admin changes the value to "1", the user can again activate and access the new downloaded file.
Perhaps I am missing something but how can I update files as downloadable products progress and advance and have these files still work and activate for existing users.
thanks
 
Solution
When you release a new update, maybe you should also remove all xlspadlock_runs_xxxx_xxxx fields so that your customers can upgrade. With a SQL query, that should be possible.
When you release a new update, maybe you should also remove all xlspadlock_runs_xxxx_xxxx fields so that your customers can upgrade. With a SQL query, that should be possible.
 
Solution
Back
Top