Using PDF Invoice, WC Sequential Numbering or other Plugins for Xero Invoice Numbers

Modified on Sat, 11 Mar 2023 at 06:10 PM

Using PDF Invoice, WC Sequential Numbering or other Plugins for Xero Invoice Numbers

There are half a dozen WooCommerce PDF plugins on the market.  We have enabled any of them to work with Xeroom and their invoice numbers to be picked up and used with Xeroom eg so that users’ customers and bookkeepers can tie-up and match the same invoice from Woo or Xero. 


The PDF plugin usually saves the Invoice No. in a post meta entry, that can be _invoice_number_display - this is from the other WooCommerce  PDF plugin. The request was to allow user to define which post meta key represents the PDF Invoice No., as you can see it on the image provided.  To deploy it find the meta_key from the plugin and put it in the Custom Meta Invoice No field.  


Do not try to mix and match the Xeroom Invoice Prefix and Start No with the WC PDF plugin it is either/or.  So for example if you want an invoice prefix set it in the WC PDF plugin and it will be picked up.


How to find the meta_key  


You can try using the keys given at the end of this doc which are the defaults for those plugins.  If it doesn’t work then you can check in the database.  To do this either search the table in SQL in your database if you have access or else install the WP Data Access plugin which enables you to browse and edit the database.  Go to the Postmeta table and explore for “invoice” once the PDF no plugin has been installed.  Alternatively place a test order, assign the invoice no and then browse to the bottom of the table where your order will show with the meta_key values for that order.

This table is the WordPress postmeta which contains the meta data for the main WP posts data.  The table can be browsed in your host's control panel or an excellent way is to use the WP Data Access plugin.







Expected meta_keys for different PDF Number Plugins

1. Woocommerce PDF Invoices by Andrew Benbow



2. Invoices for Woocommerce by Bas Elbers – Highly rated by customers

       _bewpi_invoice_number  only stores the number and no pre or suffice so use Invoice Prefix to add any prefix eg WO



3. WooCommerce Sequential Order Numbers Pro by SkyVerge now WebToffee


_order_number for version 1.4.9, it was previously _order_number_formatted


4. WooCommerce PDF Invoices & Packing Slips by Erwout Fernhout – now rebranded WPOvernight




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article