Auto creat product reference number when i add new product.

[Prestan0ob]

When we create a new product, the reference number must be entered manually.  Is there a way to auto generate a code for this field base on a specific format or product ID?
I found the solution for prestashop 1.7 down in this topic and im looking for the same on prestashop 1.6.

 

 

Edited June 4, 2020 by Prestan0ob (see edit history)

[Prestan0ob]

i manage to do that by running script with SQL query

<?php
require_once('./config/config.inc.php');
$sql = 'UPDATE '._DB_PREFIX_.'product SET reference = CONCAT (id_product) where reference = "" OR reference IS NULL';
if (!Db::getInstance()->execute($sql))
    die('error!');

I'm still looking for bettter sollution by customize prestashop files.