Ttdfjt

when I sort by price product order in Asc or dec. In product listing shows like, First product price is 40, second product price is 50 and the third product price is 40.

If I opened and save those 50 price product in admin backend that product, it's working fine.

All product have customizable options. When I run the following script it's working fine. But this script will delete those customizable options.

<?php

use MagentoFrameworkAppBootstrap;

include 'app/bootstrap.php';

$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();

$state = $objectManager->get('MagentoFrameworkAppState');
$state->setAreaCode('frontend');


$productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollection');

$productCollection->load();

foreach($productCollection as $product)

 $product->save();



echo "saved";

Find any possible way to fix this issue.
advance thanks

Try to load the product options with your collection. The product collection does not load options by default since they are not used in product lists. Maybe that have impact on what you are doing in your code.

$productCollection->addOptionsToResult()->load();

Try this,

<?php 
use MagentoFrameworkAppBootstrap; 
include 'app/bootstrap.php'; 
$bootstrap = Bootstrap::create(BP, $_SERVER); 
$objectManager = $bootstrap->getObjectManager(); 
$state = $objectManager->get('MagentoFrameworkAppState'); 
$state->setAreaCode('frontend'); 
$productCollection = $objectManager->create('MagentoCatalogModelResourceModelProductCollection'); 
$productCollection->addAttributeToSelect('*'); 
$productCollection->addAttributeToSort('price', 'ASC'); 

foreach($productCollection as $product) 
 $product = $objectManager->get('MagentoCatalogModelProductOption')->getProductOptionCollection($product); 
 $product->save(); 
 
 echo "saved";

Hope this helps, peace :)

We are having the sort by price issue on Magento 2.3.0
Ex: A product price 100$ customizable option price starts with 50, B product price 110$ customizable option price starts with 20 and C product price 120$ customizable option price starts with 20.

We are expecting sort by price is product A, product B, and product C but its showings like product B, product C, and product A.

Because results are showing with the lowest customizable option price like product B 130$, product C 140$, and product A 150$.

So we nee the price displays with the lowest customizable option.
Or Sorting needs to show without calculating the customizable option price.