Completed

Dynamic Pricing System

I need a piece of database software written for either MS Access or PHP/MySQL (explain your choice) that will dynamically generate a resale price for real estate properties as they are added to the database. I need it to filter out which properties are listed at 20% or lower of the average sales price per sqft for that particular subdivision. Please add in some extra time for tweaking this workflow. Here is the workflow as I imagine it at this point:

Download property data into database (MySQL or desktop MS Access file), with current status (A=active,P=pending sale, S=Sold, etc). See attached spreadsheet for data setup (header "S" = current status).

-- Each upload can be assumed that it’s the most recent data, so update data if the ML# matches one already in database. Data that may change: status (“S”), list price.

-- The ML# will be unique

-- Data will be in CSV format

-- Add/update field "last update", date and time each unique record was updated or added

-- Add/update fields “LP-Sqft” and “SP-Sqft” to be calculated on updates

-- A, AC status generates “LP-Sqft” number on new and updated records

-- S status update generates “SP-Sqft” number field for that ML# record and stored

Generate this report on demand: pull up all records where status=A, AC, and where the list price/sqft is <80% of that property's "SUBD" average SP-Sqft

To calculate unique SUBD values:

-- Average SP-Sqft for those within the same SUBD is viewable at the top along with subject property information

-- select usable criteria for SUBD pricing using these fields: MAPSCO page, Zip (within 1 or 2 numbers), then middle 8 characters of SUBD using %LIKE%, and records updated within 9 months. (Note: we may need to modify how this searches depending on results). This is to narrow down records to those that are nearby to the subject record and are in the same subdivision. If the SUBD is less than 8 characters, use the entire field.

-- question: SP-Sqft for each SUBD is updated upon uploading and saved as field in a separate SUBD table, or process these calculations upon demand?

-- Report’s table show last 9 months of records where status=S (or all of them, if less than 9 months of data), showing the SUBD name for visual inspection for each record. Table is sortable by SUBD. Fields for results table: ML#, Address, City, Zip, Property Type, Bd, FB, St, YrBlt, Sqft, SoldPrice, Sold Price/Sqft, Frcslr, Subd.

-- Check off properties to calculate SP-Sqft (select all/none buttons); automatically selects all

-- SP-Sqft average is calculated by adding Sold Price numbers, then dividing by the sum all Sqft numbers of those selected records

Skills: Microsoft Access, PHP, Software Architecture

See more: dynamic pricing system, dynamic pricing software, we-top dynamic, we top dynamic, visual workflow, new pricing, format pricing, dynamic sum, dynamic p, check point software, system dynamic pricing, desktop fb, LP, field inspection, dynamic pricing, can i resale, active filter, update mysql using csv, update mysql csv php, mysql select filter

About the Employer:
( 30 reviews ) Austin, United States

Project ID: #4014297

Awarded to:

VBAWhizz

Hi, I would use Access to do this - please see PMB for further details - thanks.

$400 USD in 10 days
(9 Reviews)
4.8

16 freelancers are bidding on average $479 for this job

buraqtech

Check your PMB for details!!!

$685 USD in 18 days
(97 Reviews)
8.0
rhomeu

MS Access expert here. MS Access program is the best solution for this.

$450 USD in 2 days
(67 Reviews)
7.0
oneclickdevelop

Hello, Good to see project from you again :) do let me know if you have any comment and i am ready to start. Thanks, Ali

$500 USD in 8 days
(110 Reviews)
6.7
mkinternation

Hey there, I have over 6 years of experience in PHP/MySQL. Please check my PM for details.

$500 USD in 1 day
(83 Reviews)
6.2
jhaynes75

Professional software developer with over 12 years experience. Please see PM.

$475 USD in 14 days
(30 Reviews)
6.0
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Regards

$400 USD in 20 days
(42 Reviews)
6.2
NiceDeveloper

Hi, I'll give you a desktop app plus database with various reports form. Please check your inbox for more details and sample.

$450 USD in 10 days
(24 Reviews)
5.2
Altantsetseg

Hello. I will provide you with bug free professional [login to view URL] consider my private message.

$410 USD in 4 days
(28 Reviews)
5.5
SAP2907

Sir, we are professional freelancers and can do this job using MySQL preferably as backend. We have made several database connected interfaces before. Please contact us for any other info. Can provide you with a quick More

$325 USD in 7 days
(24 Reviews)
5.0
amnmttl

Hello, I have read your requirements carefully and would like to work on this interesting project. Please check PMB for details of the solution i propose. Aman

$400 USD in 10 days
(18 Reviews)
4.6
bistanil98

Need more detail,can we discuss this,for more detail,check PM. we have more than 10 year of experience in web development,so we can handle this project.

$420 USD in 18 days
(37 Reviews)
6.8
Techsmelter

We are technology firm with ample resources to finish this project in time and to ur expectations

$500 USD in 40 days
(0 Reviews)
0.0
pomalley

Thank you for the opportunity to submit my proposal for your project entitled "Dynamic Pricing System" . About Me: I have been an Oracle professional for the past 10 years and an IT professional for the past 20 More

$500 USD in 30 days
(0 Reviews)
0.0
rubenimc

This is possible with Zoho Creator an online equivalent to Ms Access. Ping me if you are interested

$500 USD in 3 days
(0 Reviews)
0.0
FoxproGuy

Hello, I am an MS Access developer for a commercial accounting software firm.

$750 USD in 10 days
(0 Reviews)
0.0