Community Forum

reset invoice numbering

• • Gijs Kruize

    Participant

    # 1 year, 5 months ago

    I really love the plugins that you guys make, but there is some difficulty in resetting the invoice number.
    I have looked everywhere in the DB, and looked at the source code but could not get it to reset.
    I tried emptying my WP_posts and WP_postmeta table but then the postnumbers reset but the invoice number keeps climbing
  • Thomas

    Keymaster

    # 1 year, 5 months ago

    Hi,

    but the invoice number keeps climbing

    Are you trying to completely stop sequential numbering?

    If yes, did you see those options ?

    • Settings > WP Customer Area > Invoices > Sequential numbering > If checked, invoice numbers will be sequential. If not, the invoice numbers will be given by the post ID
    • Settings > WP Customer Area > Invoices > Sequential numbering > Start at

    Else, if you’d like to manually reset the sequential numbering into the DB, it is located in wp_options table, cuar_options, and the key is cuar_in_current_sequence_number.

    However, be careful, those options are serialized arrays. You might probably want to use a tool that allows you to edit serialized datas in a database.

    Regards.

    Want to help WP Customer Area? It only takes few seconds!
    Rate & review the plugin on WordPress.org 🙂