Interface customization PRO

Customize your Store Commander by modifying existing views or create new ones, and most of all integrate your own custom fields!

Targeted at more experienced users with expertise in PHP/MySQL/Javascript, you'll find below some examples of custom fields to adapt to your own fields.

• Code index
• Interface Customization PRO: how does it work?
• Tables used in queries
• Modifying the value entered in a grid - Grid JS onEditCell
• Products Grid: Adding a column displaying a product preset feature (read only)
• Products Grid: Adding a column displaying a product preset feature (editable)
• Products Grid: Adding a column displaying a product custom feature (editable)
• Products Grid: Adding a field from a table outside the products table (editable)
• Products Grid: Adding a field from ps_product table (with yes/no choice)
• Products Grid: Adding a field from ps_product_lang table
• Product Grid: Adding 'Default category'
• Product Grid: Adding 'ID default category'
• Products Grid: Adding a field added to ps_product table by the installation of a 3rd party module
• Products Grid: Added a calculated column "Volume in cubic meters (m³)"
• Products Grid: Adding a column 'nb of combinations'
• Products Grid: Adding a column 'nb of products sales in the last month'
• Products Grid: Adding a column 'nb of products sales in the last month'
• Products Grid: Adding a column 'nb of sales for 2021'
• Products Grid: Adding a column 'nb of sales from dd:mm:yyyy to dd:mm:yyyy'
• Grille Produits : Ajouter une colonne "nombre de commandes depuis 1 mois"
• Grille Produits : Interval de jours depuis la dernière commande
• Products Grid: Allowing html format in description fields
• Products Grid: Adding a Product Display SQL condition: WHERE
• Products Grid: Adding a field from a table outside the products table (editable)
• Products Grid: Modifying colors dynamically
• Products Grid: Adding a field 'Combination yes/no'
• Combinations Grid: Adding a field from ps_product_attribute table
• Combinations Grid: Adding a field from a table outside the products table
• Combinations Grid: Adding field 'disabled'
• Combinations Grid: Adding a column 'nb of sales in the last month'
• Products Grid: Adding a column 'nb of sales from dd:mm:yyyy to dd:mm:yyyy'
• Combinations Grid: Adding a field from a table outside the products table
• Specific Prices (window): Adding a field from a table outside the specific prices table
• Images Grid: Adding a field from image table (editable)
• Images Grid: Adding a field from image_lang table (editable)
• Images Grid: Adding a field from image_shop table (editable)
• Images Grid: Adding a field from a specific table (editable)
• Product Export: Exporting a field from a external table
• Product Export: Exporting a Language field in Product Class
• Product Export: Exporting a Product class field
• Export Produits : exporter les statistiques de ventes sur une année
• Product Export: exporting number of products sold
• Product Export: exporting number of products sold
• Combinations Export: exporting number of combinations sold
• Product Import: Importing a language field in a table
• Product Import: Importing a field in product table
• Product Import: Importing a product combination
• Product Import: Importing a field in a table (insert and update)
• Orders Grid: Adding all products names in one column
• Orders Grid: adding 'Manufacturer' field
• Orders Grid: adding 'Image' field
• Orders Grid: adding 'Ecotax' field
• Orders Grid: adding 'id_transaction' field
• Orders Grid: Adding Default Group
• Orders Grid: adding 'VAT' field
• Customer Interface: ID Groups field
• Customer Interface: Number of validated orders (period)
• Customer Interface: Total amount of validated orders (period)
• Product Import: Importing a field in a table (insert and update)
• Export Products: Add a 'yes/no declination' field