Author Archives: admin

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

Prestashop: How to add the invoice number to the backoffice orders grid

Source: https://www.prestashop.com/forums/topic/300119-solved-how-to-add-the-invoice-number-to-the-orders-grid/?do=findComment&comment=1517949 Try to start with adding another array item to $this->fields_list add code to: /controllers/admin/AdminOrdersController.php ‘invoice_number’ => array( ‘title’ => $this->l(‘Rechnung-Nr: ‘), ‘width’ => 50 ),

Posted in ecommerce | Tagged | Comments Off on Prestashop: How to add the invoice number to the backoffice orders grid

Prestashop: How to create admin controller to add link of module to backoffice menu

Troubleshoot: PrestaShop Admin Module Controller Not Found https://stackoverflow.com/questions/37984270/prestashop-admin-module-controller-not-found Whenever this happened to me was because I hadn’t created a menu entry for my new controller. What I’d advise you to do is to go to Administration > Menus then created … Continue reading

Posted in troubleshoot | Tagged | Comments Off on Prestashop: How to create admin controller to add link of module to backoffice menu

Prestashop: Add style number to product page

Using warehouse theme. When product has combinations, the SKU is shown. I wanted to also show the main product style number for easy reference. https://www.prestashop.com/forums/topic/605088-slovedhow-to-show-reference-numbers-on-product-page/?do=findComment&comment=2540332 {l s=’Style:’} {$product->reference|escape:’html’:’UTF-8′} There are 2 locations to add in ware theme product.tpl

Posted in ecommerce, templates | Tagged | Comments Off on Prestashop: Add style number to product page

Blacklist Check IP

Question – https://www.quora.com/How-exactly-does-a-domain-name-email-get-blacklisted-Whats-the-trigger-or-what-is-responsible-for-it Check: https://www.dnsbl.info/dnsbl-list.php Email needs to have rDNS and FCrDNS, so that it is not blacklisted. What is rDNS? https://spfbl.net/en/rdns/ What is FCrDNS? https://spfbl.net/en/fcrdns/ Remove from blacklist https://www.ndchost.com/wiki/rbl/yahoo https://spfbl.net/en/delist/ Spam check: https://www.spamhaus.org/lookup/ Domain health check: https://mxtoolbox.com/domain/

Posted in servers, troubleshoot | Tagged , | Comments Off on Blacklist Check IP

Prestashop 1.6: Breadcrumb to display the category that product is currently in (not its default category)

Update 20190608: Due to SEO concern, the friendly url of product is configured to not show subcategories, i.e. domain.com/product-name-1234.html so the following solution does not work as it uses the subcategories in the friendly url as reference Source: https://www.prestashop.com/forums/topic/167513-how-to-show-the-full-breadcrumb-to-the-default-category-on-every-product-page/?do=findComment&comment=2684341 Function¬† … Continue reading

Posted in ecommerce | Tagged , | Comments Off on Prestashop 1.6: Breadcrumb to display the category that product is currently in (not its default category)

Prestashop: Fix pagination error on Attributes and Features in Backoffice

https://github.com/PrestaShop/PrestaShop/pull/8638/files https://www.prestashop.com/forums/topic/554037-possible-bug-on-product-attributes-list-pagination-in-1616/ https://www.prestashop.com/forums/topic/507337-backoffice-pagination-error-in-products-attribute-section/ Hi, i fixed this by adding a short code to ‘AdminAttributesGroupsController.php’ in /controllers/admin/ public function setRedirectAfter($url) { $addUrl = ”; if(Tools::isSubmit(‘viewattribute_group’) && Tools::getValue(‘id_attribute_group’)) { $addUrl = ‘&viewattribute_group&id_attribute_group=’ . Tools::getValue(‘id_attribute_group’); } $this->redirect_after = $url . $addUrl; } Function … Continue reading

Posted in troubleshoot | Tagged , | Comments Off on Prestashop: Fix pagination error on Attributes and Features in Backoffice

Prestashop: remove google maps from order page in backoffice

https://www.prestashop.com/forums/topic/336592-remove-google-maps-from-order-page-in-16-slowing-down-crashing-siteserver/ Put the modified file in the override/controllers/admin After that, you need to trigger the regeneration of the /cache/class_index.php file. This is done simply by deleting the file. It is the same when manually removing an override: in order to … Continue reading

Posted in ecommerce | Tagged , , | Comments Off on Prestashop: remove google maps from order page in backoffice