Questions tagged [product-collection]
Questions related to Magento product collections.
698
questions
3
votes
1
answer
40
views
How to get product collection without special price and tier price?
I'm using Magento v2.4, i want to retrieve a product collection that does not have special price (special price is not active or null) and tier price, currently i load the product collection like this:...
- 98
1
vote
0
answers
14
views
How do I include the stock item with the product collection
In magento-1.9 I would call
$Products = Mage::getResourceModel('catalog/product_collection');
$products->setFlag('require_stock_items', true);
And this would add the StockItem to every product in ...
- 1,716
0
votes
1
answer
17
views
How to get all Products of all Websites/Stores?
I tried getting all products of all websites via the ProductCollection like this:
$stores = $this->storeManager->getStores();
foreach ($stores as $store) {
try {
...
- 17
0
votes
0
answers
22
views
How to get child products from Layer Class Magento 2
14219 is the ID of the parent product. 14217, 14218 are the child product ids, I need to get from the Layer which products visibility is VISIBILITY_NOT_VISIBLE , can anyone help?
Thanks
class Layer ...
- 738
0
votes
0
answers
29
views
How to Filter Product Collection by Child product attribute in magento 2
I have size attribute assigned to child products, now I need to filter product collection by child attribute(size).
- 631
0
votes
0
answers
18
views
Display Out of Stock product only Grouped Product
I have to show Out of Stock child product only in Grouped Product on Product Detail Page. Without using store Configuration setting.
Stores → Configuration → Catalog → Inventory → Stock Options → ...
- 1
0
votes
0
answers
16
views
magento 2.4 product count not correct in layer navigation
Team, I am facing an issue with layer navigation category product count in 2.4 for every subcategory displaying disabled products also but in 2.3 it works fine after the upgrade facing the issue.
For ...
- 653
1
vote
0
answers
23
views
How to add category filter with OR condition in product collection?
I'm using magento v2.4.1 and i have a custom attribute name landmark, and i want to filter a product collection using landmark attribute and category id using OR condition. Currently i'm doing it like ...
- 167
1
vote
1
answer
63
views
How to get product collection along with is saleable attribute in Magento 2?
I'm using magento v2.4.1 and I'm extending \Magento\Catalog\Block\Product\ListProduct in my custom module block to load a custom product collection like this:
protected function _getProductCollection()...
- 167
0
votes
0
answers
19
views
Magento 2 - Get random results with Elasticsuit Catalog Fulltext Product Collection
I am using a Magesuite module to get a product collection, and among other things I want to randomly select a certain number of products, fitting of course some criteria set with filters.
The ...
- 107
0
votes
1
answer
32
views
Magento 2 : Get option name rather option id in product collection
Hi I am using below product collection,but it returns option id of attribute in collection my question is how to get option label rather than option id in collection. Is there any way ?
Because I am ...
- 728
0
votes
1
answer
18
views
Magento 2 Product grid collection filtering on programmatic Qty column values
I am programatically updating the qty column values for configurable products.
Sadly, the grid filter for this column doesn't work with new values.
The underlying catalog product collection joins with ...
0
votes
0
answers
78
views
Magento 2 - Extending cataloginventory_stock_item table
I want to extend the cataloginventory_stock_item with one more column, so that I would be able to show this data in a Catalog Products grid.
I've read that in order to properly extend the core Magento ...
0
votes
0
answers
28
views
Retrieving product collection with all possible data in one call
I'm building a custom API endpoint that produces a product data dataset for a custom front-end application. All works fine, but I want to optimize the code because I still have multiple database ...
- 103
0
votes
2
answers
93
views
Filter product collection for only products that have the image
I need to remove products from the collection that have no image. Even if they have the placeholder image I want them to be invisible.
The module code I use is this
<?php
namespace Smartwave\...
- 386
4
votes
1
answer
232
views
Custom condition for Elastic search collection in Magento 2
I am trying to add the custom condition for the product collection using the below plugin for elastic search.
app/code/Vendor/Module/etc/frontend/di.xml
<type name="Magento\Elasticsearch7\...
- 135
1
vote
1
answer
114
views
How to Get Most Viewed Product Collection in Magento 2?
how to get the most viewed product collection in your Magento 2 store?
I try with multiple codes but unfortunately, I am not getting any solution.
I try to create a MostViewedProducts.php file in the /...
- 406
0
votes
0
answers
127
views
Magento 2.3.2 sort the product collection by attributes
I want to sort the product collection by attributes. I want to apply multiple sorting to the product collection need to sort by NEW, ONSALE, and POSITION
For example when going to any listing page ...
- 5,848
0
votes
1
answer
31
views
Magento2 Add Custom Sort By Option ( Special Price Low - High)
I Want to Add New Sort By Option Like (Special Price From Low To High).
Does any one know how i can do this ?
- 828
0
votes
1
answer
60
views
Magento 2 CategoryFactory exclude current product from collection
I am using an extension auto-selecting related products from the same category. However, I want to exclude the current product from that list which is not really working.
protected $_categoryFactory;
...
0
votes
0
answers
61
views
How to get data from Catalog_product_entity_int Via Product Collection?
I am trying to get the result of this query
select entity_id, value
from catalog_product_entity_int
where attribute_id = 191
AND value = 3;
is it possible to get the results of a query like this ...
- 71
0
votes
1
answer
23
views
Magento2 Product Collection Observer only changes one page at a time
In ListProduct block Magento is using initializeProductCollection() to initialize the collection.
While initializing it dispatches event catalog_block_product_list_collection as follows.
$this->...
1
vote
2
answers
310
views
How do I get all products that are displayed on a page?
I am trying to get all the products which are displayed on the current page. The information is used for tracking cookies on the page.ready call.
It was possible to get the product from the product ...
- 17
0
votes
0
answers
29
views
Joining product collection with 'sales_order_item' giving same products after adding pagesize and current page
I am getting product collection by category id, after getting collection I'm joining it with the sales_order_item to get the best seller products in desc order and using page size and current page ...
- 173
0
votes
0
answers
52
views
Custom Module made Pagination disappear?
My custom module is preventing users from seeing specific products when they are not logged in or logged in but don't have access to see them. For category pages I am listening to the ...
0
votes
1
answer
184
views
How to merge two product collections in Magento2
I need help because I need to combine data from two subjects into one.
I have configurable products. I want to download related and upsell products from "parent" and "child".
In ...
- 3
0
votes
0
answers
21
views
Product collection search issue
I got two issues in one I can't figure out, any help would be precious.
Collection size
Product prices
I'm trying to analyze the result of a search by word and order by price request.
To do such a ...
- 737
0
votes
2
answers
28
views
How to get all products with attribute data in custom created class
I'm pretty new to Magento, and I are trying to create a module for it, but I'm a little stock now because I'm trying to get all products out there are created in the store there are enabled.
I'm ...
0
votes
1
answer
68
views
How to create product name dynamically?
My product names are created by different values, that are stored in several custom modules. In my list.phtml I create the dynamic product names, that's no problem. But as I want, that the product ...
0
votes
0
answers
49
views
Filtering product collection by custom attribute by overriding $layer->getProductCollection();
I created a module and a new block so that I can overwrite \Magento\Catalog\Block\Product\ListProduct.
My catalog consists of configurable products, and I need to filter based on attributes assigned ...
- 193
0
votes
0
answers
75
views
Magento 2.4 : override product collection filter not work in layered navigation
I am using magento 2.4 version.
I wanna user custom filter in product collection so I override getProductCollection() function in \Magento\Catalog\Model\Layer.php but it filters the product but not ...
- 728
0
votes
1
answer
33
views
How to get custom product attribute from productCollection
I use magento 2.4.
I have product collection in catalog view.
There I have loop:
$_productCollection = $block->getLoadedProductCollection();
.
.
.
<?php /** @var $_product \...
- 127
0
votes
1
answer
56
views
Get the average price for product collection
If there's a way in Magento 2 to get the average price for a product collection.
Or should I loop over the collection?
Thanks
- 129
0
votes
1
answer
46
views
Magento 2: After product collection join getting Allowed memory size exhausted error
I am trying to join "catalog_category_product" table custom column to product collection like this,
public function beforeSetCollection(
\Magento\Catalog\Block\Product\ProductList\...
0
votes
2
answers
77
views
How to filter product collection in such way where I can use having and addfiledtofilter with AND condition?
I am having product collection where I am getting one custom product attribute called "keep_disabled" and another column which was added on runtime which is sum of quantities 'sum_qty'.
I ...
- 25
0
votes
0
answers
81
views
How to filter product collection by price after tax in magento 2.3?
I am trying to apply filter product collection by price range:
$productsCollection = $this->_productsCollectionFactory->create();
$collection = $productsCollection->addAttributeToSelect('*');
...
- 3,131
3
votes
2
answers
89
views
Syntax error or access violation: 1064 issue , Magento 2
if news_to_date is empty i get syntax error, how can i check if news_to_date is empty or not? Code below, thanks
\Magento\Framework\Stdlib\DateTime\DateTime $stdlibDateTime,
$currentTime = $this->...
0
votes
1
answer
43
views
Magento 2: addAttributeToFilter not working when filtering by ID
Exception #0 (Magento\Framework\Exception\LocalizedException): The "id" attribute name is invalid. Reset the name and try again.
Here is my code
...
\Magento\Catalog\Model\ResourceModel\...
- 738
0
votes
1
answer
333
views
Product collection override but filter not magento in Magento 2.4
I have override vendor/magento/module-catalog/Model/Layer.php for custom product collection but now the layer navigation and product count is working wrong, I checked for Magento\CatalogSearch\Model\...
- 749
0
votes
1
answer
110
views
Magento 2 : Add custom field in product collection
How to add custom field in product collection? I want to add discount value field in product collection.
When I print product collection, it's output like this :
[0] => Array
(
[...
- 137
1
vote
1
answer
278
views
Magento 2 Remove configurable products from product listing page programatically
I am trying to remove configurable products from product collection, as a result products are being filtered correctly but pagination is not working as expected and showing wrong count.
For example ...
- 560
0
votes
1
answer
37
views
Magento2 Out of Stock Products are not display in category page
i have setup my site on magento 241 and out of stock products are not showing on category page, but it is showing on homepage widget section.
i also set display out of stock product options = yes from ...
- 828
0
votes
1
answer
144
views
Optimize Product Collection Filter
I have a Model in my code that creates a custom product collection based on a user search term. That search term should search products and filter it by sku or name... The issue is that it takes too ...
- 126
0
votes
1
answer
49
views
Magento 2 : Trying to Override ListProduct.php Block File for Custom Product Collection
I am trying to override ListProduct.php Block File Using Preference method But InitialiseProductCollection() being a protected function does not give me result. I need to know how can I override a ...
0
votes
1
answer
36
views
Unique Products in Product Collection Filtered with Category Array in Magento 1.9
I have tried below 3 method but it is not giving correct products as per cateory id array.
First Way
$_productCollection = Mage::getResourceModel('catalog/product_collection')
->...
- 749
2
votes
0
answers
190
views
Magento2 filter products based on location (custom attribute) programmatically
I have a Magento2 Store (v2.4) where I have multiple locations. for (eg. Jaipur, Delhi, Mumbai etc). I have managed locations using custom attribute using multiple dropdown list and assigned it to ...
- 131
1
vote
1
answer
74
views
Adding category filter to loaded product collection?
Magento 2.3.3
This is my code:
$_productCollection = $block->getLoadedProductCollection();
$values = [66];
$conditionType = "in";
$_productCollection->addCategoriesFilter([$...
- 245
0
votes
1
answer
506
views
Magento2: filter product collection by custom attribute
I am using Magento ver. 2.3.6.
I want to filter product collection by custom product attribute and I am using below code:-
di.xml
<?xml version="1.0"?>
<config xmlns:xsi="http:/...
- 1,585
0
votes
2
answers
35
views
How to show related products Magento 2.3.5
I want to show related products on product page only from my custom module.
I am not sure if I can or is it possible to do it.
I am doing a check by if my attribute is enable I will change the outcome ...
- 319
0
votes
1
answer
118
views
Why my Disabled product collection gives empty array in magento 2?
I want to get disabled product id's in my system but it gives me an empty array.
Here is screenshot of my products.When i grab disabled product by using this code
$updatedproids = [];
$...
- 526