Latest News: (loading..)
Sign in to follow this  
Followers 0
goutbouyo

Differents products by customer groups

9 posts in this topic

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.

Share this post


Link to post
Share on other sites

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 = ''

Share this post


Link to post
Share on other sites

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....

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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....)

Share this post


Link to post
Share on other sites

I have found the solution.

 

With my B2B version there is : CUSTOMER_GROUPS

In this contribution it's : CUSTOMER_GROUP

Share this post


Link to post
Share on other sites

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;
 }
}

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0