Product option with customer group

Post Reply

2 posts Page 1 of 1

Product option with customer group

firewalls

Newbie

Posts

Joined

Tue Oct 11, 2011 11:09 pm

Location

Indonesia

Post by firewalls » Sun Mar 09, 2014 6:19 am

Hello! I want to ask about modification product option. I have added customer group into product option and want to show this product option by customer group. For example, i have 2 groups, namely Default & Kaskus. When customer (Default's group) is logged in, options with Kaskus's group not showing the value of the options, but the name is still there. I get this problem when customer is not logged in or not in the group:

Value of option is not showing, but the name is still there.

Backend:

I've changed the following line (catalog/model/product.php):

Code: Select all

$product_option_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '" . (int)$product_id . "' AND pov.product_option_id = '" . (int)$product_option['product_option_id'] . "' AND pov.customer_group_id = '" . (int)$customer_group_id . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY ov.sort_order");

So, how to show product option by customer group?
Sorry for my bad english, hope you guys understand. hehe