changes done to get notifications using varchar and to update order status in the table visible