OpenCart Community

This topic has been split elsewhere. No location provided.

So is there a way to stop these "missing" orders? I'm so confused.

Just 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?!?

head_dunce wrote: ↑

Fri Jan 31, 2020 6:37 am

Just 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?!?

Which OC version?

Version 3.0.3.2

head_dunce wrote: ↑

Fri Jan 31, 2020 7:48 am

Version 3.0.3.2

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

straightlight wrote: ↑

Fri Jan 31, 2020 9:43 am

head_dunce wrote: ↑

Fri Jan 31, 2020 7:48 am

Version 3.0.3.2

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

Using 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 could either look for an extension that allows notification on missing orders such as: Abandoned orders from the Marketplace. Or, you could code an event based on the time period where an order status does not change (default order status of the store settings, for instance).

head_dunce wrote: ↑

Sat Feb 01, 2020 1:42 am

Using 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.

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=9192

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.

Simply get this: https://www.opencart.com/index.php?rout ... n_id=38449

OSWorX wrote: ↑

Sat Feb 01, 2020 8:14 pm

Simply get this: https://www.opencart.com/index.php?rout ... n_id=38449

That doesn't solve knowing if all orders are transferred over the API

head_dunce wrote: ↑

Wed Feb 05, 2020 11:06 pm

OSWorX wrote: ↑

Sat Feb 01, 2020 8:14 pm

Simply get this: https://www.opencart.com/index.php?rout ... n_id=38449

That doesn't solve knowing if all orders are transferred over the API

"API" was never mentioned.
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.

During those events, best to use an account software synced with the store. There seem to be higher requests on the forum these days. This way, despite the reasons involved, regarding the order statuses, you'll be able to maintain the load-balancing levels of all your sales throughout the year.

One final note on this "issue": a "Missing Order" is also an order the visitor/customer did not finish - yet!
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.

Take note that adding another item as a suggestion must be done within 1 hour interval for guest users. Otherwise, the cart data gets automatically cleared afterwards if no updates from the product page or the cart page by guest users have been done.

An order with status 0 is created every time the payment method is confirmed.
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.

head_dunce wrote: ↑

Wed Feb 05, 2020 11:06 pm

That doesn't solve knowing if all orders are transferred over the API

Did you have a look at the authorize.net Webhooks I mentioned above? https://developer.authorize.net/api/ref ... hooks.html

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

sw!tch wrote: ↑

Thu Feb 06, 2020 7:56 am

head_dunce wrote: ↑

Wed Feb 05, 2020 11:06 pm

That doesn't solve knowing if all orders are transferred over the API

Did you have a look at the authorize.net Webhooks I mentioned above? https://developer.authorize.net/api/ref ... hooks.html

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

Thanks. I've got a different idea, but I'll give this a look.