Hi Basil,

Sure it's possible. You can use the IOrderService to do it. Here's a sample:

var existingOrderStatus = OrderStatus.Get((int)OrderStatusCode.New);
var newOrderStatus = OrderStatus.Get((int)OrderStatusCode.CompletedOrder);
var purchaseOrders = PurchaseOrder.All().Where(x => x.OrderStatus == existingOrderStatus).ToList();

// This guy handles the status change including running any configured pipeline
var orderService = ObjectFactory.Instance.Resolve<IOrderService>(); 

foreach (var order in purchaseOrders)
{
  orderService.ChangeOrderStatus(order, newOrderStatus);
  order.Save();
} 

OK thanks Soren, so i have to build a custom form to do this, no way to update this by running a SQL query?

You can do SQL but you won't get the pipeline executed. If you just need the statuses updated that's fine. By default uCommerce will acquire any outstanding payments for you as part of the process, but you might not need that.

Hi Soren,

Just wondering if you can use the IOrderService in a console app? I'm looking to output a csv of all order lines from orders with a status of new? alternatively does the OrderService require some kind of context? are there any more samples of getting started with the various services/API?

Hi Tom,

Yes you can. :-)

Please take a look at this blog post about using the uCommerce API's in an Application.

You can take a look at the uCommerce documentation site for other samples and articles

Kind regards,

Jesper

Thanks Jesper!

is working on a reply...