Trigger for Product Quantity for Product Variants

-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3.3.1

Hi,

Can´t even find a Topic about this.
I have a problem with the product quantity so i´m thinking about a trigger or somethin.

Let me explain:
I have a product:
Product_a->Variant 1->Variant 1-a
->Variant 1-b
->Variant 2->Variant 2-a
->Variant 2-b
->Variant 2-c
This product have 2 Options and 2 Variants.
if i klick on edit variant then i see 6 entries with product_code, Product_price....
so the variants are in the database.

but i also have the variants in the shop as a standalone product.

is it possible to make a trigger for having always the same product quantity for the variant and the original product.
I know it is possible with options. but i can´t make it with options cause an option is not the same.

i just cant find the right file in the source that changes the product_quantity in the Database.

Hello,

is it possible to make a trigger for having always the same product quantity for the variant and the original product.

Thx for your reply,

i think you´ve misunderstood.
i dont mean the main product of the variant. i mean a totaly other product.
i have a built a new table in DB where i have the variant ids listed to the original product.

Hi,

To update stock of the product when the variant stock is changed, you can create a plugin based on:
hikashop.com/support/support/documentati...onAfterProductUpdate

This way when one of the stock is updated, you can do a request to update the other stock.
To make it more dynamic, you can use the custom fields to put the related product id, then to update a product you can get it thanks to:

// custom field name is in this example "relatedprod"
if(!empty($element->relatedprod)){
$productClass = hikashop_get('class.product');
$assocProd = $productClass->get($element->relatedprod);
$assocProd->product_quantity = $element->product_quantity;
$productClass->save($assocProd);
}

Wow, thx...thats a big step.

So i have a plugin looking like this:

defined('_JEXEC') or die('Restricted access');

class ProTrigger extends JPlugin {
function plgHikashopName(&$subject, $config){
parent::__construct($subject, $config);
}
function onAfterProductUpdate(&$element) {
if(!empty($element->assoc_id)){
$productClass = hikashop_get('class.product');
$assocProd = $productClass->get($element->assoc_id);
$assocProd->product_quantity = $element->product_quantity;
$productClass->save($assocProd);
}
}
}
onAfterProductUpdate("86");

Okay, i have tried now many different things and start reading the documentary about the Triggers but i cant get them running.

So i´ve made a test code looking like that:

class ProTrigger extends JPlugin {
}
function onAfterProductUpdate(&$element) {
$dbhost = 'HOST';
$dbuser = 'USER';
$dbpass = 'PASS';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('DB');
$SQL = "INSERT INTO jos_test_table (pro_id, art_nr, off, art_nr_ver) VALUES ('999', 'test accomplished', '1', 'test accomplished')";
mysql_query($SQL);
}

SOLVED!

Thanks for your help. The Plugin is working now correctly.