[SOLVED] - Orders Made From Transactions (Store Credit)

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

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 to

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 .= "";

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

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

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!

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!

ComplexTurkey wrote: ↑

Sat Feb 08, 2020 4:44 pm

Exactly what I needed! You just saved me several hours. Thanks!

you are most welcome ..

@ seanstorm

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?

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?