Order numbering skipped a number

If you are runnig Joomla 3.x and Virtuemart 3.x please post to this forum your questions or support tickets about One Page Checkout

Order numbering skipped a number

Postby yolknet » Wed Feb 19, 2020 4:47 pm

As you can see in the attached screenshots the counting of the numbers is going wrong sometimes. The blue numbers are from the One Page Checkout, the black numbers are the invoice numbers. Has anybody experienced a problem such alike? It looks like an order is added to the One Page Checkout extension, but not to Virtuemart.
I checked the database and fount Order-2020-02-00030 in #__onepage_numbering. The timestamp of 00030 is 18:39:59, the timestamp of 00031 is 18:40:11. So just a few seconds later.
I can't explain what happened, why it happens and how it can be solved. Maybe somebody has suggestions?
Attachments
missing-order-2.png
missing-order-2.png (6.52 KiB) Viewed 5160 times
missing-order-1.png
missing-order-1.png (6.28 KiB) Viewed 5160 times
yolknet
 
Posts: 3
Joined: Thu Jun 07, 2018 5:27 pm

Re: Order numbering skipped a number

Postby admin » Thu Mar 05, 2020 8:31 pm

hello, this seems to me like hiding or recycling order issue - can you pls check if you see any deleted (or other) orders which could be related to those missing numbers ?
in OPC by default order re-use is disabled, but if altered by some 3rd party payment plugin which drops an order upon cancelled payment, it could lead to such problems.

best regards, stan
admin
Site Admin
 
Posts: 2708
Joined: Wed Jan 06, 2010 11:43 pm


Return to One Page Checkout for Virtuemart 3 on Joomla 3.x

cron