Hello Magento Folks,
In this article, I will help you to learn How To Get Special Price Product Collection In Magento 2. Also, check out our latest post where I have illustrated How to add Custom Tab in Customer Account in Magento 2.
Many times when the store admin sets discounts for their Magento 2 store if you are that person then this article is very helpful for you. Basically, when the special price is configured after that there is difficulty in tracking those products. Sometimes the admin will require this data for analyzing the market and finding the change in the behavior of customers when a special price is offered. When this task is performed manually then there will be a waste of time and it will be a difficult task. There are also chances of mistakes therefore ignore all these tactics and apply the below-given steps to Get Special Price Product Collection In Magento 2.
Step 1: Firstly, Create a routes.xml file at the given below path and add code to it.
app\code\Vendor\Extension\etc\frontend\
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:App/etc/routes.xsd">
<router id="standard">
<route frontName="routesname" id="routesname">
<module name="Vendor_Extension"/>
</route>
</router>
</config> Step 2: Create routesname_product_index.xml file at the given below path and add code to it.
app\code\Vendor\Extension\view\frontend\layout\
<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../lib/internal/Magento/Framework/View/Layout/etc/page_configuration.xsd">
<body>
<referenceContainer name="content">
<block class="Vendor\Extension\Block\Getproductspecialprice" name="custom_tab" template="Vendor_Extension::specialpricedata.phtml" />
</referenceContainer>
</body>
</page> Step 3: Create Index.php file at the given below path and add code to it.
app\code\Vendor\Extension\Controller\product\
<?php
namespace Vendor\Extension\Controller\Customer;
class Index extends \Magento\Framework\App\Action\Action
{
protected $_pageFactory;
public function __construct(
\Magento\Framework\App\Action\Context $context,
\Magento\Framework\View\Result\PageFactory $pageFactory)
{
$this->_pageFactory = $pageFactory;
return parent::__construct($context);
}
public function execute()
{
return $this->_pageFactory->create();
}
} Step 4: Create the Getproductspecialprice.php file at the given below path and add code to it.
app\code\Vendor\Extension\Block\
<?php
namespace Vendor\Extension\Block;
use Magento\Catalog\Api\CategoryRepositoryInterface;
use Magento\Catalog\Block\Product\Context;
use Magento\Framework\Data\Helper\PostHelper;
use Magento\Catalog\Model\Layer\Resolver;
use Magento\Framework\Url\Helper\Data;
use Magento\Catalog\Model\ResourceModel\Product\Collection;
use Magento\Framework\App\ResourceConnection;
class Getproductspecialprice extends \Magento\Catalog\Block\Product\ListProduct
{
protected $_collection;
protected $categoryRepository;
protected $_resource;
public function __construct(Context $context,
PostHelper $postDataHelper,
Resolver $layerResolver,
CategoryRepositoryInterface $categoryRepository,
Data $urlHelper,
Collection $collection,
ResourceConnection $resource,
array $data = []
)
{
$this->categoryRepository = $categoryRepository;
$this->_collection = $collection;
$this->_resource = $resource;
parent::__construct($context, $postDataHelper, $layerResolver, $categoryRepository, $urlHelper, $data);
}
public function getproductcollection()
{
$count = 10;
$category_id = $this->getData("category_id"); // pass your category id
$collection = clone $this->_collection;
$collection->clear()->getSelect()->reset(\Magento\Framework\DB\Select::WHERE)->reset(\Magento\Framework\DB\Select::ORDER)->reset(\Magento\Framework\DB\Select::LIMIT_COUNT)->reset(\Magento\Framework\DB\Select::LIMIT_OFFSET)->reset(\Magento\Framework\DB\Select::GROUP);
if (!$category_id)
{
$category_id = $this->_storeManager->getStore()->getRootCategoryId();
}
$categorycollection = $this->categoryRepository->get($category_id);
$today_date = date('Y-m-d');
if (isset($categorycollection) && $categorycollection)
{
$collection->addMinimalPrice()->addFinalPrice()->addTaxPercents()
->addAttributeToSelect('name')
->addAttributeToSelect('image')
->addAttributeToSelect('small_image')
->addAttributeToSelect('thumbnail')
->addAttributeToSelect('special_from_date')
->addAttributeToSelect('special_to_date')
->addAttributeToFilter('special_price', ['neq' => ''])
->addAttributeToFilter([
[
'attribute' => 'special_from_date',
'lteq' => date('Y-m-d G:i:s', strtotime($today_date)),
'date' => true,
],
[
'attribute' => 'special_to_date',
'gteq' => date('Y-m-d G:i:s', strtotime($today_date)),
'date' => true,
]
])
->addAttributeToFilter('is_saleable', 1, 'left');
}
else
{
$collection->addMinimalPrice()
->addFinalPrice()
->addTaxPercents()
->addAttributeToSelect('name')
->addAttributeToSelect('image')
->addAttributeToSelect('small_image')
->addAttributeToSelect('thumbnail')
->addAttributeToFilter('special_price', ['neq' => ''])
->addAttributeToSelect('special_from_date')
->addAttributeToSelect('special_to_date')
->addAttributeToFilter([
[
'attribute' => 'special_from_date',
'lteq' => date('Y-m-d G:i:s', strtotime($today_date)),
'date' => true,
],
[
'attribute' => 'special_to_date',
'gteq' => date('Y-m-d G:i:s', strtotime($today_date)),
'date' => true,
]
])
->addAttributeToFilter('is_saleable', 1, 'left');
}
$collection->getSelect()->limit($count);
return $collection;
}
} Step 5: Create a specialpricedata.phtml file at the given below path add code to it.
app\code\Vendor\Extension\view\frontend\templates
<?php foreach ($block->getproductcollection() as $product)
{
echo '<pre>';
//print_r($product->getSpecialPrice()); // this code for getSpecialPrice for products
print_r($product->getData()); // this line get all getSpecialPrice products collection
echo '</pre>';
}
Hopefully, all are able to Get Special Price Product Collection In Magento 2 by implementing the above-given steps. If you find any difficulties in following the above steps then connect with me in the comment section below. You can also take the help of our Certified Magento developers to help you in getting a special price product collection in Magento 2.
Share the article with your Magento Store Admin friends.
Happy Reading.
In this guide, we'll explore how to integrate ChatGPT, an AI-powered chatbot, with a Laravel…
In the world of business, understanding financial metrics is crucial for making informed decisions and…
Welcome to the MageComp Monthly Digest, where we bring you the latest updates, releases, and…
In this era, businesses are always on the lookout for ways to engage with their…
Managing a Shopify store efficiently involves keeping your product catalog organized. This includes removing outdated…
E-commerce has transformed the way consumers shop for products and services and interact with businesses.…
View Comments
why show only simple product discount but i want a configurable product so please tell me how to achieve this?
You need to modify the collection itself according to your requirements.