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());