goutbouyo Posted March 8, 2005 Share Posted March 8, 2005 Hello, I have installed the contribution B2B whose allow to set differents prices by customers groups. But I would like that all my products are not visible by all the customers. For example: the professional group can see the product "xxx" but the default can't do it. Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 8, 2005 Share Posted March 8, 2005 There is a contribution for exactly that, for B2B: Hide products from groups of customers Quote Link to comment Share on other sites More sharing options...
goutbouyo Posted March 9, 2005 Author Share Posted March 9, 2005 Thank you !!! I have installed this contribution but I have this error : 1054 - Champ 'customers_group_id' inconnu dans field list select customers_group_id from customers where customers_id = '' Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 9, 2005 Share Posted March 9, 2005 Then it sure looks like you didn't install B2B correctly, because your customers having a customer_group_id connected with it is essential for this contribution.... Quote Link to comment Share on other sites More sharing options...
goutbouyo Posted March 9, 2005 Author Share Posted March 9, 2005 Ok but I have this error in the admin part : 1054 - Champ 'customers_group_id' inconnu dans field list select distinct customers_group_id, customers_group_name from customers_groups where customers_group_id != '0' order by customers_group_id Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 9, 2005 Share Posted March 9, 2005 The sql from installing this contribution says in part: DROP TABLE IF EXISTS customers_groups; CREATE TABLE `customers_groups` ( `customers_group_id` int(11) NOT NULL auto_increment, `customers_group_name` varchar(32) NOT NULL default '', `customers_group_discount` decimal(11,2) NOT NULL default '0.00', `color_bar` varchar(8) NOT NULL default '#FFFFFF', `group_payment_unallowed` varchar(255) NOT NULL default 'cc', `group_tax` varchar(5) NOT NULL default 'false', PRIMARY KEY (`customers_group_id`) ) TYPE=MyISAM; The error says that there is no customers_group_id in the table customers_groups and since that is not possible if you ran the install I can only conclude that the contribution is installed incorrectly (or you changed the name of that column into something else....) Quote Link to comment Share on other sites More sharing options...
goutbouyo Posted March 9, 2005 Author Share Posted March 9, 2005 I have found the solution. With my B2B version there is : CUSTOMER_GROUPS In this contribution it's : CUSTOMER_GROUP Quote Link to comment Share on other sites More sharing options...
goutbouyo Posted March 9, 2005 Author Share Posted March 9, 2005 I have another problem in the admin part when I edit the product : Warning: Invalid argument supplied for foreach() in c:\web\easyphp1-8\www\catalog\admin\categories.php on line 558 It's near "Select groups to hide" My code : foreach($hide as $h){ if($h == $customers_groups['customers_groups_id']){ $check_hidden = true; break; }else{ $check_hidden = false; } } Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 9, 2005 Share Posted March 9, 2005 Better put this question in the support thread for TotalB2B. On first sight nothing seems wrong with that piece of PHP code. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.