Magento 2 : How to assign related product to main product programatically

            Try below code: 

           $obj = \Magento\Framework\App\ObjectManager::getInstance();    

            /** @var \Magento\Catalog\Model\Product $product */

            $productObject = $obj->get('Magento\Catalog\Model\Product');    

            $product = $productObject->loadByAttribute('sku', 'Test Test');    

            $linkDataAll = [];

            $skuLinks = "0012365,test1233,789456";

            $skuLinks = explode(",",$skuLinks);    

            foreach($skuLinks as $skuLink) {

                //check first that the product exist

                $linkedProduct = $productObject->loadByAttribute("sku",$skuLink);

                if($linkedProduct) {

                    /** @var  \Magento\Catalog\Api\Data\ProductLinkInterface $productLinks */

                    $productLinks = $obj->create('Magento\Catalog\Api\Data\ProductLinkInterface');

                    $linkData = $productLinks //Magento\Catalog\Api\Data\ProductLinkInterface

                        ->setSku($product->getSku())

                        ->setLinkedProductSku($skuLink)

                        ->setLinkType("related");

                    $linkDataAll[] = $linkData;

                }

            }

            if($linkDataAll) {

                print(count($linkDataAll)); //gives 3

                $product->setProductLinks($linkDataAll);

            }

            $product->save();

dont use **objectmanager** this code just for reference

Continue Reading

Magento 2 MSI Get Product's Inventory Location/Source on frontend

You can use \Magento\InventoryApi\Api\SourceItemRepositoryInterface class with \Magento\Framework\Api\SearchCriteriaBuilder to get source item data by source code and product SKU.

Here are the sample model class

    <?php

    namespace MageExpert\Testing\Model;

    class SourceItemModel

    {

       

        private $searchCriteriaBuilder;

        private $sourceItemRepository;

        public function __construct(

            ...

            \Magento\Framework\Api\SearchCriteriaBuilder $searchCriteriaBuilder,

            \Magento\InventoryApi\Api\SourceItemRepositoryInterface $sourceItemRepository

            ...

        ) {

            $this->searchCriteriaBuilder = $searchCriteriaBuilder;

            $this->sourceRepository = $sourceRepository;

        }

        public function getSourcesItems($souceCode, $sku)

        {

             $searchCriteria = $this->searchCriteriaBuilder

                ->addFilter('source_code', $souceCode)

                ->addFilter('sku', $sku)

                ->create();

            $sourceItemData = $this->sourceItemRepository->getList($searchCriteria);

            return $sourceItemData->getItems();

        }

    }

Now you can use getSourcesItems() function to get all source items by sources code

    $sourceCode = 'your_store_code';

    $sku = 'Product_1'

    $sourceItems = $this->getSourcesItems($sourceCode);

    foreach ($sourceItems as $sourceItem) {

        print_r($sourceItem->getData());

    }

OUTPUT:

    Array

    (

        [source_item_id] => 96

        [source_code] => your_store_code

        [sku] => Product_1

        [quantity] => 100.0000

        [status] => 1

    )

Continue Reading

Magento2 | Error in Indexing after upgrade magento2 version

If error in indexing after upgrade then run below sql query in phpmyadmin

CREATE  SQL SECURITY INVOKER   VIEW `inventory_stock_1`   AS  SELECT  DISTINCT    legacy_stock_status.product_id,   legacy_stock_status.website_id,   legacy_stock_status.stock_id,    legacy_stock_status.qty quantity,   legacy_stock_status.stock_status is_salable,   product.sku    FROM cataloginventory_stock_status` `legacy_stock_status`  INNER JOIN `catalog_product_entity` product    ON legacy_stock_status.product_id = product.entity_id;

and run below commands

* Clear `var/generation`

* Clear `var/cache`

* Enable Magento modules: `php bin/magento module:enable --all`

* Compile DI `php bin/magento setup:di:compile`

Continue Reading

Magento 2.4.0 - Getting Error Could not validate a connection to Elasticsearch. No alive nodes found in your cluster

I have installed Elasticsearch in my Linux. 

Follow below Steps.

Run the below command to Install Elasticsearch In locally. 

Download and install the public signing key :

`wget -qO - https://artifacts.elastic.co/GPG-KEY-elasticsearch | sudo apt-key add -`

Installing from the APT repositoryedit 

You may need to install the apt-transport-https package on Debian before proceeding :

`sudo apt-get install apt-transport-https`

Save the repository definition to /etc/apt/sources.list.d/elastic-7.x.list :

`echo "deb https://artifacts.elastic.co/packages/7.x/apt stable main" | sudo tee /etc/apt/sources.list.d/elastic-7.x.list`

You can install the Elasticsearch Debian package with :

`sudo apt-get update && sudo apt-get install elasticsearch`

Elasticsearch is not started automatically after installation. How to start and stop Elasticsearch depends on whether your system uses SysV `init` or `systemd` (used by newer distributions).

`ps -p 1`

Running Elasticsearch with SysV `init` : Use the `update-rc.d` command to configure Elasticsearch to start automatically when the system boots up : 

`sudo update-rc.d elasticsearch defaults 95 10`

Elasticsearch can be started and stopped using the `service` command :

`sudo -i service elasticsearch start`

`sudo -i service elasticsearch stop`

Configure Apache and Elasticsearch : Set up a proxy (Set up a proxy for Apache 2.4)

Enable mod_proxy as follows :

`a2enmod proxy_http` or `sudo a2enmod proxy_http`

Use a text editor to open /etc/apache2/sites-available/000-default.conf

Add the following directive at the top of the file :

`Listen 8080`

Add the following at the bottom of the file :

    <VirtualHost *:8080>

        ProxyPass "/" "http://localhost:9200/"

        ProxyPassReverse "/" "http://localhost:9200/"

    </VirtualHost>

Restart Apache :

`service apache2 restart` or `sudo service apache2 restart`

Verify the proxy works by entering the following command :

For example, if your proxy uses port 8080:

`curl -i http://localhost:8080/_cluster/health`

If curl request success then messages display like below : 

    HTTP/1.1 200 OK

    Date: Sun, 23 Aug 2020 06:05:56 GMT

    Server: Apache/2.4.18 (Ubuntu)

    content-type: application/json; charset=UTF-8

    content-length: 389

        {"cluster_name":"elasticsearch","status":"yellow","timed_out":false,"number_of_nodes":1,"number_of_data_nodes":1,"active_primary_shards":1,"active_shards":1,"relocating_shards":0,"initializing_shards":0,"unassigned_shards":1,"delayed_unassigned_shards":0,"number_of_pending_tasks":0,"number_of_in_flight_fetch":0,"task_max_waiting_in_queue_millis":0,"active_shards_percent_as_number":50.0}

Go to `Admin Panel -> Stores -> Settings -> Configuration -> Catalog -> Catalog Search`. Change the settings like below. 

`Search Engine : Search Engine7`

`Elasticsearch Server Hostname : localhost`

`Elasticsearch Server Port : 8080`

`Elasticsearch Index Prefix : magento2`

`Enable Elasticsearch HTTP Auth : No`

`Elasticsearch Server Timeout : 15`

Now save the configuration & run below cache clean command. 

`php bin/magento cache:clean`

Now click on `Test Connection` button.

After successful you will receive `Successful! Test again?` in `Test Connection` button. 

Ref : <a href="https://devdocs.magento.com/guides/v2.4/install-gde/prereq/es-config-apache.html">Dev Docs</a> & <a href="https://www.elastic.co/guide/en/elasticsearch/reference/current/deb.html">Elasticsearch</a>

Continue Reading