Title: wp-invoice database structure
Last modified: May 9, 2019

---

# wp-invoice database structure

 *  Resolved [mainplus](https://wordpress.org/support/users/mainplus/)
 * (@mainplus)
 * [7 years ago](https://wordpress.org/support/topic/wp-invoice-database-structure/)
 * 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 7 years ago by [mainplus](https://wordpress.org/support/users/mainplus/).
    -  This topic was modified 7 years ago by [mainplus](https://wordpress.org/support/users/mainplus/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Contributor [MariaKravchenko](https://wordpress.org/support/users/mariakravchenko/)
 * (@mariakravchenko)
 * [7 years ago](https://wordpress.org/support/topic/wp-invoice-database-structure/#post-11513869)
 * Hello.
 * Check `post_meta` table.
 * More direct technical support could be achieved in WP-Invoice/Settings/Support
   tab.
 * Regards.
 *  Thread Starter [mainplus](https://wordpress.org/support/users/mainplus/)
 * (@mainplus)
 * [7 years ago](https://wordpress.org/support/topic/wp-invoice-database-structure/#post-11547956)
 * Post_meta was what I needed. All sorted now. Many thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘wp-invoice database structure’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-invoice_c36510.svg)
 * [WP-Invoice - Web Invoice and Billing](https://wordpress.org/plugins/wp-invoice/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-invoice/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-invoice/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-invoice/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-invoice/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-invoice/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [reports](https://wordpress.org/support/topic-tag/reports/)

 * 2 replies
 * 2 participants
 * Last reply from: [mainplus](https://wordpress.org/support/users/mainplus/)
 * Last activity: [7 years ago](https://wordpress.org/support/topic/wp-invoice-database-structure/#post-11547956)
 * Status: resolved