Magento – Magento2 How to Check any simple product is a child of grouped product

grouped-productslist-viewmagento2

In a list page of Magento 2, I want to check that @ every product "Is it a child of any grouped product or not?" if yes then I want to change their URL link when I click on add-to-cart it should be redirected to its parent grouped product detail page.

Thank you.

Best Answer

Product relations in Magento is stored in catalog_product_relation table.

So you can check if the particular simple product has any data present in the table to check if it has any parent product.

SELECT * FROM catalog_product_relation WHERE child_id = <product_id>

If it has any parent product you can get the Product ID of parent to check the parent product is grouped and you can get the respective product page URL.

Related Solutions

Magento – Grouped Product can’t add any item to cart if any other item is out of stock

I ended up just manipulating the grouped product template, it seems that the qty fields are all passed as an array, and as the "out of stock" items have no input field or value they throw a validation error.

I just added my own grouped.phtml in /app/design/frontend/<Vendor>/<Theme>/Magento_GroupedProduct/templates/product/view/type and copied the entire phtml file from the Magento core, with just the addition of a hidden field in the out of stock condition:

<div class="stock unavailable" title="<?= /* @escapeNotVerified */ __('Availability') ?>">
    <span><?= /* @escapeNotVerified */ __('Out of stock') ?></span>
    <?php /** added in the qty of 0 as a hidden field */ ?>
    <input type="hidden" name="super_group[<?= /* @escapeNotVerified */ $_item->getId() ?>]" 
            data-selector="super_group[<?= /* @escapeNotVerified */ $_item->getId() ?>]" value="0" 
            title="<?= /* @escapeNotVerified */ __('Qty') ?>"
            class="input-hidden qty"/>
</div>

Hopefully it'll help in some way, I'm sure it'll be fixed in 2.3.0 but this worked for me until then.

Magento 2 – How to Redirect Simple Products to Parent Grouped Product

Here is a workaround did. I created a text attribute and allowed it to be searchable on the front-end. Then I added the SKU's of the associated simple products to that attribute on the grouped product page. I had to type each SKU in manually and separate them by a comma so it is not as efficient.

The result is a user can search for a simple product SKU and the grouped product that the simple product is associated with will show in the search results.

Best Answer

Related Solutions

Magento – Grouped Product can’t add any item to cart if any other item is out of stock

Magento 2 – How to Redirect Simple Products to Parent Grouped Product

Related Topic