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

magento 2 best seller product display based on current category and subcategories

Magento 2 getting best seller based on category wise displaying i have done below for that to implement this functionality it is working fine for me. step 1 create block file in our module folder <?php namespace Pawan\Bestseller\Block; use Magento\Catalog\Api\CategoryRepositoryInterface; class Bestsellercategory extends \Magento\Catalog\Block\Product\ListProduct {     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_collection;     /**      * Product collection model      *      * @var Magento\Catalog\Model\Resource\Product\Collection      */     protected $_productCollection;     /**      * Image helper      *      * @var Magento\Catalog\Helper\Image     ...
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