Updating order's products' price with Mass Action button

-- HikaShop version -- : 4.6.0
-- Joomla version -- : 4.1.5
-- PHP version -- : 7.4

Hi there!

We're using the Hikashop in a specialized way: user's do not see the prices, just afterwards their order is set to confirmed status.
Nowadays prices changing very fast, so it's really usual that we have to modify the prices on product's page - or with import/update.

(Edit) I've succesfully passed till button is shown, I can add status checkers there, but how can I refresh the order_product's values (price plus vat) and after that recalculate the whole order's price (I think I have to use run php and/or run mysql). Some help would be great in adding the correct code.

Also wanted to ask if I can add mass action button not just to listing but also to show order (backend) view?

If there's any other features that can help us in solving this (to not to manually set the products prices and then recalculate the whole order), any advice is welcomed.

Thanks in advance,
Regards,
PePe

nicolas wrote: Hi,

Note that with HikaShop 4.6.0 we've added a "mass action as a button" feature. So you can configure actions in a massaction and make it as a button for the orders listing.
That way, on the orders listing, you can select orders you want to modify automatically, and you can click on that button and the actions of the mass action will run on these orders.
You can even use a PHP action in your mass action with PHP code if you need to check the status of the order, and do some complex update procedure on the order.

Yeah, I've seen that, it's really awesome.

I'll solve somehow the price updating, but for the total order price recalculation I'd like to ask your help, as I'm sure that you have some top notch code lines in hand, how to easily do/trigger that.

Thanks in advance!

Thanks, that information is I was just looking for.
I added a Mass action but some small help would be great if there's no price for a variant (it uses it' parent's price).
Good to know that we use different prices for each user group.

Here's my code:

$application = JFactory::getApplication();
$class = hikashop_get('class.order');
$order = $class->loadFullOrder({order_id}, true, false);
$db = JFactory::getDbo();

if ($order->order_status == 'confirmed') {
$application->enqueueMessage(JText::_('Status is CONFIRMED, no price recalculation was made! '), 'error');
return;}

if ($order->order_status == 'shipped') {
$application->enqueueMessage(JText::_('Status is SHIPPED, no price recalculation was made! '), 'error');
return;}

if ($order->order_status == 'cancelled') {
$application->enqueueMessage(JText::_('Status is CANCELLED, no price recalculation was made! '), 'error');
return;}

if ($order->order_status == 'refunded') {
$application->enqueueMessage(JText::_('Status is REFUNDED, no price recalculation was made! '), 'error');
return;}


/* THAT PART IS NOT WORKING I DO NOT UNDERSTAND WHY - IT'S ONLY NEEDED IF WE CAN NOT CALIBRATE TO USE SQL UPDATE TO WORK WITH PARENT PRODUCT'S PRICE UNDERNEATH - START */
foreach($order->products as $product) {
if ($product->product_type == 'variant') {
$application->enqueueMessage('Order contains variant, no recalculation is made FOR VARIANT!', 'error');}
}
/* END */

$sql = "UPDATE #__hikashop_order_product as op
LEFT JOIN #__hikashop_product as p ON op.product_id = p.product_id
LEFT JOIN #__hikashop_order as o ON op.order_id = ".$order->order_id."
LEFT JOIN #__hikashop_user as u ON o.order_user_id = u.user_id
LEFT JOIN #__user_usergroup_map as ug ON u.user_cms_id = ug.user_id
LEFT JOIN #__hikashop_price as pr ON op.product_id = pr.price_product_id
SET op.order_product_price = pr.price_value, op.order_product_tax = pr.price_value * 0.27
WHERE pr.price_access LIKE CONCAT('%,', ug.group_id , ',%')
AND pr.price_value > 0
AND p.product_type = 'main' ";

/* AND pr.price_value > 0 AND p.product_type = 'main' is only used because I was unable to solve variants' price updating. */

$db->setQuery($sql);
$result = $db->execute();

$order->history = new stdClass();
$order->history->history_notified = 0;
$order->history->history_reason = 'Price recalculation made';
$order->history->history_type = 'modification';


$class->save($order);

Any help would be great to solve somehow to recalculate the variant's prices as well as we're not setting them up in the db now, just their parent's.

Thanks in advance!

PePe

Dear Nicolas,

Just noticed that if I use these lines of code it's calculating the total price correctly. But the VAT amount remains the same.
Is there any way to recalculate the VAT as well so simply?

nicolas wrote: Hi,

In a PHP action, you can use such code:

$class = hikashop_get('class.order');
$order = $class->get({order_id});
$class->save($order);

The save function will call the recalculateFullPrice function of class.order to save the updated total amount.

nicolas wrote: Hi,

Most of the code in the recalculateFullPrice function is precisely to recalculate the total VAT.
The problem is that your code set order_product_price and order_product_tax but not order_product_tax_info which contains the details of the tax information for the product. And recalculateFullPrice bases itself on these details to recalculate the taxes appropriately.

Yeah, I see it and understand, but it's not OK: if I modify the products on backend of an order (for exmaple modify a quantity, the VAT also not recalculated, it had to be done also manually, so it's not the missing of the mass action code as I see)

Please give me some advice, I need some urgent help to solve that, any forumthread, codepart or plugin for sample to understand the methodic how should be this done. (maybe mass action-> run after order modifcation, or a seperate plugin?)

Thanks your patience, help and answer in advance!

Hi
Is this Mass Action usefull for updating more than 170.000 product prices? Is that possible at a server? Or is there a other solution?

I have now tried CSVI import but I have 7 sites with the same products. I am now working for many days to fix the update of 7 x 170.000 prices.