In Progress

MySQL Job by allanstevens

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: MySQL

See more: may 2, custom value calculation, may need change, 2012 retail, mail server login check, custom project may 2012, dealer set, project dealer, custom project may, write project delivered mail, write project custom fields project creation, script live custom, retail project, mail server project, custom price calculation, script dealer, script reset, project calculation, login reset, price calculation script, project time calculation, reset script, custom properties macro write, project online mail orders, setup project custom user interface

About the Employer:
( 100 reviews ) Bellevue, United States

Project ID: #1641540

Awarded to:

allhen

Hired by the Employer

$50 USD in 3 days
(44 Reviews)
5.6