Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

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

swandown
Member
Registered: 05-02-2008
Posts: 63

Price Adjustment - Percentage

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


shop.nuim.ie -> Europacart
-------------------------------------------------

Offline

 

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Price Adjustment - Percentage

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.


Nick Hendler

Offline

 

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

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1706

Re: Price Adjustment - Percentage

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.


Rob

Offline

 

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

swandown
Member
Registered: 05-02-2008
Posts: 63

Re: Price Adjustment - Percentage

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


shop.nuim.ie -> Europacart
-------------------------------------------------

Offline

 

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Price Adjustment - Percentage

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.


Nick Hendler

Offline

 

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

swandown
Member
Registered: 05-02-2008
Posts: 63

Re: Price Adjustment - Percentage

Thanks Nick


shop.nuim.ie -> Europacart
-------------------------------------------------

Offline

 

Board footer