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:

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

Image aceengin
Image @fihsarhafiz
Image fihsarhafiz@gmail.com


User avatar
Newbie

Posts

Joined
Tue Oct 11, 2011 11:09 pm
Location - Indonesia

Post by mukur » Tue Mar 11, 2014 11:42 am

This module may be what you require https://www.opencart.com/index.php?rout ... _id=225017

Newbie

Posts

Joined
Fri Sep 07, 2012 9:55 am
Who is online

Users browsing this forum: No registered users and 96 guests