Archiwa: PrestaShop < DevWL

PrestaShop plugin / widget development – Setting up development environment for PrestaShop with docker.

Before we start to develop a simple module / widget, we need to set up our development environment. For that, we will use docker. You can use docker on Linux, Mac, and Windows (WSL2), hoverer there are small differences in usage and performance between those...

PrestaShop Database

PrestaShop

Understanding PrestaShop. To be able to understand and think in PrestaShop. We first need to get to know the PrestaShop database. A model database is available for version 1.4.7.2 (SQL Schema) [here]. However, for PrestaShop 1.7 The database structure of PrestaShop...

PrestaShop classic theme – Adding custom field to product details page

PrestaShop

Step 1: To add custom field we need to edit product.tpl file under theme templates/catalog/ directory (example: public_html/themes/your_current_theme/templates/catalog/product.tpl) Step 2: Add the title of the tab Product customization {* EX: theme classic: go to line...

Moving live PrestaShop site to local folder for development

PrestaShop

The solution listed bellow is tested for PS 1.7.4.x and up. Feel free to also see the video blow for better understanding of how whings should be done. Moving prestashop site to new domain / localhost step by step Download prestashop files from the live serverExport...

PrestaShop SQL useful Reports

PrestaShop, SQL

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

MSQL, PrestaShop, 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 plugin / widget development – Setting up development environment for PrestaShop with docker.

PrestaShop Database

PrestaShop classic theme – Adding custom field to product details page

Moving live PrestaShop site to local folder for development

PrestaShop SQL useful Reports

Turn off / Disable modules in PrestaShop using SQL

Search posts

Categories

Recent Posts