Well the field for "final price" has code final_price
in Magento Eav product table.
First you have to add final price to the collection as below:
$collection = Mage::getResourceModel('catalog/product_collection')->addAttributeToSelect('*');
$collection->addFinalPrice();
Then you can filter the collection by final_price
as below:
$collection->addFieldToFilter('final_price',array('gteq'=>$minprice))
->addFieldToFilter('final_price',array('lteq'=>$maxprice));
From my understanding, seem that you want to custom price on your shop. We should see some useful methods for customizing price.
vendor/magento/module-directory/Model/Currency.php
public function formatPrecision(
$price,
$precision,
$options = [],
$includeContainer = true,
$addBrackets = false
) {
......
}
vendor/magento/module-directory/Model/PriceCurrency.php
public function format(
$amount,
$includeContainer = true,
$precision = self::DEFAULT_PRECISION,
$scope = null,
$currency = null
) {
......
}
public function convertAndRound($amount, $scope = null, $currency = null, $precision = self::DEFAULT_PRECISION)
{
......
}
vendor/magento/framework/Locale/Format.php
public function getPriceFormat($localeCode = null, $currencyCode = null)
{
......
}
For sample di.xml:
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
<type name="Magento\Directory\Model\Currency">
<plugin name="modify_around_precision" type="Vendor\YourModule\Model\Directory\Plugin\Precision" />
</type>
<type name="Magento\Directory\Model\PriceCurrency">
<plugin name="modify_around_format" type="Vendor\YourModule\Model\Directory\Plugin\Format" />
<plugin name="modify_around_round" type="Vendor\YourModule\Model\Directory\Plugin\PriceRound" />
</type>
<type name="Magento\Framework\Locale\Format">
<plugin name="modify_around_price_format" type="Vendor\YourModule\Model\Locale\Plugin\ModifyPriceFormat" />
</type>
</config>
Best Answer
Please check using create custom script and add below code :