Hi, we had our website redesign but after we moved over the new website, the invoice numbers of each order disappeared. We can manually add the invoice numbers but the sequence is all out as the old invoice have no invoice numbers.
What we are looking to do is reset invoice numbers to 1 from 1st July 2022 orders so they go sequentially from there and then add automatically going forward. Can this be done with the plugin?
If not, what should be the best action to take to resume the automatic numbering of invoices?
Thank you in advance for your reply.
Marissa
The page I need help with: [log in to see the link]
When you say “we moved over the new website”, do you mean you have exported the data from the database too, including the WooCommerce data? If so, it is likely that the exporting process skipped some metadata from the orders’ data, including our documents’ data, which are stored under these meta keys:
_wcpdf_invoice_settings
_wcpdf_invoice_date
_wcpdf_invoice_date_formatted
_wcpdf_invoice_number
_wcpdf_invoice_number_data
If you still have access to the old site, try to export the documents’ info with these meta keys, and then import it to your new site to start seeing your invoice details.
On the other hand, you can reset the invoice number under WooCommerce > PDF Invoices > Documents > Invoice> Next invoice number:
For instance, if your last invoice number was 148, you have to enter 149 here, which will be the next invoice number to assign to the next PDF invoice generated.
We used the WooCommerce Customer / Order / Coupon Exportto export the orders and customers. When we export the orders, i checked the csv file and cant find the metas that you mentioned even if the export was set up to export all metas. The invoice numbers still not included. What did we miss something or some sort?
Is there another plugin to export the invoice numbers data? Or how do you export the invoice numbers?
There are several export plugins available that integrate with ours. For example, you could try a pretty good free plugin called Advanced Order Export For WooCommerce from AlgolPlus. Another option (paid) that also collects the fields of our invoices and is a little more intuitive is: Store Exporter Deluxe for WooCommerce by Visser Labs.
Below you’ll find a short video explaining how to export both the invoice date and number, using the first plugin I recommend above (the free one):
Thank you. I was able to export the invoice numbers. But i cant import it using CSV Import Suite. There is no field map out for Invoice numbers. Is there a plugin, too for import that is compatible to your plugin?
I was able to import the invoice numbers. Thank you.
But now client wants to revise the invoice numbering. I tried to import the new set of invoice numbers hoping it will overwrite the old invoice numbers under _wcpdf_invoice_numbers meta. But it didnt work.
Is this possible – to import and overwrite old invoice numbers with new ones?
Sorry if I do not understand: Do you want to renumber old invoices? If so, this should be possible with an importing tool/plugin that allows you to override existing values.
In my opinion, one of the best plugins for this job is WP All Import. Please note that you will need to buy the Pro version, in order to get the WooCommerce add-on to be able to import data within orders.
Viewing 7 replies - 1 through 7 (of 7 total)
The topic ‘Missing Invoice Numberes’ is closed to new replies.