Database Sync / Compare with .CSV files - Web based solution required

Completed Posted Apr 15, 2011 Paid on delivery
Completed Paid on delivery

We have a database that has 1.3 million products. The products table holds all the relevant information about the product. (cost, description, name, status, stock, etc)

We have 100s of suppliers, and each of them have a .csv file daily of their stock QTY, new products, etc

FULL DESC BELOW

## Deliverables

We have a database that has 1.3 million products. The products table holds all the relevant information about the product. (cost, description, name, status, stock, etc)

We have 100s of suppliers, and each of them have a .csv file daily of their stock QTY, new products, etc

We are looking for someone to write up an intelligent web based program that we can upload a CSV file from one of our suppliers (they all have different layouts) and import it into a database table dynamically.

Then it would go to a page that "reads" the info we just put into the database, and displays the raw data (all fields)

Above each field, would be a dropdown that would have our product table structure, where we would manually assign that "Column A of the raw data is the price, Column B = Name, Column C = Stock) Etc so this would be dynamic, and we would set this each time we upload.

Then the next step is once we match up there info structure with our structure it would do an intelligent compare, and show us the following info before it does the physical import/update

1. How many Products will be effected

2. If anything has more than a 20% increase/decrease in price - it will flag it (make % dynamic)

3. How any products need to be deleted (as they are not on new list)

4. How many New products there are (as they are IN the new list)

Once we press "GO"

I will update all matching products

It will remove (set status = 0) to any products that are no longer in our suppliers list

It will add all new products from the raw data, into our database table, and flag it as "new"

And that's it - need this done ASAP

We are looking for someone to design us a web based program that will allow us to take a .csv file and import it

PHP XML

Project ID: #3248060

About the project

16 proposals Remote project Active Apr 18, 2011

Awarded to:

yahya

See private message.

$318.75 USD in 7 days
(76 Reviews)
6.1

16 freelancers are bidding on average $310 for this job

Kartoos

See private message.

$408 USD in 7 days
(90 Reviews)
6.5
matfizvw

See private message.

$382.5 USD in 7 days
(60 Reviews)
6.1
mobiletech1604

See private message.

$510 USD in 7 days
(44 Reviews)
6.1
coderf1

See private message.

$289 USD in 7 days
(69 Reviews)
5.1
ijessop

See private message.

$424.15 USD in 7 days
(8 Reviews)
4.8
xoftwee

See private message.

$293.25 USD in 7 days
(19 Reviews)
4.5
phpwantedsl

See private message.

$408 USD in 7 days
(27 Reviews)
4.5
mechnixlab

See private message.

$272 USD in 7 days
(24 Reviews)
4.5
nexusgoldme

See private message.

$255 USD in 7 days
(7 Reviews)
4.2
sharkus

See private message.

$85 USD in 7 days
(27 Reviews)
3.5
CrazyMen

See private message.

$102 USD in 7 days
(2 Reviews)
2.5
nitkovic

See private message.

$127.5 USD in 7 days
(3 Reviews)
1.2
reemnaji

See private message.

$340 USD in 7 days
(5 Reviews)
1.1
acquimdreamer

See private message.

$255 USD in 7 days
(0 Reviews)
0.0
websoftdevevw

See private message.

$424.15 USD in 7 days
(0 Reviews)
0.0
vw7928002vw

See private message.

$382.5 USD in 7 days
(5 Reviews)
0.0