Magento – Multi Select Product Attribute – Magento2.1.2

magento-2.1.2product-attribute

I have created Multi Select Attribute in my custom module.

UpgradeSchema.php

<?php

namespace Vendor\Module\Setup;

use Magento\Eav\Setup\EavSetupFactory;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\ModuleDataSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface
{
    protected $eavSetupFactory;

    public function __construct(
        EavSetupFactory $eavSetupFactory
    ) {
        $this->eavSetupFactory = $eavSetupFactory;
    }

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
    {
        if (version_compare($context->getVersion(), '1.0.1', '<')) {
            $eavSetup->removeAttribute(\Magento\Catalog\Model\Product::ENTITY,'product_tags');
            $eavSetup->addAttribute(
                \Magento\Catalog\Model\Product::ENTITY,
                'product_tags',/* Custom Attribute Code */
                [
                    'group' => 'Product Details',/* Group name in which you want 
                                                  to display your custom attribute */
                    'type' => 'text',/* Data type in which formate your value save in database*/
                    'backend' => '',
                    'frontend' => '',
                    'label' => 'Your Custom Attribute Label', /* lablel of your attribute*/
                    'input' => 'multiselect',
                    'class' => '',
                    'source' => 'Vendor/Module/Model/Config/Source/Options',
                                    /* Source of your select type custom attribute options*/
                    'global' => \Magento\Eav\Model\Entity\Attribute\ScopedAttributeInterface::SCOPE_GLOBAL,
                                        /*Scope of your attribute */
                    'visible' => false,
                    'required' => trfalseue,
                    'user_defined' => false,
                    'default' => '',
                    'searchable' => false,
                    'filterable' => false,
                    'comparable' => false,
                    'visible_on_front' => false,
                    'used_in_product_listing' => false,
                    'unique' => false
                ]
            );
        }
    }
}

Options.php

<?php         
namespace Vendor\Module\Model\Config\Source;

class Options extends \Magento\Eav\Model\Entity\Attribute\Source\AbstractSource
{      
    public function getAllOptions()
    {
        $this->_options=[ 
            ['label'=>'Select Options', 'value'=>''],
            ['label'=>'Option1', 'value'=>'1']
            ['label'=>'Option2', 'value'=>'2']
            ['label'=>'Option3', 'value'=>'3']
         ];
         return $this->_options;
      }
}

Can anyone please tell me what i am doing wrong here. Any help would be appreciated.

Best Answer

Please try with below UpgradeSchema

<?php

namespace Hhmedia\Tags\Setup;

use Magento\Eav\Setup\EavSetupFactory;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\ModuleDataSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface
{
    protected $eavSetupFactory;

    public function __construct(
        EavSetupFactory $eavSetupFactory
    ) {
        $this->eavSetupFactory = $eavSetupFactory;
    }

    public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
    {
        if (version_compare($context->getVersion(), '1.0.1', '<')) {
            $eavSetup->removeAttribute(\Magento\Catalog\Model\Product::ENTITY,'product_tags');
            $eavSetup->addAttribute(
                \Magento\Catalog\Model\Product::ENTITY,
                'product_tags',/* Custom Attribute Code */
                [
                    'group' => 'Product Details',/* Group name in which you want 
                                                  to display your custom attribute */
                    'type' => 'text',/* Data type in which formate your value save in database*/
                    'backend' => '',
                    'frontend' => '',
                    'label' => 'Your Custom Attribute Label', /* lablel of your attribute*/
                    'input' => 'multiselect',
                    'class' => '',
                    'source' => 'Hhmedia\Tags\Model\Config\Source\Options',
                    'global' => \Magento\Eav\Model\Entity\Attribute\ScopedAttributeInterface::SCOPE_GLOBAL,
                                        /*Scope of your attribute */
                    'visible' => false,
                    'required' => false,
                    'user_defined' => false,
                    'default' => '',
                    'searchable' => false,
                    'filterable' => false,
                    'comparable' => false,
                    'visible_on_front' => false,
                    'used_in_product_listing' => false,
                    'unique' => false
                ]
            );
        }
    }
}

Related Solutions

Magento 2.1 – Add Attribute Programmatically

