Sequential Order Bug?

Hello thescarletfire,

I am having the same issue, did you find a way to reset the invoice numbering ?

Thanks

• This reply was modified 5 years, 5 months ago by yamo.

Hi @yamo and @thescarletfire

Once you enable the sequential number EDD will start number from it.

For example, If you have saved setting with 100 so when you new order is generated and it will take 100 order id. The next order will take 101 order id.

Now if we change the settings to 50 and save it then plugin will still take 102 as a next order ID. It will not take 50 as order id.

So once the sequential order is started then we can not reset it. If it has been reset then same ID will be generated multiple times and it creates problem.

So once the order is placed then Sequential number will not be changed and can not be reset.

Hi.

I’m sorry, but I don’t quite agree. First, I think there should be a fallback fail-safe if a user simply fat-thumbs the keyboard and accidentally submits a starting sequential invoice at 100 instead of 1001. Are you telling me there is *no* way to override or reset this counter? IMO this is a huge oversight.

I understand obviously you can’t go down, from 100, to 50, but you should certainly be able to reset or change to a HIGHER number. Which is very common in businesses, to have higher invoice numbers like check numbers.

Can you please make this possible? Can we re-install the plugin? Will that reset the counter? I mean, this is silly ??

There really needs to be a kill switch for this and trust the user that he knows to wipe the invoice history or starting sequential value. Or if you for some reason cannot see the value in this can you at least make it so we can create a higher number?

I’ve had a client once who put the wrong number in and is stuck. Embarrassing.
They meant to type 1001 but typed 100 by mistake.
Now what?

I hope you see my point and can help. Thank you much!

I can’t believe the official position on the plugin here is (with no warning btw, in the plugin before you hit save on that page about the seq reset):

“If you typo this seq value, oh well, start your business at this invoice number instead of, you know, the invoices you’ve been using for years as a company, because, reasons. Next time, make sure you proof it before you hit save! Enjoy your new invoice order.”

I shant believe that ??

Hi @thescarletfire

Sorry, I can understand your concern but fact is if you enabled the sequential number and if any order is placed then there is no way to reset it unless you reset whole store data.

I can provide you a little code snippet to manually reset the “sequential Number” field but you can use it at your own decision. You can take a backup of your DB also.

function _flush_sequential_number() {
	if ( isset( $_GET['flush_seq_num'] ) && $_GET['flush_seq_num'] == 1 ) {
		delete_option( 'edd_last_payment_number' );
	}
}
add_action( 'admin_init', '_flush_sequential_number' );

Add the above code to your theme / child theme functions.php file and save it. Now you need to visit login to your WP dashboard and click on the dashboard menu.

Now add the ?flush_seq_num=1 string at last in your browser URL with current URL. So it looks like something https://WP-SITE-URL/wp-admin/index.php?flush_seq_num=1 and run it.

Once you run the URL, your sequential number index will be flushed. Now navigate to EDD Settings > Misc > Accounting > Sequential Starting Number.

Add your desired number and save it but be sure you have added higher number than the last payment number with sequential order.

• This reply was modified 5 years, 5 months ago by Pratik Jain.

Hi @thescarletfire

Forgot to mention one thing, when you are done then you can remove the code from your theme.

Pratik,

First off, your function works perfectly beautiful – I fixed my invoice numbering and it took 30 seconds. I am so grateful for your help, thank you!!

Second, perhaps you could integrate this in the plugin for other users who encounter this or similar issues? Just a suggestion. Or at least point this function in the FAQ ??

I’ve told Pippin some years ago and I’ll say it again – EDD has the best support I’ve found in the WordPress eco-system. Thank you to everyone involved!!!

I’m back in business up and running with this function reset!

Hi @thescarletfire

Glad to know that your problem has been solved and thanks for your suggestion.

If you like the plugin then rate it and provide your feedback. You can mark the status as resolved also.