Missing invoice numbers appear in old orders

  • We are missing invoice numbers. Just out of the blue it seems that some numbers don’t be written to new orders, but to old ones. How is that possible?

    Yesterday one and today another one. Today an oder of a month old that gets an invoice number that should be written to of todays orders.

    My Client says that the older order that got the invoice nr he tried to do a refund of, but didn’t do that in WooCommerce -> with Mollie (the payment provider).

    Any idea?

    • This topic was modified 6 years, 10 months ago by creativenl.
Viewing 13 replies - 1 through 13 (of 13 total)

  • Hi @creativenl,

    I am sorry I didn’t understand the problem. Are you saying that when you send an invoice for any orders, the invoice numbers get changed? Please correct me if I am wrong.

    Regards,
    Rashmi

    Thread Starter creativenl

    (@creativenl)

    No it seems that an older order which didn’t have an invoice nb yet (the plugin wasn’t installed then yet) got a invoice nr which my client missed because it was an old order (last month). They made a refund by Mollie, but didn’t do anything in WooCommerce.
    I changed the invoice nr now in mysql, but want to know why this happens.

    Thread Starter creativenl

    (@creativenl)

    Also 3 other old orders have been given invoice numbers that we can’t explain. I deleted them now in the database.

    Hi @creativenl,

    The invoice numbers are generated when an invoice is created. As you generated a refund for a client, an invoice may have been created as it didn’t have one.

    That is why the old orders are getting the invoice numbers.

    Regards,
    Rashmi

    Thread Starter creativenl

    (@creativenl)

    ok, should all the old orders get an invoice no to avoid this problem?
    -> how can we do this?

    Thread Starter creativenl

    (@creativenl)

    Maybe “year-orderid”

    Hi @creativenl,

    I apologize for the late reply.

    This would again require some custom coding. If you go the file ‘class-wcdn-print.php’in woocommerce-delivery-notes/includes, you will find a function called get_order_invoice_number(). You will have to prefix it with the year from the order.

    Let me know if this is the way you want the invoice numbers to be.

    Regards,
    Rashmi

    Thread Starter creativenl

    (@creativenl)

    Well.. i just don’t want new issues with missing invoice numbers (that went to old orders because of something we did in WooCommerce).
    A one time action in MySQL is also enough or not?

    Or maybe an option in the settings to give all orders without an invoice number a number. That could be “year-id” to make it easy.
    We want all new orders to have following invoice numbers for our accounting.

    Thread Starter creativenl

    (@creativenl)

    Did you look into this?

    Hi @creativenl,

    This would be a bit tricky to implement. But I will try it and let you know asap.

    We are discussing this issue and see if we could add it in the next update.

    Regards,
    Rashmi

    Thread Starter creativenl

    (@creativenl)

    i’m open to other ways to do this is!

    Thread Starter creativenl

    (@creativenl)

    Any news? We again are missing invoice numbers. Probably again old orders that got the a new invoice nr…

    Thread Starter creativenl

    (@creativenl)

    Please advice me how to do this. OR how to fix that old orders aren’t getting a new invoice nr

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Missing invoice numbers appear in old orders’ is closed to new replies.