Mass Action of Product Characteristics Price

  • Posts: 69
  • Thank you received: 5
11 years 7 months ago #138999

-- url of the page with the problem -- : www.evaluehouse.com
-- HikaShop version -- : 2.2.2
-- Joomla version -- : Joomla! 2.5.15
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : Safari and Firefox
-- Error-message(debug-mod must be tuned on) -- : Error_message

We need to update product size pricing. Meaning all products that are 2XL need a price increase. Can you do this in a mass action? it seems that you can mass action the product price but not the characteristics pricing?

EXAMPLE evaluehouse.com/mens-apparel/product/1-hartwell-200-atkinson
When you change a style to 2XL the price needs to be increased.

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

  • Posts: 13201
  • Thank you received: 2322
11 years 7 months ago #139031

Hi,

It's possible to change the price only for one kind of variants.
In the mass actions set a filter on "characteristics", select the desired characteristic and set the desired value.

Then in the action apply an update on the product price.

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

  • Posts: 69
  • Thank you received: 5
11 years 7 months ago #140835

it doesn't seem to be working or doing anything? I was trying to 'MASS ACTION' this product Smoke Grey 4XL to a new price of $99.99

evaluehouse.com/component/hikashop/produ...er-soft-shell-jacket

here is a screen grab of my MASS ACTION:
evaluehouse.com/hikaSupport/massAction.png

It appears to me that the price_value is the Main product price and not the characteristics price?

Attachments:
Last edit: 11 years 7 months ago by mindstorm.

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

  • Posts: 2334
  • Thank you received: 403
11 years 7 months ago #141447

Hi there,

I just gave it a try on our end and it's working perfectly, the price of the variant is updated while the price of the product stay the same. Are you using the last version of Hikashop? If not, try to update. If you have the last version and can't do it, please send us an access to your backend so we can have a look ;)

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

  • Posts: 69
  • Thank you received: 5
11 years 7 months ago #141449

I made sure our cart was updated. Can you send me an email address to send the login?

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

  • Posts: 2334
  • Thank you received: 403
11 years 7 months ago #141452

You can either PM me this information or use our contact form ( www.hikashop.com/support/contact-us.html ) with a reference to this topic and my name.

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

  • Posts: 13201
  • Thank you received: 2322
11 years 6 months ago #142120

Hi,

Thanks for the report, we have corrected on our end.
To correct that thanks to edit the plugin "plg_hikashop_massaction_product" and replace the function "onProcessProductMassFiltercharacteristicColumn()", by:

	function onProcessProductMassFiltercharacteristicColumn(&$elements,&$query,$filter,$num){
		if(empty($filter['type']) || $filter['type']=='all') return;
		if(!isset($this->massaction))$this->massaction = hikashop_get('class.massaction');
		if(count($elements)){
			foreach($elements as $k => $element){
				$filter['type'] = strtolower($filter['type']);
				if(!isset($element->$filter['type'])){
					$in = false;
				}else{
					$in = $this->massaction->checkInElement($element, $filter);
				}
				if(!$in) unset($elements[$k]);
			}
		}else{
			$db = JFactory::getDBO();
			if(!empty($filter['value'])){
				$query->leftjoin['variant'.$num] = hikashop_table('variant').' AS hk_variant'.$num.' ON hk_variant'.$num.'.variant_product_id = hk_product.product_id';
				$query->leftjoin['characteristic'.$num] = hikashop_table('characteristic').' AS hk_characteristic'.$num.' ON hk_characteristic'.$num.'.characteristic_id = hk_variant'.$num.'.variant_characteristic_id';
				$query->leftjoin['characteristic_parent'.$num] = hikashop_table('characteristic').' AS hk_characteristic_parent'.$num.' ON hk_characteristic'.$num.'.characteristic_parent_id = hk_characteristic_parent'.$num.'.characteristic_id';
				//$query->where[] = 'hk_characteristic.characteristic_value'.' '.$filter['operator'].' '.$db->quote($filter['value']).' AND hk_characteristic_parent.characteristic_value = '.$db->quote($filter['type']).'';
				if(!empty($filter['value']) || (empty($filter['value']) && in_array($filter['operator'],array('IS NULL','IS NOT NULL')))){
					$rquery = str_replace($filter['type'],'',$this->massaction->getRequest($filter));
					$query->where[] = 'hk_characteristic'.$num.'.characteristic_value '.$rquery.' AND hk_characteristic_parent'.$num.'.characteristic_value = '.$db->quote($filter['type']).'';
				}
			}
		 }
	}

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

  • Posts: 69
  • Thank you received: 5
11 years 6 months ago #142283

where do I find this:

"plg_hikashop_massaction_product"

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

  • Posts: 13201
  • Thank you received: 2322
11 years 6 months ago #142314

The file to edit is:

plugins\hikashop\massaction_product\massaction_product.php

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

Time to create page: 0.076 seconds
Powered by Kunena Forum