Simple automation script to compare two CSV files
- or -
Post a project like this2950
$
- Posted:
- Proposals: 4
- Remote
- #1077871
- Awarded
Description
Experience Level: Entry
General information for the business: We sell products online
Description of requirements/functionality: We require a simple script to compare two CSV files and output a third.
We sell products online and offline, we need to update online inventory manually.
We have two CSV files that need compared automatically.
Web.CSV
Stock.CSV
Search SKU number in both sheets, compare quantity and output to a separate CSV if different or there is stock but item is disabled.
Web.CSV has many fields but only 3 are required to be checked. One of these is an enabled/disabled field.
Considerations
Some parts online are sold in multiples eg a bag of 100.
If this is the case..
1) There is a text line in a description field of Web.CSV which states this and what the multiple is
IE (Bag of 100) or (Bag of 10).
2) Stock quantity from Stock.CSV has to be divided by this number.
Output file shall show 3 columns and only display the items that are different.
1) SKU
2) Current quantity (taken from Stock.CSV and after bag quantity calculation)
3) IfEnabled (Yes/No)
Will be available to Skype and can provide sample CSV files. I cannot post here as it contains sensitive information.
We do not have a huge budget but expect this to be a quick and easy job. Please offer either fixed price or hourly rate with estimated hours to completion.
Specific technologies required: Does not matter
OS requirements: Windows
Extra notes:
Description of requirements/functionality: We require a simple script to compare two CSV files and output a third.
We sell products online and offline, we need to update online inventory manually.
We have two CSV files that need compared automatically.
Web.CSV
Stock.CSV
Search SKU number in both sheets, compare quantity and output to a separate CSV if different or there is stock but item is disabled.
Web.CSV has many fields but only 3 are required to be checked. One of these is an enabled/disabled field.
Considerations
Some parts online are sold in multiples eg a bag of 100.
If this is the case..
1) There is a text line in a description field of Web.CSV which states this and what the multiple is
IE (Bag of 100) or (Bag of 10).
2) Stock quantity from Stock.CSV has to be divided by this number.
Output file shall show 3 columns and only display the items that are different.
1) SKU
2) Current quantity (taken from Stock.CSV and after bag quantity calculation)
3) IfEnabled (Yes/No)
Will be available to Skype and can provide sample CSV files. I cannot post here as it contains sensitive information.
We do not have a huge budget but expect this to be a quick and easy job. Please offer either fixed price or hourly rate with estimated hours to completion.
Specific technologies required: Does not matter
OS requirements: Windows
Extra notes:
Craig S.
100% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
9 Mar 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies