i Need help about mission order on my site ...
when i create first order then its ok , then when i go to create second order it goes to missing order.
and no order are shown in customer order history.
no error detect on error log.
iam just confused why that problem occurs and where..
sr
my extension:https://www.opencart.com/index.php?rout ... estshop24h
email :support@bestshop24h.com
site:http://www.bestshop24h.com
The state after confirmation depends on the payment module you use, they set it and normaly have that status stored in the settings.
Cash on delivery sets it immediately whereas paypal standard sets it after receiving the call-back.
So you would have to look at the payment module first.
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.
What payment gateway?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Cash on delivery
or
Bank transfer
i again install fresh opencart but same case occur again
sr
First of all, are you speaking about creating an order in the shop or in the backend as admin?
Second, how did you create the 1. order - and how the second (precise the steps), what did you between?
Wether first nor second?
And I am sure they are there, try to change the dropdown at Order State and filter after that.
Have you enabled full error reporting (default normally is no, so you have to add this manual)?!
I guess not, because otherwise at least an entry in the server (apache) logfile should be visible.
And - finally: which template (if orders are created in the shop) are you using?
p.s: all payment types using no external gateway or processor are using the order state as defined in the shop configuration.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
I've made couple of test orders as client with or without registered account. All orders receive "Successfull order" page confirmation on front-end.
1. First order placed
- showing in OC back-end = YES
- status = Pending
- email received for new order = YES
- showing in OC front-end/client account = YES
- status = Pending
- email received for new order as client = NO
I've canceled the order from OC back end with customer notification, surprise notification received via email as Client.
2. Second order placed
- showing in OC back-end = NO
-showing in OC back-end filter "missing order" = YES
- status = Canceled
- email received for new order = NO
- showing in OC front-end/client account = NO
- email received for new order as client = NO
I've closed browser and cleared cache and repeated the proccess 3 times, same result. First order placed has Pending status, second has Canceled status.
installed OC version is v3.0.3.3
- no 3rd party extensions
- default theme with some minor visual tweaks, not affecting the functionality
- no errors in error log
- payment method used is COD (cash on delivery)
- shipping method used is Flat Shipping Tax
It only shows canceled in the dropdown as that is the first option of the dropdown which does not have the "missing" (zero) value.
if you used COD and the order retains status 0 then your order confirmation did not process correcly.
When confirming payment method, the order is saved with status 0.
When confirming the order, the payment method sets the correct status and then the emails go out.
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.
Yes i know that. in SQL DB the order has order_status_id = 0.letxobnav wrote: ↑Sat May 30, 2020 10:22 amBe aware, the second order does not have status canceled as it has status 0.
It only shows canceled in the dropdown as that is the first option of the dropdown which does not have the "missing" (zero) value.
if you used COD and the order retains status 0 then your order confirmation did not process correcly.
When confirming payment method, the order is saved with status 0.
When confirming the order, the payment method sets the correct status and then the emails go out.
So, from what you are saying ... seem that is a "order confirmation" issue. The funny thing is that the order confirmation goes well, actually showing last page "successfull order" but the client email never arrived, so there i start to worry that something is not right.
From the COD controller you can see that when confirming the order, it first adds to the order history which sets the correct order status as set in your settings as "payment_cod_order_status_id" and that triggers the sending of the emails via the event "mail_order_add" in your event table.
When that order status goes from 0 to something else, an order confirmation email (new order) is triggered by the event.
When the order status goes from not 0 to something else, an order status update email is triggered by the event.
After that is done, you are directed to the success page where then the entire order information in the session is removed.
Code: Select all
public function confirm() {
$json = array();
if ($this->session->data['payment_method']['code'] == 'cod') {
$this->load->model('checkout/order');
$this->model_checkout_order->addOrderHistory($this->session->data['order_id'], $this->config->get('payment_cod_order_status_id'));
$json['redirect'] = $this->url->link('checkout/success');
}
$this->response->addHeader('Content-Type: application/json');
$this->response->setOutput(json_encode($json));
}
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.
Makes sense, my point too. But should be another if {} to check < order_status_id != 0 > before redirect to $json['redirect'] = $this->url->link('checkout/success'), because:
1. makes sense to have no confirmation email for order_status_id = 0 (Fail Order Page should be displayed).
2. makes NO sense to have "no confirmation email" when you have "Success Confirmation Page".
3. also makes NO sense to have "Success Confirmation Page" and have order_status_id = 0. I understand that this payment check must be done in case of PP or Card payment, where the payment processing entity will bounce back with some payment OK or payment FAIL that will set the final order_status_id but in case of COD the order_status_id should be anything else but 0 right away. When you click Confirm Order in this particular case of COD or Bank Transfer the order_status_id should be 1 (pending) without any issue.
Yes, indeed but what is wrong ? thats the big question, thats why i'm writing here ... i need something helpfull to grap on, i'm not developer but i understand php so i can dig dipper with some help from a expert in OC.
You could add some tracing:
in config.php you add:
Code: Select all
define('TRACE', true); // enable trace messages
after:
Code: Select all
if ($order_info) {
Code: Select all
if (TRACE) $this->log->write('addOrderHistory -> order_id: '.$order_id.', current status: '.$order_info['order_status_id'].', new status: '. $order_status_id);
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.
viewtopic.php?f=202&t=217052#p783203
Jim
https://www.carguygarage.com
Yahoo Store since 2006 moved to OpenCart on January 24, 2020
Besides, throwing an email over the wall and hope for the best may be speedy, it is hardly a solution nor very smart, you might as well use php mail.
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 anyone solve the problem with the missing orders? I have the same problem and is very annoying. I don't think there is a problem with the email or smtp because the problem is that the status order is 0 and is not changing. Can you please help me?
Thank you
You need to provide more information. What version of OpenCart? What version of PHP? What theme? What extensions that modify the checkout or orders? What payment extensions are being used? Any errors in the OpenCart error log? Any errors in the server/PHP error log?nikythebest wrote: ↑Thu Mar 24, 2022 6:23 pmHello,
Did anyone solve the problem with the missing orders? I have the same problem and is very annoying. I don't think there is a problem with the email or smtp because the problem is that the status order is 0 and is not changing. Can you please help me?
Thank you
Using latest version 3.0.3.8
With this payment method 'First Data EMEA Connect (3DSecure enabled)' which came with OC
Works fine with 'PayPal Commerce Platform'. Orders are fine along with both sets of confirmations.
But just not First Data, all seem to go to missing.
No errors in logs and order statuses are set correctly.
Have you given First Data your Notification URL? Have you checked your web access logs to see if first Data call your Notification URL? Have you switch on the First Data payment extension logging and looked in firstdata.log?justint24 wrote: ↑Fri Mar 25, 2022 12:21 amI am also experiencing missing orders. If anyone could help.
Using latest version 3.0.3.8
With this payment method 'First Data EMEA Connect (3DSecure enabled)' which came with OC
Works fine with 'PayPal Commerce Platform'. Orders are fine along with both sets of confirmations.
But just not First Data, all seem to go to missing.
No errors in logs and order statuses are set correctly.
First data logs have been switched on today via the extension and so for this is what has been recorded in the log
2022-03-25 9:42:00 - getOrder - 18807
2022-03-25 9:45:19 - getOrder - 18808
2022-03-25 10:10:17 - getOrder - 18808
Users browsing this forum: No registered users and 263 guests