[SOLVED] Geting the stock from external ERP server and save it after ordering

-- HikaShop version -- : 3.4.1
-- Joomla version -- : 3.8.10

Hi,
I'm when i create an order on my shop, i'm getting the REAL stock from another server, from an ERP.
So, let's say that in ERP i have stock 200 for Product A, i add Product A in cart, quantity 1, on checkout page when i press Finish, what trigger can i use to save the remaining stock 199 in hikashop ?
A) onBeforeOrderUpdate(&$order,&$do)
onBeforeProductUpdate(&$element,&$do)? (I think this is triggered only when i add or edit the product, not when stock is updated, right?)
C) onBeforeOrderCreate

And i have to use this function to get each product from the order to change the stock?

function getProductInfo($product_id) {
        $productClass = hikashop_get('class.product');
        $productinfo = $productClass->get($product_id);
        return $productinfo;
    }

Hello,

Note that if you want to update Hikashop product's stock you'll just have to use the "Update the product stock on confirmed status" option through the page "Hikashop->System->Configuration->Main".

If you want to execute special code when order are confirmed then using the "onAfterOrderUpdate(&$order,&$send_email)" trigger will do the job, for more information :
www.hikashop.com/support/documentation/6...l#onAfterOrderUpdate

onAfterOrderUpdate(&$order,&$send_email)
This function will be triggered by HikaShop after an order is updated. You will get in the $order object the information which is updated for the order. The $send_email variable can be set to true/false in case you want to allow/disallow the email notification to the customer.

What is wrong with this function, why the product quantity is not saved?

function onAfterOrderUpdate(&$order,&$send_email){
        foreach ($order->products AS $product){
            $this->setNewStock($product->product_id);
        }
    }

function setNewStock($product_id) {
        $productClass = hikashop_get('class.product');
        $product = $productClass->get(3);
        $product->product_quantity = "10";
        $productClass->save();
    }

Thank you for the replay nicolas,
Using this line $productClass->save($product);
iget this error:
1054 Unknown column 'alias' in 'field list'
And the URL become: /index.php/hikashop-menu-for-products-listing/checkout/confirm/cart_id-24
with this message in page: The requested page can't be found.

Hello,

Before debugging your code, can you use the "Check database" button through the page "Hikashop->System->Configuration" and tes it again ? Thank you.

Best regards,
Mohamed Thelji.

Hi Mohamed, i have Hikashop 3.5.0 now.
I did what you said, and i have the same problem.
This is the code in my plugin:

<?php
defined('_JEXEC') or die;

jimport('joomla.plugin.plugin');

class plgHikashopSeniorerp extends JPlugin {

    public function __construct(&$subject, $config = array()) {
        parent::__construct($subject, $config);
    }

    function onAfterOrderUpdate(&$order,&$send_email){
        dump($order, 'COM - onAfterOrderUpdate: ');
        $send_email = FALSE;
        foreach ($order->products AS $product){
            $this->setNewStock($product->product_id);
        }
    }
    
    function setNewStock($product_id) {
        $productClass = hikashop_get('class.product');
        $product = $productClass->get($product_id);
        $product->product_quantity = "10";
        $productClass->save($product);       
    }
}

All right, let me simplify my requirement.
I want to create a function that get the product with all of his details, change the stock and save the product, how can I do it?
It does not matter how the function will be called.

This should work, but is not working because i don't have access to the product durring the trigger?

function setNewStock($product_id) {
        $productClass = hikashop_get('class.product');
        $product = $productClass->get($product_id);
        $product->product_quantity = "10";
        $productClass->save($product);
    }

Hello,

As we said :

You should perform a lot of check in that trigger to just perform your action when it is really necessary and you should load the order products (or the full order) when it's the right time.

	$orderClass = hikashop_get('class.order');
	$full_order = $orderClass->loadFullOrder($order->order_id,true);

Hi Mohamed, tnx for the replay.

To load an order by ID, it is assumed that the order already exists in the database, right?
What i'm trying to do is to perform a check of stock for all the products from cart before creating the order.
So i thought to perform the check / update, using "onBeforeOrderCreate" and to set the real stock by taking it from my ERP server and saving it to the site's database, doing this before creating the order, i don't need to change something else in HS code, I just let HikaShop follow the course to creating the order or not.

You should perform a lot of check in that trigger to just perform your action when it is really necessary and you should load the order products (or the full order) when it's the right time.

That was it nicolas!
Thank you!