Title: Customize code snippet
Last modified: February 7, 2019

---

# Customize code snippet

 *  Resolved [grrog](https://wordpress.org/support/users/grrog/)
 * (@grrog)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/customize-code-snippet/)
 * Hi
    I found the following snippet on this forum and it works fine.
 *     ```
       add_action( 'wpo_wcpdf_after_settings_page', 'wcpdf_invoice_number_store_debug_tools', 9, 2 );
       function wcpdf_invoice_number_store_debug_tools( $tab, $section ){
       	global $wpdb;
       	if ($tab !== 'debug') {
       		return;
       	}
       	$store_name = "invoice_number";
       	$table_name = "{$wpdb->prefix}wcpdf_{$store_name}"; // i.e. wp_wcpdf_invoice_number
       	$results = $wpdb->get_results( "SELECT * FROM {$table_name}" );
       	echo "<table>";
       	echo "<tr><th>invoice number</th><th>order ID</th><th>order date</th></tr>";
       	foreach ($results as $result) {
       		printf("<tr><td>%s</td><td>%s</td><td>%s</td></tr>", $result->id, $result->order_id, $result->date);
       	}
       	echo '</table>';
       ```
   
 * I have two questions:
    – how to have separate tables for each month? – and how
   to have the invoice numbers as defined in the _Documents > Number format_ settings?
 * I tried many things to customize this code but none worked, my PHP skills are
   not very good 😉
    Can someone help me please? Thanks

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Ewout](https://wordpress.org/support/users/pomegranate/)
 * (@pomegranate)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/customize-code-snippet/#post-11179924)
 * Hi! This snippet is only meant for debugging and not suitable as a ‘list of invoice
   numbers’. The reason for this is that every time you have to change the ‘next
   invoice number’ setting, this list will be cleared. And as you noticed, this 
   list only takes the raw, unformatted invoice numbers.
 * If you want to read the invoice numbers for a specific date range, you have to
   query the orders themselves. Here’s an example that takes a from and to date (`
   2019-01-01...2019-01-31` in the example):
 *     ```
       add_action( 'wpo_wcpdf_after_settings_page', 'wcpdf_invoice_number_list', 9, 2 );
       function wcpdf_invoice_number_list( $tab, $section ){
       	$args = array(
       		'return'       => 'ids',
       		'type'         => 'shop_order',
       		'limit'        => -1,
       		'date_created' => '2019-01-01...2019-01-31',
       	);
       	$order_ids = wc_get_orders( $args );
   
       	echo "<table>";
       	echo "<tr><th>Invoice Number</th><th>Order Number</th><th>Order Date</th></tr>";
       	foreach ($order_ids as $order_id) {
       		$order = wc_get_order( $order_id );
       		printf("<tr><td>%s</td><td>%s</td><td>%s</td></tr>", $order->get_meta('_wcpdf_invoice_number'), $order->get_order_number(), $order->get_date_created()->date_i18n('Y-m-d'));
       	}
       	echo '</table>';
       }
       ```
   
 * This is somewhat beyond the free support of this plugin though, if you need to
   export this data I recommend looking for an order exporter plugin that can export
   order meta too (using the `_wcpdf_invoice_number` meta field).
 * Good luck!

Viewing 1 replies (of 1 total)

The topic ‘Customize code snippet’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-pdf-invoices-packing-slips/assets/icon-256x256.
   png?rev=2189942)
 * [PDF Invoices & Packing Slips for WooCommerce](https://wordpress.org/plugins/woocommerce-pdf-invoices-packing-slips/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-pdf-invoices-packing-slips/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-pdf-invoices-packing-slips/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-pdf-invoices-packing-slips/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-pdf-invoices-packing-slips/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-pdf-invoices-packing-slips/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Ewout](https://wordpress.org/support/users/pomegranate/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/customize-code-snippet/#post-11179924)
 * Status: resolved