[SOLVED] Error when trying to Mass edit prices

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikashop Business
10 years 4 months ago #131760

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 3.2
-- PHP version -- : 5.3.8
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'hk_product.price_value' in 'field list' SQL=UPDATE udfu2_hikashop_product AS hk_product LEFT JOIN udfu2_hikashop_price AS hk_price ON hk_price.price_product_id = hk_product.product_id SET hk_product.price_value = 33.33 WHERE hk_product.product_id IN (2,5,4,14,16,17,18,19,20,22,23,24,25,27,28,30,31,33,35,36,37,38,39,40,41,43,44,47,48,50,56,58,59,60,61,64,67,68,71,72,75,77,78,79,80,81,82,85,87,89,90,91,92,95,96,98,112)

I am trying to change all prices where current price = £50 to a new value of £33.33 but get the error above.
The Mass Actions settings are:
Trigger - none set as it is a one-off action triggered manually.
Filters: Price columns price_value = 50.00
Actions: price_value = FLOAT 33.33

Am I doing something wrong?

Thanks
Trevor

Last edit: 10 years 4 months ago by trevsmiff.

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
10 years 4 months ago #131800

Hi,

Please replace the file plugins/hikashop/massaction_product/massaction_product.php with the one in the archive enclosed and try again.


File Attachment:

File Name: h3047293.zip
File Size:6 KB

Attachments:
The following user(s) said Thank You: trevsmiff

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

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikashop Business
10 years 4 months ago #131805

Thanks again Nicolas - works a treat.

Trevor

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

Time to create page: 0.062 seconds
Powered by Kunena Forum