change the name of all product in a category

  • Posts: 281
  • Thank you received: 3
8 years 7 months ago #255688

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.4

Hello
I need to add some text to the title and to the product code to all product of a category.
Example Original product is "Name product" the new one willbe "Miki Name product"
So I was thinking to do that by mass action if it is possible, I setted up that but I am not sure about the action to choose.
Can you Help me, and this is the right way to do that?


Thanks
FRank

Attachments:

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

  • Posts: 83995
  • Thank you received: 13605
  • MODERATOR
8 years 6 months ago #255730

Hi,

You can't do that with a mass action as the mass actions system doesn't have any "concatenation" operation.
You would have to run a MySQL query in your phpmyadmin for that.
Something like that:

UPDATE #__hikashop_product as p LEFT JOIN #__hikashop_product_category as c on p.product_id=c.product_id SET p.product_name = concat( 'Miki ', p.product_name) WHERE c.category_id = 20;

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

Time to create page: 0.062 seconds
Powered by Kunena Forum