How to make the default combination when out of stock display one of the available combination ?

[rygar]

Hello, I'm trying to figure out how to solve the out of stock combination products when opening the product page.

 

Now when the customer is on the product page and if the default variant-product is out of stock it doesn't change automatically to the available stock which adds some confusion for some customers that this product including the variant products is as well out of stock!

Can anybody help resolving this issue?

 

 

Edited April 24, 2018 by rygar (see edit history)

[DARKF3D3]

Which PS version are you using?

I'm on PS1.6.1.10 and soon I would like to update to PS1.7...  This feature hasn't yet been implemented also on PS1.7?

[rygar]

@Darkf3d3 im using latest 1.7.3 release.. so nope this feature is not implemented as yet

[eukaonly]

Hello, I've found some way to do it (PS 1.6) via php and mysql.

Simple script to change default attribute, for testing change line:

$st = $db->prepare("select *  from ps_product_attribute WHERE quantity=0 and default_on=1");

to:

$st = $db->prepare("select *  from ps_product_attribute WHERE quantity=0 and default_on=1 and id_product=_SOME_ID_");

//connect with mysql
try {
$db = new PDO(_HERE_YOUR_PARAMETERS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (Exception $e) {
	die('ERR database');
}

//get defaults attributes without quantity	
$st = $db->prepare("select *  from ps_product_attribute WHERE quantity=0 and default_on=1");
try { $st->execute(); } catch ( Exception $e ) { die($e); }
$defki = $st->fetchAll(PDO::FETCH_ASSOC);
//for each default attribute without quantity
foreach ($defki as $def) {
	
	//check if product has some attribute with quantity>0
	$st = $db->prepare("select *  from ps_product_attribute WHERE quantity>0 and id_product=:idp LIMIT 1");
	$st->bindValue(':idp',$def['id_product']);
	try { $st->execute(); } catch ( Exception $e ) { die($e); }
	$jest = $st->fetch(PDO::FETCH_ASSOC);
	
	//if there is product with quantity
	if ($jest['id_product_attribute'] > 0) {
		
		//update old default_on to NULL in ps_product_attribute and ps_product_attribute_shop
		$st = $db->prepare("update ps_product_attribute set default_on=NULL where id_product_attribute=:idpa");
		$st->bindValue(':idpa',$def['id_product_attribute']);
		$st = $db->prepare("update ps_product_attribute_shop set default_on=NULL where id_product_attribute=:idpa");
		$st->bindValue(':idpa',$def['id_product_attribute']);
		try { $st->execute(); } catch ( Exception $e ) { die($e); }
		//update default_on to 1 in ps_product_attribute and in ps_product_attribute_shop for attribute with quantity>0
		$st = $db->prepare("update ps_product_attribute set default_on=1 where id_product_attribute=:idpa");
		$st->bindValue(':idpa',$jest['id_product_attribute']);
		$st = $db->prepare("update ps_product_attribute_shop set default_on=1 where id_product_attribute=:idpa");
		$st->bindValue(':idpa',$jest['id_product_attribute']);
		try { $st->execute(); } catch ( Exception $e ) { die($e); }
	}
	
}

 

[tomerg3]

Stay tuned for a free module to handle this automatically, should be released in the next couple of days.

[tomerg3]

This free module has been released, more information at https://www.prestashop.com/forums/topic/1011838-free-module-out-of-stock-combination-change/

 

[kossrlive]

Thanks a lot. Could you please add cron support. ))) 

This issue often firing when importing large catalogs from ERP`s, Accounting softwares, direct DB uploads. 

So it will be very useful for many users i think. 

Products Uploaded, Then Runs Cron-Task. Like at Installation step. Scanning all products. 

 

 

[fredecs]

This module have saved my life! hehehe Thanks man

[tomerg3]

17 hours ago, fredecs said:

This module have saved my life! hehehe Thanks man

You're welcome!

[Guest]

.

Edited July 26, 2021 by Guest (see edit history)

[DARKF3D3]

Do you know if this feature has been implemented on last Prestashop version (1.7.7.2)?