We have two files, [url removed, login to view] and Child.csv.
The main problem is we need to merge these files. However, in this process, some fields need updating, some lines need ignoring, some codes need to be looked up in other files and data replaced, with an outcome of a file output.csv. We don't care how the data is processed, we just care about the outcome.
This is work for converting data as an export from one inventory system to import into another inventory system. The data needs to be manipulated to fit the second system.
In the old system, every product was a master product and had child products. In the new system, if there is only one child product, we do not need a master product, we just need a single entry. Additionally, if the product is listed in the [url removed, login to view] with a quantity of 0, we can ignore it.
We have a basic decision making tree which does not need to represent how the programming is done, it just helps the freelancer understand the required output. We have uploaded this tree and samples from master and child, and all the lookup csv's. The [url removed, login to view] is 89,000 lines and Master is 26,000 lines
Also included is a sample [url removed, login to view] file. The first line is the fields for the new system. The second line helps show the data from the old system. Lines 3-7 are examples of the required output.
We will require this data to be converted, we then need to take the data and analzye it briefly, make any changes to the conversion, and perhaps convert it again based on the changes required.
This project will be awarded today, and we must have an initial data conversion for July 22nd by 2PM GMT-0600. We will test the import into the new system and make changes on July 23.
Thank you for reviewing this project.