Change the code in module.xml file to this.

    <?xml version="1.0" encoding="UTF-8"?>
<config  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../lib/internal/Magento/Framework/Module/etc/module.xsd">
    <module name="Vendor_Module"  setup_version="1.0.0">
     <sequence>
            <module name="Magento_Catalog"/>
        </sequence>
    </module>
</config>

Replace your code with this code in InstallData.php.

namespace Vendor\Module\Setup;

use Magento\Catalog\Model\Product;
use Magento\Catalog\Model\Product\Type;
use Magento\Catalog\Model\Resource\Eav\Attribute;
use Magento\Eav\Setup\EavSetupFactory;
use Magento\Framework\Setup\InstallDataInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\ModuleDataSetupInterface;


/**
 * @codeCoverageIgnore
 */
class InstallData implements InstallDataInterface
{
    /**
     * EAV setup factory
     *
     * @var EavSetupFactory
     */
    private $eavSetupFactory;
    /**
     * Init
     *
     * @param EavSetupFactory $eavSetupFactory
     */
    public function __construct(EavSetupFactory $eavSetupFactory)
    {
        $this->eavSetupFactory = $eavSetupFactory;
        /* assign object to class global variable for use in other class methods */
    }

    /**
     * {@inheritdoc}
     * @SuppressWarnings(PHPMD.ExcessiveMethodLength)
     */
    public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
    {
         $setup->startSetup();
        /** @var EavSetup $eavSetup */
        $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);


        /**
         * Add attributes to the eav/attribute
       */
       $eavSetup->addAttribute(
         \Magento\Catalog\Model\Product::ENTITY,
       'sorting_attribute',
       [
       'type' => 'int',
        'backend' => '',
        'frontend' => '',
        'label' => 'Sorting Attribute',
        'input' => 'text',
        'class' => '',
        'source' => '',
        'global' => 1,
        'visible' => true,
        'required' => false,
        'user_defined' => true,
        'default' => 0,
        'searchable' => false,
        'filterable' => false,
        'comparable' => false,
        'visible_on_front' => true,
        'used_in_product_listing' => true,
        'unique' => false,
        'apply_to' => 'simple,configurable,virtual,bundle,downloadable,grouped',
        'group'=> 'General'
       ]
      );






       $setup->endSetup();
    }
}

Magento2 Product Attribute Collection – Filter Product Collection by SKU or Name

The syntax for addAttributeToFilter() that you are using was possible in Magento 1, but in Magento 2 there is only one way to use the method to add multiple filters with OR, namely with a single argument:

$collection->addAttributeToFilter(
      [
       ['attribute' => 'name', 'like' => '%'.$queryName.'%'],
       ['attribute' => 'sku', 'like' => '%'.$queryName.'%']
      ]);

That's why you get this error message: Magento expects an array, where you pass 'name' and 'sku'. And while you can use square brackets to access characters in a string ('name'[0]), a non-numeric index as in 'name'['attribute'] throws an error.

Service contracts

You might wonder, if you can achieve the same using the product repository instead of collections, which is the recommended and more upgrade safe way. Repositories are part of the @api service contract of each module and are treated carefully regarding backwards compatibility, while collections are an implementation detail which will not stay the same in the long run.

If it's possible to achieve what you need with repositories, you should do it (see: When Should We Use a Repository and Factory in Magento 2?))

In this case, it's too complicated and imperformant (as of magento-2.2):

There's Magento\Catalog\Api\CategoryLinkManagementInterface::getAssignedProducts() to retrieve a sorted list of SKUs for a given category id, but it does not accept additional filters
You cannot use the filter argument of Magento\Catalog\Api\ProductRepositoryInterface::getList() for the category, because it is not an attribute, but an external n:m relation.

So it would require two steps:

load all skus for the category with CategoryLinkManagementInterface::getAssignedProducts().
use ProductRepositoryInterface::getList() to get a list of products with filter conditions:
- SKU in (previous result) AND
- (your additional filters)

Best Answer

Related Solutions

Magento 2.1 – Add Attribute Programmatically

Magento2 Product Attribute Collection – Filter Product Collection by SKU or Name

Service contracts

Related Topic