We’ve been noticing a few oddities with our Mage store I want to run by you. First, our customer order numbers frequently do not increment by 1: often by 2, 3 and a few by 4 or 5 from the previous order #!!! I ask about this because we wonder if this could be an indicator of a bug. Specifically, we added some logging at the very end of the purchase process (long story) and in at least one instance, a sale made it all the way through the purchase process, was logged and then was not present in magento. In fact, a SECOND order, not manually entered by the customer, ended up being processed all the way through the credit card charging step and past our logger. That order showed up in Mage as a completed sale. So, the mysterious initial order #10000079 was CC processed, logged and not in the Mage sale order list but the next order #10000080 was in the sales order list. Its almost as if Mage threw an exception at the end of processing order #10000079 (which included a successful auth.net CC charge) and as part of some recovery logic reprocessed the order, which succeeded as #10000080. (And we’re confident its not our logging that was the problem as this is actually external to Mage and virtually transparent to it.) Anyone seen anything like this before?
Magento has ability to log the request and response for most of the payment gateways,
You can enable via admin configuration by setting yes for Debug flag.
By doing that, you can see the request that Magento sent and response that Magento receive in the database. E.g “paygate_authorizenet_debug” table for authorize.net
Magento natively reserve order id before sending to payment gateway.
You can see
If there is an error or decline in payment processing, the order id will be incremented.
Can you set it to debug for a live site; I thought that was only while in development?
Also, did anyone find out what’s happening, I’m seeing the same results using the Protx Direct extension; virtually every order number is skipping 1 - 5 numbers, I’ve checked the Protx console and there are only a few failed transactions, not enough to warrant this amount of order numbers being skipped.
The flag can enable/disable no matter you are on live site or dev site.
Sometimes you would like to check what request you make to the payment gateway and what response you are receiving from the gateway.
I just noticed that this has happened in my shop. A customer called
for info about their order & there was no order.
Then I noticed that the orders were not numbered sequentially.
What is happening? Are the orders missing? Did the customer make a misteke?
This is probably going to end my love - hate relationship with Magento.
bump x 2.
Our problem is an extension of this. We find people coming back weeks later to complete an order. They keep their original incrementid so our daily order export has already moved beyond the range in which their order number falls. We miss their order and have to refund them. What can we do?