Any Easy Method to Schedule Store Timings

KarthikKanumolu

We have more than 400 stores and it is very hard to go to every store and schedule time daily

For Ex: There is a restaurant name Demo Restaurant and opening time for that store is 8:00AM to 10:00PM

If we set it and click on Apply All, it has to apply for every day of the week to that restaurant.

is there any way or other way to make it easier?

[deleted]

KarthikKanumolu Make sure you message me in the morning tomorrow. I think I have a way but we have to test it.

KarthikKanumolu

[deleted] sure

LemuelRodriguez

maybe U could do it with a query, i tried this one and works ok

UPDATE restaurants SET schedule_data = '{"monday":[{"open" :"08:00","close" :"19:00"}],"tuesday":[{"open" :"08:00","close" :"19:00"}],"wednesday":[{"open" :"08:00","close" :"19:00"}],"thursday":[{"open" :"08:00","close" :"19:00"}],"friday":[{"open" :"08:00","close" :"19:00"}],"saturday":[{"open" :"08:00","close" :"15:00"}],"sunday":[{"open" :"00:00","close" :"00:01"}]}' WHERE schedule_data IS NULL

just make sure to change to your desired schedule, you can play according with your scenario

CrazyDev

LemuelRodriguez where to apply this code?

LemuelRodriguez

CrazyDev U have to run it as query into Mysql dashboard - Open cpanel->database ->mysql->query