Post by nightwing » Mon Dec 09, 2019 9:09 am

Hello All,

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


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by by mona » Mon Dec 09, 2019 9:47 am

Think 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
change

Code: Select all

$sql .= " WHERE o.order_status_id > '0'";
to

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


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by nightwing » Mon Dec 09, 2019 11:33 pm

Hey Mona,

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 am
Think 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
change

Code: Select all

$sql .= " WHERE o.order_status_id > '0'";
to

Code: Select all

$sql .= "";

Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by by mona » Mon Dec 09, 2019 11:38 pm

I am not sure if I understand what the "Human" comment means but that's cool.
I mean a possible ‘fraudulent’ order - produce an order without paying
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


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by nightwing » Tue Dec 10, 2019 2:00 am

Ohh I see, ok so once I enable this, I will just have my team verify that the order was indeed made before sending out any item. Mona you are smart.
by mona wrote:
Mon Dec 09, 2019 11:38 pm
I am not sure if I understand what the "Human" comment means but that's cool.
I mean a possible ‘fraudulent’ order - produce an order without paying
so a person should check it first ...

Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by ComplexTurkey » Sat Feb 08, 2020 4:44 pm

by mona wrote:
Mon Dec 09, 2019 9:47 am
Think 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
change

Code: Select all

$sql .= " WHERE o.order_status_id > '0'";
to

Code: Select all

$sql .= "";
Exactly what I needed! You just saved me several hours. Thanks!

Chick fil A Survey


Newbie

Posts

Joined
Wed Feb 05, 2020 7:50 pm

Post by nightwing » Thu Feb 13, 2020 11:22 am

Happy this worked for you!
ComplexTurkey wrote:
Sat Feb 08, 2020 4:44 pm
by mona wrote:
Mon Dec 09, 2019 9:47 am
Think 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
change

Code: Select all

$sql .= " WHERE o.order_status_id > '0'";
to

Code: Select all

$sql .= "";
Exactly what I needed! You just saved me several hours. Thanks!

Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by by mona » Thu Feb 13, 2020 1:11 pm

ComplexTurkey wrote:
Sat Feb 08, 2020 4:44 pm
Exactly what I needed! You just saved me several hours. Thanks!
you are most welcome .. :D

;) @ seanstorm

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


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by nightwing » Tue Jun 09, 2020 6:09 am

I am now missing orders that are entirely based on free checkout. - The above worked for Store Credit. Is there any way to prevent this for Free Checkout - No payment or store credit at all?

Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by nightwing » Tue Jun 09, 2020 11:44 am

Solved: viewtopic.php?f=201&t=192113
nightwing wrote:
Tue Jun 09, 2020 6:09 am
I am now missing orders that are entirely based on free checkout. - The above worked for Store Credit. Is there any way to prevent this for Free Checkout - No payment or store credit at all?

Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing


Active Member

Posts

Joined
Tue Nov 05, 2019 11:08 pm


Post by diesel123 » Wed Dec 30, 2020 1:46 pm

admin/sale/model/order.php
change
Code: Select all

$sql .= " WHERE o.order_status_id > '0'";
to
Code: Select all

$sql .= "";

express hr

Newbie

Posts

Joined
Mon Apr 13, 2020 7:45 pm
Who is online

Users browsing this forum: No registered users and 8 guests