Order Status

[MarkR]

Hi All

I need to be able to update the order status on the customer's order history page (legacy) but don't want to have someone updating every order in the admin area of UStore. 

I am able to output an SQL script from our MIS/ERP once an order has been despatched, but I would like this to then update the order status in the uStore Database. I can schedule a task to run a small bat file to process the SQL script, but I'm unsure where the legacy page is actually getting this status from, and therefore what I need to update. Has anyone had any luck in doing this?

Thanks

[couch]

The status of the order that is shown to the customer changes based on the order queue that contains the order in the backoffice.

To automatically move order items between queues, use triggers. 

That way the status is updated for the customer and no manual moving of items between queues is required.

[MarkR]

Hi Couch

Thanks for the rapid reply. 

I do already use triggers to move items straight from order submission to Ready To Deliver (thus producing and copying the print ready file for our digital press queues). However, there will be several days lag from this status update to the order actually despatching. I would like to trigger the update from Ready to Deliver to Delivered once they have actually left. I'm not sure how to use triggers to set this in motion.

Thanks

[couch]

If you have uStore API license, you can have your MIS/ERP move the order in the queues when it is dispatched.

A small integration utility could be created to move the job programatically - even add the consignment number etc by adding the delivery/consignment info from the MIS at the same time.

Today, it would require the use of the older uStore WSAPI, but I'm told that it will be possible with REST API in the next uStore version or two.

[MarkR]

Okay thanks. 

That sounds like a slightly larger project than time permits for now. 

Is it possible to hide the status in the order list shown to the customer in UStore front end. As its legacy it makes it a bit harder to figure out. If it was NG it would be easy.

Cheers

[couch]

Since it is legacy page, you can use simple javascript to hide it:

<script>
if (window.location.href.toLowerCase().indexOf ("order-history") > -1)
{
  setTimeout(function() {
    $('.rgMasterTable td:nth-child(4)').hide();
    $('.rgMasterTable th:nth-child(4)').hide();
  }, 200);
}
</script>

Add javascript like this: https://github.com/xmpie-users/uStore-js/wiki/How-to-add-JavaScript-to-a-storefront

You might need to adjust the 200ms timeout. There has to be a little bit of delay for the legacy code to load.