- Store Commander version 2014-03-12
- SC Grids Editor Pro Add-on - version 1.0
We would like to add a column displaying the number of sales for a specific period, here 01/07/2017 to 31/12/2017
We will then be able to:
- use filters in the grids to find the most sold products and eventually delist unsold products
- export quickly the products grid including this field to work on an Excel spreadsheet
What is the field ID?: nb_month_2017
Field name: july17_dec17
Table: enter: special
Refresh combinations: keep 'no'
Type: just displayed
return ',(SELECT SUM(od.product_quantity) AS nb FROM `'._DB_PREFIX_.'order_detail` od INNER JOIN `'._DB_PREFIX_.'orders` o ON (od.id_order = o.id_order) WHERE od.product_id = p.id_product AND o.valid=1 AND o.current_state IN (4,5) AND o.date_add >= ("2017-07-01 00:00:00") AND o.date_add <= ("2017-12-31 00:00:00") LIMIT 1) AS juil17_dec17';
Here we look for valid orders with a status 4 or 5 (refer to PrestaShop > Orders > Status) for the period 01/07/2017 to 31/12/2017.