Compare files to previous day's files and report differences

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I receive (via email) files every day from 3 different manufacturers. These files contain SKUS, inventory levels, costs, and other product information. 3 samples attached (2 are csv, 1 is xls) All 3 have different layouts.

I need an automated report of everything that has changed in each file when compared to the previously received file (at the SKU level)

For example, if I receive the file "Inventory_Forecast_UPC" today and "ModelNumber" (aka SKU) ACR4 has Availability of 24, then tomorrow I received the file and the Availability is 23, I need a report (preferably emailed to me) that shows this change.

The report could be xls or text, output like this:

ModelNumber,Changed Field Name,Previous Value, Current Value

ACR4,Available,24,23

Or it could show the previous days' row and the updated row like this:

ACR4 24 0 879297006350

ACR4 23 0 879297006350

I also need to know which items are in the file that were not in the previous day's file.

so if today there is no row for model number ACR4, but tomorrow there is a row with the model number, I need to know it was added to the fill.

I also need to know what items were removed from the file.

Many of you asked for the other files - I'm not sure why they didn't load initially. Adding them now.

I need this to be automated if possible. Not a local program I have to run manually.

Coding Data Processing Email Handling Excel Programming

Project ID: #15058061

About the project

34 proposals Remote project Active 6 years ago

34 freelancers are bidding on average $204 for this job

jaylancer43

Hello, My name is Jay and I am Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More

$200 USD in 3 days
(842 Reviews)
9.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I can add code so that you can do this task multiple times in the future. Relevant Skills and Experience More

$160 USD in 3 days
(419 Reviews)
8.2
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of More

$250 USD in 2 days
(486 Reviews)
8.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

$250 USD in 5 days
(489 Reviews)
8.0
Khurramz

Hi I can see a csv file only. No xlsx files attached. Could you please send me via chat? Relevant Skills and Experience Excel Proposed Milestones $250 USD - Estimate

$250 USD in 5 days
(406 Reviews)
7.8
TonmoyRoy111

A proposal has not yet been provided

$200 USD in 3 days
(489 Reviews)
7.4
Attractionnet

Hi. I checked the csv file with the data. Here is my suggestion. I will write a program which you can run on windows and will check your email. It will download the file, read it, track changes etc. Relevant Skills a More

$133 USD in 3 days
(151 Reviews)
6.8
ksriniravi

1 sample file attached (not 3). I can set up a solution such that you can import 2 files & the macro would generate a Removed items list, Added items list & discrepancy (same item different Qty) list. Update: Review More

$100 USD in 2 days
(220 Reviews)
7.0
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex More

$40 USD in 2 days
(168 Reviews)
6.5
KavTan

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html Relevant Skills and Experien More

$250 USD in 5 days
(54 Reviews)
6.3
aminbros

A proposal has not yet been provided

$377 USD in 3 days
(14 Reviews)
5.6
prakashmondal

hi, I am interested to develop a script that can generate a report from csv and excel file from different source. Please consider my bid and let me start with the job. Relevant Skills and Experience c#,.net,php,mysql More

$250 USD in 10 days
(14 Reviews)
4.7
novepi1

Hi, How exactly you want to run this program? Is it supposed to be a desktop or web application running on a server? By the way, there's only 1 file is attached, 2 of them missing. Relevant Skills and Experience auto More

$200 USD in 3 days
(5 Reviews)
4.5
NewHorizons2016

Greetings, I'm a software developer with vast experience. If you wish, I could create a Windows application which takes as input, these 3 files and produces your desired output? Relevant Skills and Experience 25 year More

$200 USD in 3 days
(5 Reviews)
4.6
jonathanpradas

I believe that my bid is sufficient to finish the project on time with all the requirements already met. I have thoroughly read the project description and I can guarantee I can handle this one. Relevant Skills and Ex More

$100 USD in 3 days
(20 Reviews)
4.7
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience with report creating in excel with all the details. I never miss work and always deliver on time. - Detail Oriented, as handled many sens More

$250 USD in 1 day
(8 Reviews)
5.0
prakash2813

Hi there, I have read the details and checked attached csv file. Its an easy job for me. I can create a desktop to run in background forever or manually to email differences. Message me, Relevant Skills and Experience More

$300 USD in 3 days
(11 Reviews)
4.4
asad090

Hey there, i would like to discuss with you about the project please allow me to speak with you. Thanks. Relevant Skills and Experience Data Processing, Email Handling, Excel, Programming Proposed Milestones $100 USD More

$100 USD in 7 days
(7 Reviews)
4.2
mcfarhat

hey there, we can create a PHP script for you that, when fed the 2 files, it would be able to compare both and then send you the changes/missing items, via email if needed Relevant Skills and Experience we have 13+ ye More

$500 USD in 3 days
(3 Reviews)
3.9
swift555

Hi, i am experienced writer Relevant Skills and Experience I have done many projects related your task Proposed Milestones $200 USD - milestone sure, i can do it and contact with me for more detail.

$200 USD in 3 days
(3 Reviews)
3.4