Kryptronic Software Support Forum

swandown · 06-13-2018 09:20:04

Hi,
anyone know is it possible to price adjust by a multiple e.g. 75% . I've tried *0.75 against a product option selection item . . . . but it just comes up as +0.75.

Thanks,
Mark

webmaster · 06-13-2018 12:54:22

Are you asking for an SQL statement to update regular pricing for a product? As in:

UPDATE ecom_prod SET regprice=regprice*1.75 WHERE id='X'

Or for all products:

UPDATE ecom_prod SET regprice=regprice*1.75

SQL statements are executed using System / Database / Raw DB Admin.

zanart · 06-13-2018 13:03:06

I think this refers to having a product option increase the base price by a percentage in the frontend.
If so, the stock version of CCP 8 doesn't allow percentage increases for product options, only fixed prices.

swandown · 06-14-2018 08:07:27

Yes it was a product option driven multiplier that I was looking for. Thanks anyway and thanks for taking the time to respond.
Mark

webmaster · 06-14-2018 08:33:39

You would need custom programming to do this, and it would be pretty complicated. Might just be better to create the option price as 75% of the product price.

swandown · 06-15-2018 06:44:58

Thanks Nick

Kryptronic Software Support Forum

#1 06-13-2018 09:20:04

Price Adjustment - Percentage

#2 06-13-2018 12:54:22

Re: Price Adjustment - Percentage

#3 06-13-2018 13:03:06

Re: Price Adjustment - Percentage

#4 06-14-2018 08:07:27

Re: Price Adjustment - Percentage

#5 06-14-2018 08:33:39

Re: Price Adjustment - Percentage

#6 06-15-2018 06:44:58

Re: Price Adjustment - Percentage

Board footer