[HELP] new group of customers. Enable all categories automatically

[josias]

Hello,

I just have created a new group of customers. My problem is: by default all categories for this new group are disabled. How I could enable all the categories for this new group?

 

Thank you!

Edited October 24, 2012 by josias (see edit history)

[Valérie Assetskaya]

Hi,

 

It is necessary to create a record for all categories with this group in category_group table.

 

Best regards

[josias]

Hi,

 

It is necessary to create a record for all categories with this group in category_group table.

 

Best regards

 

Could you be more specific please? I don't know how to do the thing you explain

Thank you

Best regards

[Valérie Assetskaya]

Hi,

 

It is necessary to create a file in PrestaShop root (updCategoryGroup.php), and call it, it can be done even from browser line -myStore.com/updCategoryGroup.php

Then add the following code:

 

<?php

 

require(dirname(__FILE__).'/config/config.inc.php');

 

$new_group = 4; // there is ID of new group

$categories = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('

SELECT DISTINCT c.*

FROM `'._DB_PREFIX_.'category` c

LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = '.(int)Context::getContext()->language->id.')

');

 

foreach($categories as $category){

$categoryObj = new Category($category['id_category'], (int)Context::getContext()->language->id);

$categoryObj->addGroups(array($new_group));

}

 

Best regards.

[jujutte24]

Hi,

 

do it work ?

 

I'd like to apply all groups for all categories....

[maximo88]

Yes, it's perfect. I have take 4 hours to find it. It's reported on github.

 

Thank you Valérie. Thank you so much...

[beke]

Hi,

anyone knows if this script works fine for Prestashop 1.5.6?

 

My installation has over 400 categories/subcategories and it's very hard to do this manually.