Support » Plugin: WP-Invoice - Web Invoice and Billing » wp-invoice database structure

  • Resolved mainplus

    (@mainplus)


    Does any one know or can someone from usability dynamics point me in the direction of which tables invoice data is held in?

    I would like to produce some SQL to produce a summary report of invoices, but I can’t figure out where all the invoice data is held. I can see that there is some in the wp-posts table but cannot see where the line item data etc. is held.

    The ultimate goal is to produce a report for each invoice that gives me the customer, the invoice number, invoice title, total net value, total tax value, total gross value, the date due and if the invoice has been paid.

    I understand that the Power Tools plugin provides an extract that can be imported into Excel, but I am a Linux user and do not generally have access to Excel and the Libre Office import facility does not deal well with the created XML data. Even in Excel the multi-line aspect of the exported data makes it difficult to generate a simple one line per invoice summary report.

    • This topic was modified 1 year, 4 months ago by mainplus.
    • This topic was modified 1 year, 4 months ago by mainplus.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp-invoice database structure’ is closed to new replies.