make Reference code as required field

[ibrahimovich87]

Hello everyone.

I would like to know how to make the 'Reference code' field as required, and that the value must be unique, cannot be repeated?

And if possible (optional but preferable), warning will be shown if repeated Reference code is detected.

I did tried to search for the solution but I couldn't find any.

Appreciate everyone's feedbacks.

Many thanks!

 

I am using PrestaShop version: 1.7.2.5

Edited May 5, 2018 by selectshop.at
title editted by moderator (see edit history)

[ibrahimovich87]

I've  finded this solution, but on my PS 1.7.2.5 non function

"

To make Product Reference unique open AdminProductsController.php ( /controllers/admin/AdminProductsController.php )

 

Find function checkProduct() , it should be like this

public function checkProduct()

and add this line in starting of checkProduct() function

if( Tools::getValue('id_product') == 0)
	$this->checkUniqueRef(); 

and at the end of file ( before last curly brace ) add following function

public function checkUniqueRef()
{
	$reference = Tools::getValue('reference');
	$sql = 'SELECT id_product FROM `'._DB_PREFIX_.'product` WHERE reference="'.$reference.'" ';
	$res = Db::getInstance()->getValue($sql);
	if($res)
	{
		$this->errors[] = sprintf(Tools::displayError('Product with reference %s is already exists.'), $reference);
	}
}

CAn anyone Help Me?