{"id":1211,"date":"2026-03-10T06:47:09","date_gmt":"2026-03-10T06:47:09","guid":{"rendered":"https:\/\/spelldot.com\/?p=839"},"modified":"2026-07-01T20:00:24","modified_gmt":"2026-07-01T17:00:24","slug":"invoice-numbers-in-the-orders-list-accounting-friendly-setup-export","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/en\/invoice-numbers-in-the-orders-list-accounting-friendly-setup-export\/","title":{"rendered":"Invoice Numbers in the Orders List: Accounting-Friendly Setup + Export"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Your invoicing plugin <a href=\"https:\/\/presta.site\/blog\/en\/create-custom-columns-from-order-meta-delivery-date-po-number-gift-message-no-code\/\">creates custom order meta<\/a> like invoice numbers for every order, but WooCommerce buries them. Without a <strong>woocommerce invoice number orders list<\/strong>, finding which order matches invoice INV-2024-00345 means you open orders one by one, scanning each detail page until you find it.<\/p>\n\n\n<!--more-->\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s 15-20 seconds per order. When your accountant sends a list of 30 invoices to reconcile, that&#8217;s 10 minutes of clicking.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">OrderFusion adds invoice numbers directly to your WooCommerce orders list. You can see them at a glance, search by invoice number, find orders missing invoices, and export the whole thing to CSV for your bookkeeper.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What you need first<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">WooCommerce doesn&#8217;t generate invoice numbers on its own. You need an invoicing plugin. OrderFusion works with the popular ones:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PDF Invoices &amp; Packing Slips for WooCommerce (WP Overnight)<\/li>\n<li>Invoices for WooCommerce (Bas Elbers)<\/li>\n<li>Booster for WooCommerce<\/li>\n<li>YITH WooCommerce PDF Invoice (premium, via yithemes.com)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If your plugin stores invoice numbers as order meta (and most do), OrderFusion picks them up automatically.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Add the invoice number column<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>WooCommerce<\/strong> &gt; <strong>Orders<\/strong><\/li>\n<li>Click <strong>Screen Options<\/strong> (top-right corner)<\/li>\n<li>In the <strong>Columns<\/strong> section, check <strong>Invoice Number<\/strong><\/li>\n<li>Close Screen Options<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Invoice numbers now appear in your orders list, right alongside order totals and status. No more opening individual orders.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What if the column is blank?<\/strong> Two likely reasons. Either the order doesn&#8217;t have an invoice yet (your plugin might only generate invoices for completed orders), or your invoicing plugin stores the data under a non-standard meta key. If it&#8217;s the second case, create a custom column with your plugin&#8217;s specific meta key. See the section below on non-standard meta keys.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Search by invoice number<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Your accountant emails: &#8220;Can you check invoice INV-2024-00345?&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before, that meant opening orders one by one. Now:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In <strong>Screen Options<\/strong>, enable the <strong>Invoice Number<\/strong> filter<\/li>\n<li>Type <code class=\"codecolorer text default\"><span class=\"text\">INV-2024-00345<\/span><\/code> in the filter field<\/li>\n<li>The orders list updates instantly to show matching orders<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Partial matches work too. Type <code class=\"codecolorer text default\"><span class=\"text\">INV-2024-003<\/span><\/code> to find all invoices in that range. Useful when you need to pull a batch of sequential invoices for a quarterly audit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Find orders missing invoices<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This one saves you at month-end. Some orders slip through without invoice generation. Maybe a payment gateway hiccup, maybe a status that doesn&#8217;t trigger your invoicing plugin. Either way, you need to catch them before closing the books.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Enable the <strong>Invoice Number<\/strong> filter<\/li>\n<li>Type a hyphen (<code class=\"codecolorer text default\"><span class=\"text\">-<\/span><\/code>) in the filter field<\/li>\n<li>Apply<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">That hyphen is a special symbol in OrderFusion. It means &#8220;show orders where this field is empty.&#8221; You get every order without an invoice number, so you can generate the missing invoices and keep your records clean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The opposite works too. Type an asterisk (<code class=\"codecolorer text default\"><span class=\"text\">*<\/span><\/code>) to see only orders that have invoice numbers.<\/p>\n\n\n\t<div class=\"pst-app-cta pst-app-cta--woocommerce\">\r\n\t\t<p class=\"pst-app-cta-label\">WooCommerce Plugin<\/p>\r\n\t\t<p class=\"pst-app-cta-title\">Want to filter orders, add custom columns, and export CSV from your WooCommerce admin? Try <a href=\"https:\/\/presta.site\/en\/wordpress-woocommerce\/42-orderfusion-filters-and-columns-manager-for-woocommerce.html\">OrderFusion<\/a> \u2014 free Lite on WordPress.org, Pro on WooCommerce.com.<\/p>\r\n\t\t<p class=\"pst-app-cta-link\">\r\n\t\t\t<a href=\"https:\/\/wordpress.org\/plugins\/sdc-orderfusion-lite\/\" target=\"_blank\" rel=\"noopener\">Install OrderFusion Lite (free)<\/a>\r\n\t\t\t&nbsp;\u00b7&nbsp;\r\n\t\t\t<a href=\"https:\/\/woocommerce.com\/products\/sdc-orderfusion\/\" target=\"_blank\" rel=\"noopener\">View OrderFusion Pro on WooCommerce.com<\/a>\r\n\t\t<\/p>\r\n\t<\/div>\r\n\t\n\n\n\n<h2 class=\"wp-block-heading\">Build an accounting view<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Filters and columns are useful on their own. But accounting uses the same setup every day: same columns, same filters, same layout. Save it once so you never rebuild it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s an accounting-friendly setup:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Columns:<\/strong><br \/>\n&#8211; Order # and customer name<br \/>\n&#8211; Date<br \/>\n&#8211; Total<br \/>\n&#8211; Payment method<br \/>\n&#8211; Invoice number<br \/>\n&#8211; Status<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Filters:<\/strong><br \/>\n&#8211; Date range (set to current month)<br \/>\n&#8211; Status: Completed<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To save this as a reusable view:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Set up the columns and filters above<\/li>\n<li>Click the <strong>+<\/strong> button in the custom views area<\/li>\n<li>Name it &#8220;Accounting &#8211; This Month&#8221;<\/li>\n<li>Click <strong>Save<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Next month, load the view, adjust the date range, and you&#8217;re ready. No rebuilding, no forgotten columns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pin it for faster access. Open the views dropdown, click the pin icon next to your accounting view, and it appears as a badge above the orders list with a live order count. &#8220;(47) Accounting &#8211; This Month&#8221; tells you at a glance how many completed orders are waiting for review.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export for your bookkeeper<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once your accounting view is set up, exporting takes three clicks:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Load your accounting view<\/li>\n<li>Open the <strong>Bulk actions<\/strong> dropdown and select <strong>Export All to CSV<\/strong><\/li>\n<li>Click <strong>Apply<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">The CSV file downloads with exactly the columns you see on screen, in the same order. Hand it to your accountant, import it into QuickBooks or Xero, or drop it in a shared folder.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Two format options in OrderFusion settings (<strong>WooCommerce<\/strong> &gt; <strong>Settings<\/strong> &gt; <strong>OrderFusion<\/strong>):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>WooCommerce Style<\/strong> groups related fields together. More compact.<\/li>\n<li><strong>Table Style<\/strong> puts each field in its own column. Better for sorting and pivot tables.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Table Style works best for accounting imports. Each value gets its own column, so automated tools can map fields without manual cleanup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">When your invoicing plugin uses a non-standard meta key<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Most invoicing plugins store invoice numbers under a meta key that OrderFusion recognizes automatically. But some use custom keys.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the built-in Invoice Number column shows blank even though your orders have invoices:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open any order that has an invoice<\/li>\n<li>Scroll to the <strong>Custom Fields<\/strong> section (enable it in Screen Options if you don&#8217;t see it). On WooCommerce versions older than 8.8, this section may not appear with HPOS &#8211; check your invoicing plugin&#8217;s documentation for the meta key name instead.<\/li>\n<li>Find the field your invoicing plugin uses. Note the exact meta key (something like <code class=\"codecolorer text default\"><span class=\"text\">_wcpdf_invoice_number<\/span><\/code> or <code class=\"codecolorer text default\"><span class=\"text\">_invoice_number<\/span><\/code>)<\/li>\n<li>Back in the orders list, click <strong>Screen Options<\/strong><\/li>\n<li>In the <strong>Columns<\/strong> section, click the <strong>+<\/strong> button<\/li>\n<li>Enter a name like &#8220;Invoice #&#8221; and paste the meta key<\/li>\n<li>Set column type to <strong>Text<\/strong><\/li>\n<li>Click <strong>Create Column<\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Your custom column now displays invoice numbers from your specific plugin. You can also create a matching custom filter with the same meta key, so you can search by invoice number just like the built-in filter.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Try it yourself<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"> and toggle the Invoice Number column on. Filter for empty values, build an accounting view, export a CSV. The whole setup takes under five minutes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For step-by-step configuration details, check the <a href=\"https:\/\/woocommerce.com\/document\/sdc-orderfusion\/\" rel=\"nofollow noopener\" target=\"_blank\">OrderFusion documentation<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your invoicing plugin creates custom order meta like invoice numbers for every order, but WooCommerce buries them. Without a woocommerce invoice number orders list, finding which order matches invoice INV-2024-00345 means you open orders one by one, scanning each detail page until you find it.<\/p>\n","protected":false},"author":1,"featured_media":1402,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[232],"tags":[199,201,197,195],"class_list":["post-1211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-orderfusion","tag-columns","tag-csv-export","tag-orders","tag-workflow"],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/comments?post=1211"}],"version-history":[{"count":4,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1211\/revisions"}],"predecessor-version":[{"id":1417,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1211\/revisions\/1417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media\/1402"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=1211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=1211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=1211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}