Post by dfcarg » Thu Aug 23, 2018 10:36 pm

Hello, in my OpenCart Admin site didn´t couldn´t see all the Orders as some have problems with the orders_id field (OC 2.3.0.2 ), so this is a solution to list all orders on the Orders main page and in the Dashboard if you want to.

Go to “/public_html/admin/model/sale/order.php”...

In line 188... where it says
$sql .= " WHERE o.order_status_id < '110'";

Reeplace it with
$sql .= "";

Thats all, I hope it helps.
Regards.

Newbie

Posts

Joined
Thu Aug 23, 2018 10:28 pm

Post by taskirmaz » Thu Aug 27, 2020 6:21 pm

thanks its helped

Newbie

Posts

Joined
Fri Mar 24, 2017 7:37 pm

Post by ninfotech » Fri Nov 13, 2020 9:57 pm

just see filter option and select missing order and get that orders

Newbie

Posts

Joined
Sat May 25, 2019 8:37 pm

Post by OSWorX » Fri Nov 13, 2020 10:45 pm

Live could be so easy .. Admin Dashboard Missing Orders

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by Naheed » Tue Nov 24, 2020 4:59 pm

For Showing Missing Orders (all orders) on the Orders Main Page,
you can take help with various extensions. Like some of the
extensions are as follows:
Dashboard Missing Orders
Show Missing Orders
Show Missing Orders (all orders)

User avatar
Active Member

Posts

Joined
Mon Aug 10, 2020 11:19 pm

Post by cmsroom » Thu Dec 30, 2021 5:50 pm

dfcarg wrote:
Thu Aug 23, 2018 10:36 pm
Hello, in my OpenCart Admin site didn´t couldn´t see all the Orders as some have problems with the orders_id field (OC 2.3.0.2 ), so this is a solution to list all orders on the Orders main page and in the Dashboard if you want to.

Go to “/public_html/admin/model/sale/order.php”...

In line 188... where it says
$sql .= " WHERE o.order_status_id < '110'";

Reeplace it with
$sql .= "";

Thats all, I hope it helps.
Regards.
You can use https://www.opencart.com/index.php?rout ... n_id=42060

You may like these extension : - https://www.opencart.com/index.php?rout ... r=cmsrooms


New member

Posts

Joined
Fri Sep 28, 2018 1:37 am

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by cmsroom » Thu Dec 30, 2021 6:33 pm

xxvirusxx wrote:
Thu Dec 30, 2021 6:14 pm
After 3 years?

Free
https://www.opencart.com/index.php?rout ... n_id=36023
It's not matter 3 Or More year may be Some one need that feature and functionality. So it may be helpful for them.
Yes it's free but text is missing (as show in screenshot) and Looking not compatible with latest opencart release. :laugh:

You may like these extension : - https://www.opencart.com/index.php?rout ... r=cmsrooms


New member

Posts

Joined
Fri Sep 28, 2018 1:37 am

Post by xxvirusxx » Thu Dec 30, 2021 7:23 pm

There are not major changes between 3.0.2.0 and 3.0.3.8...just bugs fixed...

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by cmsroom » Thu Dec 30, 2021 8:06 pm

xxvirusxx wrote:
Thu Dec 30, 2021 7:23 pm
There are not major changes between 3.0.2.0 and 3.0.3.8...just bugs fixed...
OK , Thanks For the info.

You may like these extension : - https://www.opencart.com/index.php?rout ... r=cmsrooms


New member

Posts

Joined
Fri Sep 28, 2018 1:37 am

Post by Muhammad Ali Ali » Tue Jan 04, 2022 8:14 pm

There may not be an issue at all. Any order in your database which doesn't yet have a status (Pending, Processing, Complete, etc.) has the status of 'Missing' by default.


Posts

Joined
Wed Dec 08, 2021 7:09 pm
Who is online

Users browsing this forum: No registered users and 292 guests