Migrate old invoice numbers

Hey @markfme,

Could you share the meta-key in which the Invoice Numbers are stored?
It looks like it is a paid plugin, so you should absolutely ask their support this question and let us know! ??

That should help us replicate the code snippet Ewout wrote in the other thread you mentioned.

Hi Darren @dpeyou,

The meta-key for the invoice number is _bewpi_invoice_number, as shown in: https://imgur.com/a/t3ejkyO

Unfortunately it seems the old plugin is discontinued and we are unable to get support from them.

In addition the invoice number includes the year it was generated as a suffix. Would it be possible to regenerate all the old invoice numbers in that format using the meta data from the old plugin as shown in the image link?

Please let me know what needs to be done further from our end.

Thanks for your help.

Best,

Mark

• This reply was modified 1 year ago by markfme.

Hi @markfme,

Thanks for the meta-data. What about the meta-key for the invoice date?
I could not open the image you linked, it looks like ImGur.com is at full capacity.

> Would it be possible to regenerate all the old invoice numbers in that format using the meta data from the old plugin as shown in the image link?
I believe so, at least based on the thread you linked, as the code snippet still appears valid to me.It does not look like much adaptation needs to happen, though I could be proved wrong ??

For regenerating PDFs with more control, you will need the Professional extension of our plugin. Using the Bulk Export tool that this extension adds, you can regenerate PDFs within a certain range while also prefixing (or suffixing them).


WordPress forbids providing support for paid software here, so please email us at [email protected] for more details. Please mention you were sent there by me (and include a link to this thread)

Hi Darren?@dpeyou,

The image link is still working for me so try checking again or try https://ibb.co/w67fqp6 as it shows all the old invoice meta data. The key for the date is _bewpi_invoice_date in the format 2023-09-18 03:25:02. Another key _bewpi_invoice_pdf path gives the format 2023/711-2023.pdf, where 711-2023 is the format of the old invoices we want to migrate.

We do not wish to generate all of the invoices in bulk at once. What we want is for the original invoice number from the previous plugin to be retained in the format specified above when opening an invoice for a random order. Is this possible using a function and the specified meta keys?

Thanks for your help.

Best,

Mark

Hey @markfme,

Thanks for making it clear ??

Now that you have also retrieved the invoice date, this code snippet is the adaptation from the thread that you linked:

add_filter( 'wpo_wcpdf_invoice_get_date', function( $date, $document ) {
	if ( $document->get_type() == 'invoice' && $order = $document->order ) {
		if ( $legacy_date = $order->get_meta( '_bewpi_invoice_date' ) ) {
			$date = new \WC_DateTime( "@{$legacy_date}", new \DateTimeZone( 'UTC' ) );
			$document->set_date( $date );
		}
	}
	return $date;
}, 10, 2 );

add_filter( 'wpo_wcpdf_external_invoice_number_enabled', '__return_true' );
add_filter( 'wpo_wcpdf_external_invoice_number', function( $number, $document ) {
	if ( ! empty( $document->order ) ) {
		$number = $document->order->get_meta( '_bewpi_invoice_number' ); // if $number is empty, the plugin will generate a new number
	}
	return $number;
}, 10, 2 );

I have only introduced these 2 new meta keys from you:
– _bewpi_invoice_number
– _bewpi_invoice_date

Hi Darren @dpeyou,

I used the code as you gave but unfortunately it generated an error – Exception: Failed to parse time string (@2023-11-22 11:24:47) at position 8 (-): Double timezone specification as shown in: https://ibb.co/pRGc7p6

Is there any way around this?

Thanks for your help.

Best,

Mark

Hey @markfme,

According to the error message, this has something to do with the date. ??

Are you using a custom template? If yes, temporarily switch to the default, unmodified template.

Since I have not tried this myself, I am not sure how this will work if we try to ignore the meta key of the invoice date, but given that the error message is mentioning some sort of duplication (the “Double timezone specification”), I think it is worth giving this a try:

add_filter( 'wpo_wcpdf_external_invoice_number_enabled', '__return_true' );
add_filter( 'wpo_wcpdf_external_invoice_number', function( $number, $document ) {
	if ( ! empty( $document->order ) ) {
		$number = $document->order->get_meta( '_bewpi_invoice_number' ); // if $number is empty, the plugin will generate a new number
	}
	return $number;
}, 10, 2 );

Please remember that testing on live sites is not recommended!
You could use a plugin such as WP Staging or WP Stagecoach to create a staging site.???