|
SWTA
|
April 24, 2015 at 5:19 am
Since about the 5th February 2015, which I believe was around the time we upgraded to EE v.4, the Transaction ID’s, which used to be sequential, are skipping numbers, so for example a transaction ID could be 1234 and the next, instead of being 1235 will skip to 1301. They are still all unique and higher than the previous number, but unfortunately due to VAT requirements we need them to be sequential.
It is almost as if the database that stores and assigns these ID numbers is being used by multiple companies, but we can only see the transactions carried out on our site.
Any idea how this can be resolved please? Thanks
|
|
Tony
|
April 28, 2015 at 3:32 am
Hi,
The reason for this is due to the fact that within EE4 the registration (and associated transaction) is created as soon as a user selects a ticket and clicks to register.
If the user then abandons the registration, the transaction has already been recorded.
What this means is if User A registers and completes the registration (either with full payment or selecting Invoice as a payment method) they have a TXN ID of 1.
User B selects a ticket, but then closes the browser and does not complete. That users TXN still has an ID of 2 but they are listed in the Incomplete/Failed listings so you don’t see them in the regular list.
User C registers and completes the registration, they are assigned the TXN ID of 3 and you will see those registrations in the standard lists. Which means the main list has missing numbers – 1,3,4,6,11,27 (depending on how many abandoned registrations there are in between)
We are looking into a solution for sequential id’s in EE4 but currently this is not available.
May I ask, at which point would you need the number to be assigned? For example using the User C from above. Lets say they select Invoice as their payment method, but have no intention of actually paying for the event. You don’t know that at the time, but in order to send the invoice, they would need a unique number correct?
Then we add online payments (for example PayPal) User D registers and pays through PayPal, they would be TXN ID 4…
User E registers and selects Invoice, would they then be TXN ID 5? Or should the online payments not be included in these sequential numbers? (EE will generate an invoice for those registrations)
Apologies for the questions, I’m wondering if there is an available work around but need to know exactly how this would work to do so.
|
|
SWTA
|
April 28, 2015 at 8:58 am
Thanks for the response, I will get back to you later on the point at which we would like the transaction ID added, but to go to your initial explanation of why the numbers jump, I find this an unlikely cause. The reason being that we have in general two or three transactions per day, yet the transaction ID will jump up by hundreds. I will give you some recent examples:
23 April – ID 9894
23 April – ID 9913
23 April – ID 9922
27 April – ID 10413
27 April – ID 10454
27 April – ID 10475
28 April – ID 10593
Some of these jumps could I guess be explained by aborted transactions but I don’t think that there would be as many as this suggests.
|
|
Tony
|
April 28, 2015 at 9:07 am
If you go to Event Espresso -> Transactions.
You’ll see 3 different filter links on the top of the table, one of which is ‘Failed Transactions’ – http://take.ms/DG7Gn
If you click that, do you see the missing transactions ID listed there? There may also be some mixed within Abandoned transactions too.
|
