Page 1 of 1

Lookup order by Order Number

Posted: Thu Mar 12, 2009 9:13 am
by dadkind
Hello All,
We're trying to implement an "Order Lookup" page on our site.

How do I look up an order using the OrderNumber?

The default email that the customer gets uses the order number. But I've not been able to find a way to do an order lookup using the OrderNumber.

Surely, I'm just missing something.

The only catch, is that I am limited to "out of the box" components on this project. (Otherwise, I'm guessing a simple DB query would match/cross the orderNumber to an OrderID).


Thanks,
-tomas

Re: Lookup order by Order Number

Posted: Thu Mar 12, 2009 10:06 am
by mazhar
Just use the LoadForOrderNumber method and it will load the appropriate order.

Re: Lookup order by Order Number

Posted: Thu Mar 12, 2009 10:42 am
by dadkind
mazhar wrote:Just use the LoadForOrderNumber method and it will load the appropriate order.
Is that a new function? It's not in the API docs.

The closest function is "LoadForGoogleOrderNumber()". Is this the same thing?

-tomas

Re: Lookup order by Order Number

Posted: Thu Mar 12, 2009 10:54 am
by mazhar
What is your AbleCommerce version?

Re: Lookup order by Order Number

Posted: Thu Mar 12, 2009 11:34 am
by dadkind
mazhar wrote:What is your AbleCommerce version?
We're on version 7.0.2

(Are the Docs out of date?)

-tomas

Re: Lookup order by Order Number

Posted: Thu Mar 12, 2009 11:48 am
by mazhar
Sorry It was my mistake, it was LoadForGoogleOrderNumber and I misunderstood it. You can load order by order number as below

Code: Select all

OrderCollection orders = OrderDataSource.LoadForCriteria("OrderNumber = " + orderNumber + " AND StoreId = " + Token.Instance.Store.StoreId.ToString());

Re: Lookup order by Order Number

Posted: Fri Mar 13, 2009 10:24 am
by dadkind
Thanks for the snippet!

I'm learning something new on this project every day. ;-)

-tomas
mazhar wrote:Sorry It was my mistake, it was LoadForGoogleOrderNumber and I misunderstood it. You can load order by order number as below

Code: Select all

OrderCollection orders = OrderDataSource.LoadForCriteria("OrderNumber = " + orderNumber + " AND StoreId = " + Token.Instance.Store.StoreId.ToString());