where is the sku of prestashop products saved

Question

i am using PrestaShop v1.6.1.4. I want to get sku of any product using custom query. But i am unable to find SKU column in the prestashop database tables. if anyone can please tell me where is the sku of products is saved in the tables i.e which table and column name

Answer 1

Prestashop does not call SKUs as SKU. It is "reference". You can find products table -> reference