Skip to navigation
To find the hours with the fewer orders in open cart
28.10.25
In opencart, get the average percentage of orders by hours. ```mysql SET @total = (SELECT count(*) from order_history); SELECT HOUR(date_added) AS hour_of_day, (COUNT(*)/@total) *100 AS orders_in_hour FROM order_history GROUP BY HOUR(date_added) ORDER by orders_in_hour; ```
https://www.opencart.com/
Reply
Anonymous
Information Epoch 1762189960
Data dominates.
Home
Notebook
Contact us