Mass action delete extra or some character from product name

-- HikaShop version -- : 4.4.4 Essential
-- Joomla version -- : 3.10.2
-- PHP version -- : 7.4.24

Hi,
i have 900 product witch i would like to delete first 3 character in the name of the products
Example :

• 10-produitun
• 11-produitdeux
• 12-produitdeux

would be possible to delete with mass action only "10-" "11-" "12-" etc... ,
if it's possible how can i do it please
Best regards

Hi,

It's should be possible with an action "Run MySQL query" and the text:

Thank you very much Nicolas

i got an error when i tested
"1305 FUNCTION adp_migrer.REGEX_REPLACE does not exist "

Hi,

The function REGEX_REPLACE was added in MySQL 8.0.4. You must be using an older version of MySQL.
Unfortunately, with old versions of MySQL there is no regex replacement functions so you can't use this.
In that case, you can try instead to use a "run PHP code" action with the code: That will do the same but got through PHP to run the regex before doing the MySQL query from the PHP code.

Thank you Very much Nicolas

hi,
Seems to be an error in the code :
syntax error, unexpected '$db' (T_VARIABLE), expecting ')'
i'm so bad in php

php versions :7.4.25
Joomla : 4.0.4

Hi,

I modified the code in my previous message. Please try with the new version of the code there.

Work like a charm , thanks you very very much Monsieur :woohoo:

PS : i didn't get mail notification sorry for late answer