Skip to main content

Magento 2 add associate Simple Products with custom options to Configurable Product not working

If want to add the simple products with custom options to configurable product.When you want show custom options and simple products for configurable product.

when we save product that time if custom options having of that product while saving time in database catalog_product_entity table required_options will  update as 1 if not having it updating as 0. Based on this field configuration data filtering If take a look in to this file you will get idea public_html\vendor\magento\module-configurable-product\Model\Product\Type\Configurable.php

In this file found below function private function getConfiguredUsedProductCollection
code around line

present code below function line number 1408 to 1411

private function getConfiguredUsedProductCollection(
        \Magento\Catalog\Model\Product $product,
        $skipStockFilter = true
    )

    $collection
                ->addAttributeToSelect($this->getAttributesForCollection($product))
                 ->addFilterByRequiredOptions()
                ->setStoreId($product->getStoreId());
i change like this

 $collection
            ->addAttributeToSelect($this->getAttributesForCollection($product))
             //->addFilterByRequiredOptions()
            ->setStoreId($product->getStoreId());

now you will able to see associated simple products and custom options with config products

Comments

  1. Unisoft Informatics System1 April 2020 at 03:53

    Unisoft Informatics is the Top Magento Development Company who serve their services for every business sector namely healthcare, education sector, real estate website services, mobile app development services, and more. We help you to generate more revenue through the website.

    ReplyDelete
  2. Unisoft Informatics System7 April 2020 at 23:09

    Outsource Laravel Development Company to build an online store with full-fledged features. Unisoft Informatics is the Top Laravel Development Company who provide website design and development services for all business industry no matter how large it is!

    ReplyDelete

Post a Comment

Popular posts from this blog

Magento 2 product collection Filtering multi-select attribute values

  If you have multi-select attribute of product like below If you want filter value for this option Use below syntax to get product data: ->addAttributeToFilter('store_model', array('finset' => $params['store_model'])) finset key is used for multiselect attribute filter. $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $products = $objectManager->get('Magento\Catalog\Model\Product')         ->getCollection()         ->addAttributeToSelect('*')         ->addAttributeToSelect('store_brand')         ->addAttributeToSelect('store_model')         ->addAttributeToSelect('store_year')         ->addAttributeToFilter('store_brand', array('finset' => $params['store_brand']))         ->addAttributeToFilter('store_model', array('finset' => $params['store_model']))         ->ad...
6 comments
Read more

Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous

When trying to filter sales order grid with From and To dates it was redirecting to dashboard.after that again i tried to open sales order grind it is generating reports in reports file it showing. "Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous" means it is finding a another created_at field. because when we adding or joining the other table then it has also a field named as created_at. So below is the  solution for this error. magento that created_at is of the main_table not of my custom table. Find the below code in the sales order grid.php file. $this->addColumn('created_at', array(            'header' => Mage::helper('sales')->__('Purchased On'),             'index' => 'created_at',             'type' => 'datetime',             'width' => '100px',         )); ...
Post a Comment
Read more

What startSetup() and endSetup() methods actually does?

The startSetup() and endSetup() methods are used in setup scripts. They are often at the beginning and the end of an upgrade/install method, like in “upgrade()” method of Magento/Catalog/Setup/UpgradeData.php The question is “do you really need them?” Or does it just “look necessary”? This blog post explores what these functions do and then explains when you do and do not need to use these methods. Let’s see what these methods are doing. First, startSetup(): public function startSetup() {   $this->rawQuery("SET SQL_MODE=''");  $this->rawQuery("SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0");   $this->rawQuery("SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'");   return $this;  } 1. Disable foreign keys check. It may be necessary in some rare cases (for example, in a case of cyclic references between tables), but it’s not needed in common situations. It even may lead to hiding real problems...
Post a Comment
Read more