Post by bizfantasy2015 » Wed Sep 06, 2017 11:31 am

Image
there is no price can be added for a text or text area option of OC 3.x, is this a bug of opencart 3.x?

I am selling custom products, it allows customer to choose to add their name and number onto the product, which will cost extra US$30.00 of the custom fee, I chosed a text option for custom to input their name and number details, but it is not allowed me to add the price, while there is a price adding field for other options (drop down, radio, checkbox..)

is there any way can add a price adding field for the text option?


Posts

Joined
Wed Sep 06, 2017 11:14 am

Post by daniGo » Wed Sep 06, 2017 4:01 pm

No, you can't. The default options doesn't have price or weight value.

Code: Select all

`oc_product_option` (
  `product_option_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `value` text NOT NULL,
  `required` tinyint(1) NOT NULL,
  PRIMARY KEY (`product_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Option values:

Code: Select all

`oc_product_option_value` (
  `product_option_value_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_option_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `option_value_id` int(11) NOT NULL,
  `quantity` int(3) NOT NULL,
  `subtract` tinyint(1) NOT NULL,
 `price` decimal(15,4) NOT NULL,
  `price_prefix` varchar(1) NOT NULL,
  `points` int(8) NOT NULL,
  `points_prefix` varchar(1) NOT NULL,
  `weight` decimal(15,8) NOT NULL,
  `weight_prefix` varchar(1) NOT NULL,
  PRIMARY KEY (`product_option_value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
You must find some extension or change the code and table structure.

http://www.gombac.si


Active Member

Posts

Joined
Wed Mar 20, 2013 4:49 pm
Location - Slovenia
Who is online

Users browsing this forum: No registered users and 26 guests