Find Jobs
Hire Freelancers

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

$100-500 USD

Færdiggjort
Slået op cirka 13 år siden

$100-500 USD

Betales ved levering
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
Projekt-ID: 3248060

Om projektet

16 forslag
Projekt på afstand
Aktiv 13 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
See private message.
$318,75 USD på 7 dage
5,0 (76 anmeldelser)
6,1
6,1
16 freelancere byder i gennemsnit $310 USD på dette job
Brug Avatar.
See private message.
$408 USD på 7 dage
4,7 (90 anmeldelser)
6,5
6,5
Brug Avatar.
See private message.
$382,50 USD på 7 dage
4,3 (60 anmeldelser)
6,1
6,1
Brug Avatar.
See private message.
$510 USD på 7 dage
4,7 (44 anmeldelser)
6,1
6,1
Brug Avatar.
See private message.
$289 USD på 7 dage
4,8 (69 anmeldelser)
5,1
5,1
Brug Avatar.
See private message.
$424,15 USD på 7 dage
5,0 (8 anmeldelser)
4,8
4,8
Brug Avatar.
See private message.
$293,25 USD på 7 dage
5,0 (19 anmeldelser)
4,5
4,5
Brug Avatar.
See private message.
$408 USD på 7 dage
5,0 (27 anmeldelser)
4,5
4,5
Brug Avatar.
See private message.
$272 USD på 7 dage
4,7 (24 anmeldelser)
4,5
4,5
Brug Avatar.
See private message.
$255 USD på 7 dage
5,0 (7 anmeldelser)
4,2
4,2
Brug Avatar.
See private message.
$85 USD på 7 dage
5,0 (27 anmeldelser)
3,5
3,5
Brug Avatar.
See private message.
$102 USD på 7 dage
5,0 (2 anmeldelser)
2,5
2,5
Brug Avatar.
See private message.
$127,50 USD på 7 dage
5,0 (3 anmeldelser)
1,2
1,2
Brug Avatar.
See private message.
$340 USD på 7 dage
5,0 (5 anmeldelser)
1,1
1,1
Brug Avatar.
See private message.
$255 USD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
See private message.
$424,15 USD på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
See private message.
$382,50 USD på 7 dage
0,0 (5 anmeldelser)
0,0
0,0

Om klienten

Flag for CANADA
Brockville, Canada
5,0
37
Betalingsmetode verificeret
Medlem siden aug. 21, 2008

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.