Use Mass Action to remove a single word from name

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
9 years 7 months ago #225727

-- HikaShop version -- : latest
-- Joomla version -- : latest

I would like to use mass action to remove a word 'model' from product name.

what is the operation to just remove the one word from the name.

Singer model 989 sewing machine result would be Singer 989 Sewing Machine

here is what I have

nimbus.everhelper.me/client/notes/share/...Lca0DWc8dDOkvKbdRo9/

HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

Please Log in or Create an account to join the conversation.

  • Posts: 84233
  • Thank you received: 13674
  • MODERATOR
9 years 7 months ago #225731

Hi,

You won't be able to do that with a mass action.
You need to run a MySQL query for that in your phpmyadmin:

update #__hikashop_product set
product_name = 
replace(product_name, 'model ','');

Please Log in or Create an account to join the conversation.

Time to create page: 0.049 seconds
Powered by Kunena Forum