Order number versus order ID and payment gateway
Order number versus order ID and payment gateway
First off let me say that I'm aware of the differences between order number and order id (the forum is a great resource). With that in mind I have two questions:
1) What would cause the order ID to suddenly change? We are a low-volume store and currently are using AC only administratively (i.e. the store hasn't been released publicly). Our order numbers/ids got out of sync for no apparent reason, going ...68/68, 69/69, 74/674, 75/675...
2) Why would the order id be sent to our cc gateway instead of the order number? It makes for a bit more work to reconcile information from our processor with information in AC since the order id isn't displayed to the end user.
1) What would cause the order ID to suddenly change? We are a low-volume store and currently are using AC only administratively (i.e. the store hasn't been released publicly). Our order numbers/ids got out of sync for no apparent reason, going ...68/68, 69/69, 74/674, 75/675...
2) Why would the order id be sent to our cc gateway instead of the order number? It makes for a bit more work to reconcile information from our processor with information in AC since the order id isn't displayed to the end user.
Re: Order number versus order ID and payment gateway
If jump is in order number then may be during testing some one changed next order number or order number increment. You can see these settings under store -> settings page.1) What would cause the order ID to suddenly change? We are a low-volume store and currently are using AC only administratively (i.e. the store hasn't been released publicly). Our order numbers/ids got out of sync for no apparent reason, going ...68/68, 69/69, 74/674, 75/675...
Although order id is proceeded at many locations but for display purpose we show order number. If you are seeing orderid instead of order number some where for payment gateway. Gan you provide me the name of gateway you are using for CC processing and some description about where its happening?2) Why would the order id be sent to our cc gateway instead of the order number? It makes for a bit more work to reconcile information from our processor with information in AC since the order id isn't displayed to the end user.
Re: Order number versus order ID and payment gateway
The big jump was in the order ID. We were running into some problems with ordering due to a store setting, which could certainly account for the discrepancy. I found it odd that the ID jumped so much, though, and by exactly 600. Figuring that out is more for my own edification than anything else.mazhar wrote:If jump is in order number then may be during testing some one changed next order number or order number increment. You can see these settings under store -> settings page.bsweeney wrote:1) What would cause the order ID to suddenly change? We are a low-volume store and currently are using AC only administratively (i.e. the store hasn't been released publicly). Our order numbers/ids got out of sync for no apparent reason, going ...68/68, 69/69, 74/674, 75/675...
We're using Paymentech. I'm seeing a few issues with this processor. The other one I've already submitted a bug report for (AVS response codes aren't reported correctly). I enabled debugging on the gateway and AC is reporting the order ID in the OrderID field in the XML. Presumably this should contain the order number instead?mazhar wrote:Although order id is proceeded at many locations but for display purpose we show order number. If you are seeing orderid instead of order number some where for payment gateway. Gan you provide me the name of gateway you are using for CC processing and some description about where its happening?bsweeney wrote:2) Why would the order id be sent to our cc gateway instead of the order number? It makes for a bit more work to reconcile information from our processor with information in AC since the order id isn't displayed to the end user.
Re: Order number versus order ID and payment gateway
Well I am not sure why this is case because we have no setting to change orderid. May be some one may have tried some change on database schema level during tests.
About second issue, if this is the case and processor is sending orderid in my personal opinion order number makes more sense then order id for providers. Anyhow I suggest you to report a bug on our CRM with details.
About second issue, if this is the case and processor is sending orderid in my personal opinion order number makes more sense then order id for providers. Anyhow I suggest you to report a bug on our CRM with details.
Re: Order number versus order ID and payment gateway
Will do!mazhar wrote:About second issue, if this is the case and processor is sending orderid in my personal opinion order number makes more sense then order id for providers. Anyhow I suggest you to report a bug on our CRM with details.
-
- Ensign (ENS)
- Posts: 20
- Joined: Mon Aug 30, 2010 9:51 am
Re: Order number versus order ID and payment gateway
Hello,
Can you explain to me what you mean by "First off let me say that I'm aware of the differences between order number and order id (the forum is a great resource)" ?
My client just emailed me saying that the confirmation emails are listing orders that are off by one. In the email they see order # 7669 but in the admin area it's #7668. I noticed when I went to view the order in the admin area that I saw BOTH in the querystring! Ex: /Admin/Orders/ViewOrder.aspx?OrderNumber=7668&OrderId=7669 Why are there two? Is it possible to get them synched up? Or should I just update the email to display the Order "Number" instead of the "ID?"
Thanks for any help or direction you can provide.
Can you explain to me what you mean by "First off let me say that I'm aware of the differences between order number and order id (the forum is a great resource)" ?
My client just emailed me saying that the confirmation emails are listing orders that are off by one. In the email they see order # 7669 but in the admin area it's #7668. I noticed when I went to view the order in the admin area that I saw BOTH in the querystring! Ex: /Admin/Orders/ViewOrder.aspx?OrderNumber=7668&OrderId=7669 Why are there two? Is it possible to get them synched up? Or should I just update the email to display the Order "Number" instead of the "ID?"
Thanks for any help or direction you can provide.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Order number versus order ID and payment gateway
You should just update your emails to show the order number, the one the customer sees. The order id/order number has been that way for so many years that I don't remember all the reasons, but the order id is an auto-incremented field in the database and that is assigned before the order gets sent to they payment gateway. The order number is assigned after that, when the order is "created". There might be gaps in the order id sequence if you have orders that were not created because a payment fails. There are not normally any gaps in the order number sequence.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
-
- Ensign (ENS)
- Posts: 20
- Joined: Mon Aug 30, 2010 9:51 am
Re: Order number versus order ID and payment gateway
So if the most recent order has OrderNumber=7709 and OrderId=7710, then I just need to up the OrderNumber to be 7011. Then it will be in synch with the OrderID for the next purchase. And there's a way to update the OrderNumber, in Configure > Website. I purchased the next order myself, to test, and they are now the same. Thanks!