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 forums.ablecommerce.com. Please use your AbleCommerce username and password to Login. Forums Registration.

Notification

Icon
Error

Options
Go to last post Go to first unread
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: 155

Thanks: 14 times
Was thanked: 2 time(s) in 2 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).

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. Forums Registration.

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: 530

Thanks: 2 times
Was thanked: 76 time(s) in 75 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
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: 155

Thanks: 14 times
Was thanked: 2 time(s) in 2 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.
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: 155

Thanks: 14 times
Was thanked: 2 time(s) in 2 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.
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: 530

Thanks: 2 times
Was thanked: 76 time(s) in 75 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!
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: 530

Thanks: 2 times
Was thanked: 76 time(s) in 75 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

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: 155

Thanks: 14 times
Was thanked: 2 time(s) in 2 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

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: 155

Thanks: 14 times
Was thanked: 2 time(s) in 2 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

Users browsing this topic
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.