[SOLVED] Product quantity vs Stock_available

[Ikoshop]

When creating or updating a product, the amount entered in Quantity is not stored in ps_product.quantity in the database but instead in the stock_available.quantity table linked to the id_product

However, when Product::getProducts() is called, it returns products with the prpduct.quantity value rather than the stock_available.quantity value.

This seems kind of useless. Is there an accepted way of either

a) getting the quantity of stock_available with getProducts()

b) using another existing method to return the actual stock

c) enabling something on prestashop so that the ps_product table is automatically synchronised with the stock_available table?

Edited December 19, 2024 by Ikoshop
solved (see edit history)

[Ikoshop]

I found an answer for b)

 

$all_products=Product::getProducts($this->lang, 0, 0, 'id_product', 'ASC', false,true,null);

foreach ($all_products as $prod)
            {

$prod['quantity']= StockAvailable::getQuantityAvailableByProduct($prod['id_product'],null,null);

}

and re-add the items to the array