WebsiteBaker Support (2.8.x) > Bakery Shop

Order Stats for Backery

(1/1)

workflor:
Hi,

i yust thought about a little problem. i need a small order stat, that means, i need a list of all products and the numbers of orders. i need a count for a year and for a month (i want so select). i think a simple PHP-Script for CODe-Page is a soulition.

greetz

workflor:
ok ... the statement for php

$sql = 'SELECT sku , SUM( quantity ) , order_date FROM wb_altadel_mod_bake ry_order WHERE EXTRACT( MONTH FROM order_date ) = $month AND EXTRACT( YEAR FROM order_date ) = $year GROUP BY sku LIMIT 0, 30 ; ';

it is the statement but i dont know the rest for an form ... can someone help?

Navigation

[0] Message Index