I am having an issue, not sure if it is a bug. I am using OCv3.0.3.2 Clean Install, default theme. Whenever I add store credit to an account, let's say $100 under Customer>Transactions. When the customer checks out the balance is naturally $0, however, the Order goes into "Missing" under Sales>Orders (Filter) and if not checked, the order doesn't show up and no one would know. I have seen quite a number of topics addressing this issue about PayPal and Authorize.net but it seems as if they weren't resolved. A couple of settings I've checked and my order complete status is actually set to "complete" under System>Settings>Storename.
Any assistance will be greatly appreciated. Thank you in advance for your time.
Regards,
Sean
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
This will mean a human won’t miss them either

admin/sale/model/order.php
change
Code: Select all
$sql .= " WHERE o.order_status_id > '0'";
Code: Select all
$sql .= "";
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Thank you for your response, I will try this and let you know if it works.
I am not sure if I understand what the "Human" comment means but that's cool.
by mona wrote: ↑Mon Dec 09, 2019 9:47 amThink of it as "there is an issue and should be looked at by a human”
This will mean a human won’t miss them either
admin/sale/model/order.php
changetoCode: Select all
$sql .= " WHERE o.order_status_id > '0'";
Code: Select all
$sql .= "";
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
I mean a possible ‘fraudulent’ order - produce an order without payingI am not sure if I understand what the "Human" comment means but that's cool.
so a person should check it first ...
DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
Exactly what I needed! You just saved me several hours. Thanks!by mona wrote: ↑Mon Dec 09, 2019 9:47 amThink of it as "there is an issue and should be looked at by a human”
This will mean a human won’t miss them either
admin/sale/model/order.php
changetoCode: Select all
$sql .= " WHERE o.order_status_id > '0'";
Code: Select all
$sql .= "";
ComplexTurkey wrote: ↑Sat Feb 08, 2020 4:44 pmExactly what I needed! You just saved me several hours. Thanks!by mona wrote: ↑Mon Dec 09, 2019 9:47 amThink of it as "there is an issue and should be looked at by a human”
This will mean a human won’t miss them either
admin/sale/model/order.php
changetoCode: Select all
$sql .= " WHERE o.order_status_id > '0'";
Code: Select all
$sql .= "";
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
you are most welcome ..ComplexTurkey wrote: ↑Sat Feb 08, 2020 4:44 pmExactly what I needed! You just saved me several hours. Thanks!


DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.
https://www.youtube.com/watch?v=zXIxDoCRc84
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
change
Code: Select all
$sql .= " WHERE o.order_status_id > '0'";
to
Code: Select all
$sql .= "";
express hr
Users browsing this forum: No registered users and 8 guests