Completed

MySQL Job by allanstevens

This project was successfully completed by allhen for $50 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$50 USD
Completed In
3 days
Total Bids
1
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 [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.


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online