logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
Manage orders filter weirdness
Options
Go to last post Go to first unread
Previous Topic Next Topic
judy at Web2Market  
#1 Posted : Tuesday, January 5, 2021 6:14:33 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
AC 9.0.3 site. On manage orders, they select Last Month, all valid orders and cancelled orders are also displayed. I ran the manage order filtering locally so I could get the sql query and it is the following, with values replacing parameters and names and addresses, etc not output.
SELECT TOP (500) this_.OrderId as orderid1_40_0_, this_.OrderNumber as ordernumber2_40_0_,
this_.OrderDate as orderdate3_40_0_
FROM ac_Orders this_ WHERE this_.OrderId in (SELECT this_0_.OrderId as y0_ FROM ac_Orders this_0_ WHERE this_0_.StoreId = 1 AND
this_0_.OrderDate >= '12/01/2020' and this_0_.OrderDate <= '12/31/2020' and this_0_.OrderStatusId in
(1,11,9,3,14,7,4,12,13))
ORDER BY this_.OrderId desc

When I ran that query on the store database, order # 31209 did not show up, which is correct.
It does show on the manage orders page, though.
See attached images.
Any ideas?
2021-01-05_7-06-41.png (18kb) downloaded 1 time(s). 2021-01-05_7-05-29.png (43kb) downloaded 2 time(s).
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
shaharyartiwana25816656  
#2 Posted : Thursday, January 7, 2021 5:37:23 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Please make sure that OrderStatus Cancelled is marked as Invalid in admin OrderStatuses page.
Please visit this page for confirmation site.com/Admin/Store/OrderStatuses.

I suspect it being marked as valid order status and because of this it is appearing in the order search.

Please keep us updated.
Thanks
Back to top
judy at Web2Market  
#3 Posted : Thursday, January 7, 2021 5:54:10 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Thanks, I had checked that- it is marked as invalid and the statusId is not in the list of statusIds in the sql query.
Back to top
judy at Web2Market  
#4 Posted : Monday, January 11, 2021 6:55:49 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
I think I figured out the issue. When I first go to the page, All Valid is selected, so you assume that the orders are filtered then like they were in AC Gold. The cancelled orders show. If I click search, the cancelled orders don't show.
The change pages dropdown has weirdness also. If I search and the orders are filtered to All Valid, but I change to 100 page, the cancelled ones show again. The filter should still apply when changing number of pages.
Back to top
shaharyartiwana25816656  
#5 Posted : Monday, January 11, 2021 7:04:33 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Quote:
If I search and the orders are filtered to All Valid, but I change to 100 page, the cancelled ones show again. The filter should still apply when changing number of pages.


This issue has been fixed and will be available in the next release.

Thanks for your support!
Back to top
shaharyartiwana25816656  
#6 Posted : Tuesday, January 12, 2021 2:31:35 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
To Fix,

1- Search for file \Website\Areas\Admin\Views\Orders\_ListOrders.cshtml
2- Replace the contents of the file attached and save _ListOrders.txt (7kb) downloaded 2 time(s).
3- Open file \Website\Areas\Admin\Controllers\OrdersController.cs
4- Search for the code block
Code:
#region MANAGE ORDER
.
.
.
.
#endregion

5- Download the attached file and ONLY replace the (#region MANAGE ORDER) code block with the code in the file. Manage Orders.txt (21kb) downloaded 2 time(s).

Note: this is recommended that you should first try these changes locally before applying them on a live site.

Edited by user Tuesday, January 12, 2021 7:03:58 PM(UTC)  | Reason: Not specified
Back to top
thanks 1 user thanked shaharyar for this useful post.
judy at Web2Market on 1/12/2021(UTC)
judy at Web2Market  
#7 Posted : Tuesday, January 12, 2021 7:35:04 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Is this a fix you can give code for or is it in source code? The site that reported it is a 9.0.3 site and they are very unhappy with all the bugs in AC9. The other site is a big 9.0.3 site and it will really hinder their operations.
Thanks

Edited by user Tuesday, January 12, 2021 7:36:05 AM(UTC)  | Reason: Not specified
Back to top
judy at Web2Market  
#8 Posted : Tuesday, January 12, 2021 10:58:32 PM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Thank you for this fix. I hadn't noticed your post before my last post.

Edited by user Tuesday, January 12, 2021 10:59:49 PM(UTC)  | Reason: Not specified
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.169 seconds.