Support » Plugin: PDF Invoices & Packing Slips for WooCommerce » Missing Invoice Numberes

  • Resolved marsraagas

    (@marsraagas)


    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]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor Yordan Soares

    (@yordansoares)

    Hi @marsraagas,

    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.

    Thread Starter marsraagas

    (@marsraagas)

    Hi, thanky ou for your response.

    We used the WooCommerce Customer / Order / Coupon Export to 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?

    Thanks in advance for your reply.

    Plugin Contributor Yordan Soares

    (@yordansoares)

    Hi, @marsraagas:

    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):

    Thread Starter marsraagas

    (@marsraagas)

    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?

    Plugin Contributor Yordan Soares

    (@yordansoares)

    Hi @marsraagas,

    As I mentioned in my first reply to this topic, you can use the following item meta keys to import the invoice data to your orders:

    • _wcpdf_invoice_settings
    • _wcpdf_invoice_date
    • _wcpdf_invoice_date_formatted
    • _wcpdf_invoice_number
    • _wcpdf_invoice_number_data
    Thread Starter marsraagas

    (@marsraagas)

    Hi Yordan Soares,

    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?

    Looking forward to hearing from you. Thank you.

    Marissa

    Plugin Contributor Yordan Soares

    (@yordansoares)

    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.