Skip to main content

Use Mass Action to remove a single word from name

More
10 years 8 months ago #225727 by cctaco
Use Mass Action to remove a single word from name was created by cctaco
-- 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.

More
10 years 8 months ago #225731 by nicolas
Replied by nicolas on topic Use Mass Action to remove a single word from name
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:
Code:
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.147 seconds
Powered by Kunena Forum