MySQL Job by allanstevens

IN PROGRESS
Project Budget (USD)
$50

Project Description:
Project is to write another DB script that will use the following rules to reset our prices (just need a 1 time use)

Would like to use test server first to verify prices, then will do live once signed off! Will send login credentials in mail

RULE #1: should change all "Our Price" from the calculated 1.35 (that we originally set) to 1.54 times * "Cost (Dealer)"

Example: cost $1.00, current our price $1.35, new revised our price $1.54


RULE #2: should check "Dealers Retail Price (As Reference)" field and if this value is lower than new calculation of Cost (dealer) * 1.54, then use different value of "Dealers Retail Price (As Reference)" times * 0.95

Example: cost $10.00, Dealers Retail Price (As Reference) is $14.00, set new revised our price to $13.30


RULE #3: if the "Dealers Retail Price (As Reference)" is lower than 1.25 times * Cost (Dealer) then set new revised our price to 1.25 * times Cost (Dealer)

Example: cost $10.00, Dealers Retail Price (As Reference) is $12.00, set new revised our price to $12.50


Rule #3 overrides #2, #2 overrides #1, etc.


Skills required:
MySQL
Hire allanstevens
Project offered by:
allanstevens United States
Verified