En cours

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 [url removed, login to view] (that we originally set) to [url removed, login to view] times * "Cost (Dealer)"

Example: cost $[url removed, login to view], current our price $[url removed, login to view], new revised our price $[url removed, login to view]

RULE #2: should check "Dealers Retail Price (As Reference)" field and if this value is lower than new calculation of Cost (dealer) * [url removed, login to view], then use different value of "Dealers Retail Price (As Reference)" times * [url removed, login to view]

Example: cost $[url removed, login to view], Dealers Retail Price (As Reference) is $[url removed, login to view], set new revised our price to $[url removed, login to view]

RULE #3: if the "Dealers Retail Price (As Reference)" is lower than [url removed, login to view] times * Cost (Dealer) then set new revised our price to [url removed, login to view] * times Cost (Dealer)

Example: cost $[url removed, login to view], Dealers Retail Price (As Reference) is $[url removed, login to view], set new revised our price to $[url removed, login to view]

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

Compétences : MySQL

Voir plus : 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, 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, current script prices, calculation script

Concernant l'employeur :
( 99 commentaires ) Bellevue, United States

N° du projet : #1641540

Décerné à :

allhen

Hired by the Employer

50 $ USD en 3 jours
(44 Commentaires)
5.6