Page 1 of 1

Product option with customer group

Posted: Sun Mar 09, 2014 6:19 am
by firewalls
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:

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

Backend:

Image

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

Re: Product option with customer group

Posted: Tue Mar 11, 2014 11:42 am
by mukur
This module may be what you require https://www.opencart.com/index.php?rout ... _id=225017