Mass updating images based on categories

  • Posts: 192
  • Thank you received: 15
  • Hikashop Business
7 years 10 months ago #273231

-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7
-- PHP version -- : 5.6.30
-- Browser(s) name and version -- : Opera47

Hi,
I want to run a mass action that will assign a specific picture based on the category selected. However, I cannot find an entry for images in the Mass Actions interface. Any ideas?

Thanks,
Ian @ Sut

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273236

Hi,

There is no mass action in order to do that.

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

  • Posts: 192
  • Thank you received: 15
  • Hikashop Business
7 years 10 months ago #273277

Thanks,
is there another way (e.g. via mysql) that isn't too hard?

Thanks,
Ian and Stu

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273283

Hi,

Well, you can do it in one MySQL query yes.
Whether it's "hard" is hard to say :)
If you know how to make MySQL update queries with joins then it's not difficult.
stackoverflow.com/questions/15209414/how...join-in-update-query
You have to update the file_path in hikashop_file with a join on the hikashop_product_category table in order to have the condition on category of the products.

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

  • Posts: 192
  • Thank you received: 15
  • Hikashop Business
7 years 10 months ago #273335

Thanks. I'll give it a go. - Ian & Stu

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

Time to create page: 0.061 seconds
Powered by Kunena Forum