[Prestashop] Set the deepest category assigned to the product as the default

To set the deepest category assigned to the product as the default you need to do:

1.  Open your database (for example by phpMyAdmin)
2.  I suggest you create backup of your database for safety (export data and structure)
3. Open SQL tab and perform these queries (change ‘ps_’ to your prefix):
   
   MySQL

   UPDATE `ps_product_shop` SET `id_category_default` = ( SELECT `ps_category`.`id_category` FROM `ps_category` JOIN `ps_category_product` ON (`ps_category_product`.`id_category` = `ps_category`.`id_category`) WHERE `ps_category_product`.`id_product` = `ps_product_shop`.`id_product` ORDER BY `ps_category`.`level_depth` DESC, `ps_category`.`id_parent` DESC LIMIT 1 ); UPDATE `ps_product` SET `id_category_default` = ( SELECT `ps_category`.`id_category` FROM `ps_category` JOIN `ps_category_product` ON (`ps_category_product`.`id_category` = `ps_category`.`id_category`) WHERE `ps_category_product`.`id_product` = `ps_product`.`id_product` ORDER BY `ps_category`.`level_depth` DESC, `ps_category`.`id_parent` DESC LIMIT 1 );

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

   UPDATE `ps_product_shop` SET `id_category_default` = (       SELECT `ps_category`.`id_category`       FROM `ps_category`       JOIN `ps_category_product` ON (`ps_category_product`.`id_category` = `ps_category`.`id_category`)       WHERE `ps_category_product`.`id_product` = `ps_product_shop`.`id_product`       ORDER BY `ps_category`.`level_depth` DESC, `ps_category`.`id_parent` DESC       LIMIT 1   );   UPDATE `ps_product` SET `id_category_default` = (       SELECT `ps_category`.`id_category`       FROM `ps_category`       JOIN `ps_category_product` ON (`ps_category_product`.`id_category` = `ps_category`.`id_category`)       WHERE `ps_category_product`.`id_product` = `ps_product`.`id_product`       ORDER BY `ps_category`.`level_depth` DESC, `ps_category`.`id_parent` DESC       LIMIT 1   );

4.  Done! 🙂

I ask you to review this article

Rating 4.4 Stars from 9 reviews