Kryptronic Software Support Forum

Uncletim · 08-05-2013 15:17:37

I have a client that would like to offer a product at a certain price for x amount of weeks and then have the price go up at a certain date.

Is there a way to do that?

webmaster · 08-05-2013 16:56:51

Not automatically, but you could execute SQL like this on the date the price is supposed to go up:

UPDATE ecom_prod SET regprice=regprice*1.10 WHERE pricestatus='R'

UPDATE ecom_prod SET saleprice=saleprice*1.10 WHERE pricestatus='S'

That would increase all prices by 10%.

Uncletim · 08-06-2013 12:19:09

It seems like it would be just as easy to go into the cart and just adjust the price manually.

No big deal.

Thanks Nick.

Kryptronic Software Support Forum

#1 08-05-2013 15:17:37

Is there a way to automatically increase the pricing after a date

#2 08-05-2013 16:56:51

Re: Is there a way to automatically increase the pricing after a date

#3 08-06-2013 12:19:09

Re: Is there a way to automatically increase the pricing after a date

Board footer