Retrieve products that belong to a virtual category

[panzois2000]

Hi,
I need to create a mechanism that exports all products along with the category thay belong to. I noticed that for the virtual categories using your module to create conditions the products are not stored in the database but instead are calculated on the fly.

So my question is how can I retrieve all the products that belong to a virtual category using your modules conditions?

Thanks in advance

Best regards

[rbayet]

Hello @panzois2000,

For virtual categories, you can follow the logic applied in the "Category" layered navigation filter in [[\Smile\ElasticsuiteVirtualCategory\Model\Layer\Filter\Category::applyCategoryFilterToCollection ](https://github.com/Smile-SA/elasticsuite/blob/d17070f2107bd0804eca8c1c329d0bd7f5604f7d/src/module-elasticsuite-virtual-category/Model/Layer/Filter/Category.php#L105-L114)](

elasticsuite/src/module-elasticsuite-virtual-category/Model/Layer/Filter/Category.php

Lines 105 to 114 in d17070f

	protected function applyCategoryFilterToCollection(\Magento\Catalog\Api\Data\CategoryInterface $category)
	{
	$query = $this->getFilterQuery();
	if ($query !== null) {
	$this->getLayer()->getProductCollection()->addQueryFilter($query);
	}
	return $this;
	}

)

1. You build the filter query
2. You apply it to your product collection with addQueryFilter

Now, don't follow blindly what's done in \Smile\ElasticsuiteVirtualCategory\Model\Layer\Filter\Category::getFilterQuery because it relies on objects instanciated in the context of viewing a virtual category.
Handling the "virtual root category" of a virtual category is actually done "magically" in \Smile\ElasticsuiteVirtualCategory\Model\Rule so in your export model, you only really need \Smile\ElasticsuiteVirtualCategory\Model\Category\Filter\Provider.

1. pass your category to \Smile\ElasticsuiteVirtualCategory\Model\Category\Filter\Provider::getQueryFilter
2. it will handle on its own if it's a classic category or a virtual category and if so if it has a virtual category root (additional context filter) and so son
3. and will return you a QueryInterface or null

if not null, apply to your product collection (\Smile\ElasticsuiteCatalog\Model\ResourceModel\Product\Fulltext\Collection) with addQueryFilter.
You're now free to count the number of products, set page size and iterate, etc.

Regards,

[panzois2000]

Hi again, I tried your solution.

     $queryFilter = $this->filterProvider->getQueryFilter($category);

     $virtualProductCollection = [];
                
     if ($queryFilter !== null) {
        // $this->fulltextCollectionFactory is Smile\ElasticsuiteCatalog\Model\ResourceModel\Product\Fulltext\CollectionFactory                     
        $virtualProductCollection = $this->fulltextCollectionFactory->create()->addQueryFilter($queryFilter);
                    
        $size = $virtualProductCollection->getSize(); //after this steps I get Exception "No such entity with id = 0"
               
    }

But after any handling of $virtualProductCollection I get Exception "No such entity with id = 0".

My question is that since it is not working with Smile\ElasticsuiteCatalog\Model\ResourceModel\Product\Fulltext\CollectionFactory
where can I apply addQueryFilter($query) to get the right products
or what am I doing wrong in the example i provided?

[panzois2000]

Hello again, kind reminder. Is there a way or a workaraound, I could solve this problem?