Skip to main content

Mass Action of Product Characteristics Price

More
12 years 8 months ago #138999 by mindstorm
Mass Action of Product Characteristics Price was created by mindstorm
-- 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.

More
12 years 8 months ago #139031 by Xavier
Replied by Xavier on topic Mass Action of Product Characteristics Price
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.

More
12 years 8 months ago - 12 years 8 months ago #140835 by mindstorm
Replied by mindstorm on topic Mass Action of Product Characteristics Price
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?
Last edit: 12 years 8 months ago by mindstorm.

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

More
12 years 8 months ago #141447 by Eliot
Replied by Eliot on topic Mass Action of Product Characteristics Price
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.

More
12 years 8 months ago #141449 by mindstorm
Replied by mindstorm on topic Mass Action of Product Characteristics Price
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.

More
12 years 8 months ago #141452 by Eliot
Replied by Eliot on topic Mass Action of Product Characteristics Price
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.

More
12 years 8 months ago #142120 by Xavier
Replied by Xavier on topic Mass Action of Product Characteristics Price
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:
Code:
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.

More
12 years 7 months ago #142283 by mindstorm
Replied by mindstorm on topic Mass Action of Product Characteristics Price
where do I find this:

"plg_hikashop_massaction_product"

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

More
12 years 7 months ago #142314 by Xavier
Replied by Xavier on topic Mass Action of Product Characteristics Price
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.204 seconds
Powered by Kunena Forum