Sequential Order Number

Additional Info:

Here’s the info from the database:
_options
edd_settings:
s:16:”sequential_start”;s:4:”2100″;s:17:”sequential_prefix”;s:3:”ARE”;s:18:”sequential_postfix”;s:2:”OC”;

After changing the number, did you run the upgrade routine to reset numbers?

No, how do I do this?
I just changed the starting number “2100”, then saved it.

I just found the link to the “update” database on top.

Sorry about that, I didn’t think of looking there for it.

Thanks for the reply…….

Still having problems with the Sequential Start Number.

I did the “Update” and was able to see the Sequential Order Number changed on all prior orders for customers, but when I do a new purchase, it’s still not updating the new starting number, still getting ARE-10-OC when it should be ARE-1403-OC. Seems the number in the db is not being updated with the new Sequential Start Number.

I just did a fresh install of WordPress (4.2.2) using Twenty Thirteen theme with no other plugins except EDD. Having the same issue as stated above.

I did one test not using a Sequential Order Number, the order number started at 11 (I believe).

I then enabled Sequential Order Number and set the Sequential Starting Number to 2100 and did the update. It updated past numbers in the Payment History, and on a new purchase, it did show the correct number 2101.

I then changed the Sequential Starting Number to 3100, did the the “Update”. It updated past numbers in the Payment History, but on a new purchase, it was still showing (2100), not the (3100) start number.

I marked this “Resolved” the other day when I thought it was resolved. Can you change it back to unresolved?

Would like to know if there is a fix for this, or if I can manually change the db field that holds the Sequential Starting Number?

Can you show me a screenshot of your Misc settings tab?

Here’s the link to the image:

https://i868.photobucket.com/albums/ab244/rbschneider1/Easy%20Digital%20Download%20-%20Misc%20Settings.png

Thanks…..

Pippin,

I went into the db (_options, edd_last_payment_number) an was able to change the the number to the correct number, so all is good on my end.

Seems that whenever I change the Sequential Start Number in “Misc” after the the initial start number, it but does not update the db with the new number, but it does update the the previous payment numbers in the Payment History.

Does it appear to be tracking new numbers properly as well now?

Still issues.

When I changed the db “edd_last_payment_number” to the new number it works for the new orders, but only for the Payment History page ID#. If I click on “view details” of a purchase, the Payment Meta Transaction Number is the old number, if I go to Customer then “View” is show the old number, and on the Dashboard Sales Summary it shows the old numbers when hovering over the name.

Is there a way to do a new install of EDD without loosing all my product data?

Any idea of what’s going on with this issue?

Can you show me a screenshot of where the number is wrong?