[Skip to main content](#vessel-content) # Trigger for Product Quantity for Product Variants ## - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#165858](#165858) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#165858 "-- 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.")* was created by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* -- 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 2 months ago [\#165863](#165863) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#165863 "-- 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. The solution will just be to let the quantity fields of your product variants to empty, and then set a quantity for the main product, so your product variants and your product will share the same quantity. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#165962](#165962) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Replied by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#165962 "-- 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.")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 2 months ago [\#165964](#165964) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#165964 "-- 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.")* 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](https://hikashop.com/support/support/documentation/62-hikashop-developer-documentation.html#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: Code: // 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); } The following user(s) said Thank You: [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#166129](#166129) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Replied by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#166129 "-- 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.")* 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"); but it doesn´t trigger at the time i think i am missing something. everything is installed and the custom field "assoc_id" is implemented and filled with some data. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166130](#166130) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#166130 "-- 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.")* Hi, The onAfterProductUpdate function will be called automatically by Joomla when you change the quantity of a product/variant in the backend interface. There is no need to (and you can't) call the function yourself like you did at the end of your code. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#166359](#166359) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Replied by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#166359 "-- 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.")* 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); > } so i wanted to see if the trigger is working correctly. but there is absolutely no data in the DB. so i think i am missing something in the code. thx for your help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 12 years 2 months ago [\#166362](#166362) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#166362 "-- 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.")* I can see that you put your onAfterProductUpdate function outside of the ProTrigger class. So it's normal that it doesn't work as Joomla won't find it. Also, the class of the plugin needs to respect a certain format, which is not the case in your code. Also, the plugin needs a XML file with the correct information in it. And the plugins needs to be installed and enabled in the plugins manager of Joomla, or the code won't be called. It's really a Joomla plugin, like any other Joomla plugin. I invite you to take a look at the plugins in the folder plugins/hikashop for a reference of how to do it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")** - [![idh-webdesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar33345.jpg)](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Topic Author - [ Offline](/forum/user/33345-idh-webdesign) Less More - Posts: 8 - Thank you received: 0 - - - - 12 years 2 months ago [\#166476](#166476) by [idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile") Replied by *[idh-webdesign](/forum/user/33345-idh-webdesign "View idh-webdesign's Profile")* on topic *[Trigger for Product Quantity for Product Variants](/forum/27-checkout/870063-trigger-for-product-quantity-for-product-variants#166476 "-- 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.")* SOLVED! Thanks for your help. The Plugin is working now correctly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MDA2My10cmlnZ2VyLWZvci1wcm9kdWN0LXF1YW50aXR5LWZvci1wcm9kdWN0LXZhcmlhbnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.401 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)