Monthly Archives: May 2019

Prestashop: Searching orders by the products they contain via mysql

Source: https://www.prestashop.com/forums/topic/437518-searching-orders-by-the-products-they-contain/?tab=comments#comment-2033625 SELECT product_id, product_attribute_id, product_name, GROUP_CONCAT(id_order SEPARATOR ‘, ‘) AS orders FROM ps_order_detail group by product_name order by product_id, product_attribute_id Can add where product_id = to the number you want to narrow down the specific product SELECT product_id, product_attribute_id, … Continue reading

Posted in database | Tagged , , | Comments Off on Prestashop: Searching orders by the products they contain via mysql

Prestashop: Warehouse theme mobile menu disable link on category parent

File edits are uploaded on: modules/iqitmegamenu/iqitmegamenu.php override/modules/iqitmegamenu/iqitmegamenu.php themes/warehouse/js/modules/iqitmegamenu/js/mlpushmenu.js 1) modules/iqitmegamenu/iqitmegamenu.php changed private function generateCategoriesMenu($categories, $depth_limit, $depth = 0) to protected function generateCategoriesMenu($categories, $depth_limit, $depth = 0) Overrides do not work on private functions. Could have just edited the whole file … Continue reading

Posted in ecommerce, modules | Tagged , | Comments Off on Prestashop: Warehouse theme mobile menu disable link on category parent

Prestashop: Fix layered navigation block doesn’t keep order position of filters

Solution: https://www.prestashop.com/forums/topic/317265-layered-navigation-block-dont-keep-order-position/?do=findComment&comment=2128180 https://github.com/musicpanda/blocklayered/commit/c53257c6cefcf5551d1f3cd51268fde658c1ad6b?diff=unified Info: It repairs one file: blocklayered_admin.js in the module /modules/blocklayered/blocklayered_admin.js If you’re using other themes look for the corresponding file to make the change e.g. warehouse theme /modules/blocklayered_mod/blocklayered_mod_admin.js look for if (typeof filters !== ‘undefined’) { filters … Continue reading

Posted in troubleshoot | Tagged , , | Comments Off on Prestashop: Fix layered navigation block doesn’t keep order position of filters