PrestaShop SQL useful Reports

Report 1 – Query sum of the products sold each month for each category in PrestaShop. Prestashop tabels: [ps_order_detail], [ps_orders], [ps_product], [ps_order_history] Combine aggregation function such as COCNAT and YEAR and DATE with multiple GROUP BY...

Turn off / Disable modules in PrestaShop using SQL

Reading this article you will learn what are default prestashop module and how to disable non default modules or any module of your choice using simple SQL query. Default modules list installed with PrestaShop 1.7.7.5 SELECT GROUP_CONCAT(name ORDER BY id_module...

PrestaShop 1.7.7.6 – GitHub Project

You can review all the issues and task progress under the fallowing URL: https://github.com/PrestaShop/PrestaShop/projects/16 Product class:https://github.com/PrestaShop/PrestaShop/blob/1.7.7.x/classes/Product.php Import products from an XML to PrestaShop a quick...