How to set product reference = product ID?

[ventesites]

hello

 

I am on PS 1.6.9 I would like to have the field "reference" automatically filled with the product ID, I believe I have to add a query in

 

controllers/admin/adminProductsController.php

 

and then move it to override but where and how can i add a query?

 

I come from Zencart where the query was:

 

$sql_data_array = array( 'products_model' => (int)$products_id);
zen_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");

 

but I don't find something similar in PS.....

 

Thanks

 

Pat