Home Forums WordPress Web Invoice – Invoicing and billing for WordPress Unable to change payment status

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #3496
    dwu
    Member

    First of all, I must say that you have done a great job, Mr. Mohanjith.

    I was marked an invoice as “mark as paid” by accident, and I was not able to change the status back to “mark as sent” (unpaid). As it will be a great option for upcoming version to add a “mark as unpaid” option, how do I manually edit the database to change the status back to “mark as sent” (unpaid)? Thanks!

    #4735

    Thanks for the good words :).

    Paid status is a terminal status with no transition (in a normal use case). I will add an option to revert invoices marked as paid mistakenly as soon as it’s done (like GMail allows you do undelete deleted mails) and also confirm before marking invoice as paid.

    For the problem at hand, please delete paid_status meta from web_invoice_meta table for the given invoice id and delete paid log events from web_invoice_log table for the given invoice id. Find bellow the SQL commands you need to run, remember to change the invoice id and the table name to suit your installation.

    DELETE FROM web_invoice_meta WHERE invoice_id = <invoice id> AND meta_key = 'paid_status';
    DELETE FROM web_invoice_log WHERE invoice_id = <invoice id> AND action_type = 'paid';

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.