Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Which OC version?head_dunce wrote: ↑Fri Jan 31, 2020 6:37 amJust got another "missing" order. This is going to make a mess of the CRM stuff I have connected to OC. How do I stop these?!?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
What are your order statuses options from your payment extension modules and from your store settings?
Hint to help you with the order statuses options: viewtopic.php?f=202&t=215908#p775740
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Using the built in Authorize.net AIM extension and the order status is "Processing"straightlight wrote: ↑Fri Jan 31, 2020 9:43 amWhat are your order statuses options from your payment extension modules and from your store settings?
Hint to help you with the order statuses options: viewtopic.php?f=202&t=215908#p775740
And it gets even weirder, today one of the "Missing" orders from yesterday was actually placed. My guess is the order number is assigned when people go to the checkout page, but if they don't checkout it ends up "Missing" --- This is going to be a nightmare to verify that all orders are indeed carried over via API to other systems because if one is missed, there's not going to be an easy way to see that. This is not good.
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Correct, OC will keep generating an order on checkout, every time you reach the confirm section. If you have one of those one page checkouts, my guess is its probably worse. If a customer goes back to change their address, another order is created, etc. Qphoria has something, not sure if its still working in 3.0, but can try or adapt it viewtopic.php?f=121&t=9192head_dunce wrote: ↑Sat Feb 01, 2020 1:42 amUsing the built in Authorize.net AIM extension and the order status is "Processing"
And it gets even weirder, today one of the "Missing" orders from yesterday was actually placed. My guess is the order number is assigned when people go to the checkout page, but if they don't checkout it ends up "Missing" --- This is going to be a nightmare to verify that all orders are indeed carried over via API to other systems because if one is missed, there's not going to be an easy way to see that. This is not good.
You might just want to look into using Authorize.nets WebHooks,. They also have a full PHP SDK you can call in via composer, I have used it many times for CIM and Accept.js integrations.
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
That doesn't solve knowing if all orders are transferred over the APIOSWorX wrote: ↑Sat Feb 01, 2020 8:14 pmSimply get this: https://www.opencart.com/index.php?rout ... n_id=38449
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
"API" was never mentioned.head_dunce wrote: ↑Wed Feb 05, 2020 11:06 pmThat doesn't solve knowing if all orders are transferred over the APIOSWorX wrote: ↑Sat Feb 01, 2020 8:14 pmSimply get this: https://www.opencart.com/index.php?rout ... n_id=38449
Nevertheless, this extension display whenever you login into your backend, that you HAVE missing orders (1 or many).
What's the reason for that, is not my responsibility.
Without you will never get notified - as some of my clients in the past (that was the reason I have made this 3 years ago).
As said earlier, if you have "missing" orders, either in your checkout goes something wrong, your customers are confused (of whatever), they decided in the last monent not to buy/order .. or something else.
Some do not like the x-step checkout, some do not like a 1-page-checkout.
Some are tired of so many checkout steps, some do not like how the moon is shining this night.
Or maybe his girlfriend has seen that he wants to order such expensive tires .. who knows?
It is finally up to you, to see what is the reason and how to solve.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Means, he/she/it could finish also later - in that case the order ID is higher than the former "missed order".
Reason (maybe): adding another item to the basket or changing something (basket/address/payment/delivery).
This is how the system works - since many years.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
This is because external payment gateways need the order number and OC does not know how they are externally processed/abandoned.
OC calls these orders "missing" but they are basically orders in limbo i.e. an undetermined status at present, some will be revived once the user confirms the order with local payment methods or when a callback has been received from an external gateway and some will remain in limbo forever.
You could say that any order with status 0 older than a day may be considered obsolete as external payment gateways generally respond before that.
Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces
“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.
Did you have a look at the authorize.net Webhooks I mentioned above? https://developer.authorize.net/api/ref ... hooks.htmlhead_dunce wrote: ↑Wed Feb 05, 2020 11:06 pmThat doesn't solve knowing if all orders are transferred over the API
On the Webhook endpoint, you could do some simple PHP logic:
1. Check if an order is of missing status and was charged.
2. If the order was charged and of status missing, update the opencart order status to processing, subtract the stock and rerun your inventory syncing.
Obviously, you would need to secure the route and other necessary logic, but might be an option for you.
https://developer.authorize.net/api/ref ... on-details
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
Thanks. I've got a different idea, but I'll give this a look.sw!tch wrote: ↑Thu Feb 06, 2020 7:56 amDid you have a look at the authorize.net Webhooks I mentioned above? https://developer.authorize.net/api/ref ... hooks.htmlhead_dunce wrote: ↑Wed Feb 05, 2020 11:06 pmThat doesn't solve knowing if all orders are transferred over the API
On the Webhook endpoint, you could do some simple PHP logic:
1. Check if an order is of missing status and was charged.
2. If the order was charged and of status missing, update the opencart order status to processing, subtract the stock and rerun your inventory syncing.
Obviously, you would need to secure the route and other necessary logic, but might be an option for you.
https://developer.authorize.net/api/ref ... on-details
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 18 guests
