Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the ad-inserter domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/blog.webeats.it/httpdocs/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the cookie-law-info domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/blog.webeats.it/httpdocs/wp-includes/functions.php on line 6114
Prestashop: Modificare prezzi dei prodotti direttamente da database con PhpMyAdmin - Blog WebEats

Prestashop: Modificare prezzi dei prodotti direttamente da database con PhpMyAdmin

Mi è capitato più volte di dover intervenire sulla modifica dei prezzi per l’intero catalogo di prodotti.
Questo metodo è valido sia per PrestaShop 1.5 che PrestaShop 1.6.
L’intervento è molto semplice, ma è necessario mettere le mani direttamente sulle tabelle di PrestaShop tramite il tool PHPMyAdmin.

Una volta aver fatto l’accesso a PHPMyAdmin semplicemente bisognerà lanciare il seguente comando:
Tramite la voce di menù SQL

3-sql-tab

Abbassare i prezzi del 10%
UPDATE ps_product_shop SET price = price / 1.1
UPDATE ps_product SET price = price / 1.1

Aumentare i prezzi del 22%
UPDATE ps_product_shop SET price = price * 1.22
UPDATE ps_product SET price = price * 1.22

Aggiungere 5€ ai prezzi
UPDATE ps_product_shop SET price = price + 5.0
UPDATE ps_product SET price = price + 5.0