Customizing ProductCart - Search By OrderID skips incomplete orders

Print Page | Close Window

Search By OrderID skips incomplete orders

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=122
Printed Date: 25-June-2024 at 2:17am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Search By OrderID skips incomplete orders

Posted By: dfinster
Subject: Search By OrderID skips incomplete orders
Date Posted: 11-February-2006 at 12:04pm

This may be by design, or an oversight, but it's an issue for my clients - they consider it a bug.

In the "Locate an order" page (invoicing.asp), if you search by Order ID, you cannot pull up incomplete orders, although the result page shows a purple ball legend in the header indicating that incomplete orders would be in the list.

I made the following change to resultsAdvanced.asp beginning at line 52:

===================
else
    tempqryStr=(int(tempqryStr) - scpre)
    ' Change WHERE clause to allow all orders when searching by Order ID.
    ' query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>1 AND idOrder LIKE '%" & _
    query=query & " WHERE orders.idCustomer=customers.idCustomer AND idOrder LIKE '%" & _
    tempqryStr & "%' ORDER BY "& strORD &" "& strSort
end if
====================

Any reason this would cause other issues in the system?

Replies:

Posted By: amgqmp1
Date Posted: 17-February-2006 at 11:59am

I agree and have always considered this a bug as well. When my staff performs a search for an order (by number) they should be presented with a complete listing.

I found the code you posted to be a good method, although, I used a slightly different (see below).

============================

Line 54 of resultsAdvanced.asp:

Changed the line from:

"query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>1 AND idOrder LIKE '%" & _"

Change the line to:

"query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>=0 AND idOrder LIKE '%" & _"

(Remove the quotes before using this code)

So far, it's working well for us...I'd love to hear feedback from anyone else that gives this a try.

Posted By: watercrazed
Date Posted: 19-February-2006 at 2:34am

Works good here I used the version from amgqmp1

-------------
John

http://www.ultimatewatermassage.com - massagers, heat therapy, buckwheat pillows and more