Update Price A,B&C automatically when I change Regular Price

Posted by jfinn659 on May 8, 2008, 12:14 pm

Please log in for more thread options

Hi,

I have 6 stores with Hq and implement Price Levels A, B and C for
different stores. Around 50% of my 20,000 items have different prices
for A,B,c and regular prices.

Is it possible or is there a solution out there whereby if I change
the regular price that Price A, B and C would automatically change
based on previous relationships like this example.

Regular = 1.00, A = 1.10, B = 1.20 etc. Change Regular to 2.00 and A
would auto change to 2.20 and so on.

This would really be a time saver!!

thanks in advance.

Posted by cod on May 9, 2008, 4:41 am

Please log in for more thread options

an auto change is possible only with database, or only with an add-on,
but not with standard rms

cod

Posted by Jason on May 9, 2008, 8:21 am

Please log in for more thread options

You could run this in SO Admin daily or after price changes:

UPDATE Item SET PriceA = Price * 1.1
UPDATE Item SET PriceB = Price * 1.2

I'm not sure how to set a trigger, but this is the SQL.

Maybe a developer would tell us how to make a trigger fire this SQL every
time a price changes.

> Hi,

> I have 6 stores with Hq and implement Price Levels A, B and C for

> different stores. Around 50% of my 20,000 items have different prices

> for A,B,c and regular prices.

> Is it possible or is there a solution out there whereby if I change

> the regular price that Price A, B and C would automatically change

> based on previous relationships like this example.

> Regular = 1.00, A = 1.10, B = 1.20 etc. Change Regular to 2.00 and A

> would auto change to 2.20 and so on.

> This would really be a time saver!!

> thanks in advance.

Posted by Ryan @ RITE on May 9, 2008, 12:25 pm

Please log in for more thread options

What you need is a database trigger. If you would like help figuring out
the specifics please feel free to email me. We have done similar things for
many customers in the past and this is a fast and easy solution to this type
of problem.

--
Thank you,

Ryan Sakry
Program Manager
Retail Information Technology Enterprises (RITE)
rsakry@rite.us
http://www.rite.us
320-230-2282 ext. 4002 (Office)
320-230-1796 (Fax)

> Hi,

> I have 6 stores with Hq and implement Price Levels A, B and C for

> different stores. Around 50% of my 20,000 items have different prices

> for A,B,c and regular prices.

> Is it possible or is there a solution out there whereby if I change

> the regular price that Price A, B and C would automatically change

> based on previous relationships like this example.

> Regular = 1.00, A = 1.10, B = 1.20 etc. Change Regular to 2.00 and A

> would auto change to 2.20 and so on.

> This would really be a time saver!!

> thanks in advance.

Posted by Dan-902 on May 9, 2008, 5:43 pm

Please log in for more thread options

Would be nice to post answer...for ALL to see.
Dan

> What you need is a database trigger. If you would like help figuring out

> the specifics please feel free to email me. We have done similar things

> for many customers in the past and this is a fast and easy solution to

> this type of problem.

> --

> Thank you,

> Ryan Sakry

> Program Manager

> Retail Information Technology Enterprises (RITE)

> rsakry@rite.us

> http://www.rite.us

> 320-230-2282 ext. 4002 (Office)

> 320-230-1796 (Fax)

>> Hi,

>> I have 6 stores with Hq and implement Price Levels A, B and C for

>> different stores. Around 50% of my 20,000 items have different prices

>> for A,B,c and regular prices.

>> Is it possible or is there a solution out there whereby if I change

>> the regular price that Price A, B and C would automatically change

>> based on previous relationships like this example.

>> Regular = 1.00, A = 1.10, B = 1.20 etc. Change Regular to 2.00 and A

>> would auto change to 2.20 and so on.

>> This would really be a time saver!!

>> thanks in advance.