Run a SQL query from admin dashboard?

alabtechnosoft

@Saurabh @[deleted] @NikhilJain @Djaniel @danoki is this possible to run a query from the admin dashboard;
since we got too many payment failure order and every time we need to login server and run a query.

DELETE FROM orders WHERE orderstatus_id = 9

Saurabh

Is the payment failed orders on orders table bothering the UI so much that it needs deletion?

Just curious 🤔🤔
If yes,
In the new platform, we will make this hidden globally when a order status becomes payment failed after 10-20 mins of the order creation. (Or immediately after order becomes the status of "payment failed") - need to think over this.

alabtechnosoft

Saurabh It's order page and home page almost 50% orders are getting failed. It's very difficult for us to track the order's in mobile view that's what we manually removed all the payment failed orders.

alabtechnosoft

Any solution on this...?

alabtechnosoft

@Saurabh is that any possible way, since its very difficult for us to manage payment failed orders on a daily basis. so please help me with this.

I just need to run the below query from the admin dashboard that's it! hope you will help me on this.

DELETE FROM orders WHERE orderstatus_id = 9

Saurabh

alabtechnosoft in the new platform, there is an option in settings to hide all the Payment Failed orders from Dashboard and Orders page.

Saurabh

alabtechnosoft
Screenshot from the new platform.

alabtechnosoft

alabtechnosoft do we have any option for current foodomaa to run this query from admin dashboard?

Saurabh

alabtechnosoft when we have already created the setting to turn on/off Failed Orders visibility, there is no point in providing a SQL Query run function for this particular thing.

We could build that as a seperate feature so that user can run any queries. But that's a huge trouble, as we cannot provide any kind of support when database is manipulated in anyway. So we will not be building that anytime soon.