Find Jobs
Hire Freelancers

CSV synchronization

$30-250 USD

Closed
Posted about 15 years ago

$30-250 USD

Paid on delivery
Our supplier has a csv file updated daily ([login to view URL]).It has more than 23000 records. We had our personal csv file (stored in our computers) made of some of these records. These records are the items that we actually sell online, and we add new records every day(copied manually from the supplier's csv) We are searching the way to synchronize automatically our csv file with the supplier's csv. Infact we want to quickly find if any item is over or change the price. pleace ask for more details. We paid for setup an efficient system to do that. Post your way to do that. Disponiamo di un file .csv (che contiene dati relativi ad alcuni prodotti) Questo file (che chiamiamo per esempio A) è aggiornato frequentemente dal fornitore e contiene oltre 23000 records,che corrispondono ad altrettanti prodotti. Parte di questi prodotti sono caricati per la vendita online. Questi ultimi andranno a formare una nuova lista in un' altro file csv (che chiamiamo file B) da noi creato. Cerco un modo per individuare il più rapidamente possibile le indisponibilità dei prodotti e le modifiche dei prezzi dei prodotti da noi scelti nel file B.... In pratica bisognerebbe sincronizzare il file B solo dei records che ci interessano presenti nel file A. Possibilità di collaborazione frequente per implementazione di altri progetti.
Project ID: 411882

About the project

19 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $118 USD for this job
User Avatar
I have made a prototype PHP program which will do this task. Please see my proposal in more detail in your Private Message (PM). Thank you.
$30 USD in 3 days
5.0 (18 reviews)
5.0
5.0
User Avatar
Dear Sir/Madam, I am familiar with such types of task. I have done it previously. I have the script which does the similar job. Please check PMb to see details.
$30 USD in 1 day
5.0 (5 reviews)
2.9
2.9
User Avatar
First i would download the CSV file with the PHP module cURL. Then I would step through eacy line, checking the price against the price in your CSV file by searching your CSV file product names or product ID's. I need to see the layout of your CSV files. Then I would save the results in a new CSV file. This script would run on a cron Linux schedule for any time you wish. Thanks.
$120 USD in 3 days
5.0 (1 review)
1.8
1.8
User Avatar
Hi! I make similar job and can do this for you.
$30 USD in 2 days
3.2 (2 reviews)
1.6
1.6
User Avatar
Hi, Can you give me more details about this project. From you're description, it sounds like a matter of comparing your csv file with the suppliers csv file for any differences. Regards, Paul.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Vitoturi, As per my understanding, I guess you require a feature in your CSV file which on comparing with the supplier's CSV sheet fetches data and processes it to provide alerts on certain conditions like price point exceeded etc. This can be done easily by writing a Macro. Can you kindly let us know the details/additional functioanlities required?
$125 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi this can be done easily by using a rdbms like mysql or something like this.
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please check PMB. Thanks.
$50 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I think there is a way to do it
$30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. My suggestion is to make an excel project (workbook) that would validate the current items against the new ones or modified the data (price and quantity available if it´s the case) based in the new CSV. Old items would be removed and new ones inserted. The new CSV could be sorted by your needs. The Excel workbook would have an built-in toolbar (the toolbar would follow the workbook with no need for installation), with buttons that would simplify the running of the actions (macros). Button - insert new CSV Button - integrate new data Button - export new data to a clean CSV I hope this will fill your needs and i hope to your from you soon! Jorge
$200 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please see your PMB for details.
$200 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, my suggestion is create macros in excel which will automatically update the CVS file. Also you can use excel functions for the same. Thanks
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can do it in Java. Plz check PMB. Thank you.
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please provide me the business details that may help me to make this program more convinient for you that your expectations
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We can develop software
$150 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I need few more details. Why do you need to maintain a separate excel on every computer? Just trying to understand the flow.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i wil do it by excel
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
70028, Italy
0.0
0
Member since Mar 31, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.