Selective Excel Data Removal
Budget: $300 – $500 USD
I need a script or program or something that will remove data from a very large CSV based on the total of certain values equal to zero.
The goal is to slim down a massive CSV file and make the upload smaller and easier to process on Shopify's backend.
The example file shows a small amount of Sample Data, a breakdown of what would be removed (red) or kept (green) based on the total inventory qty of said item. Finally, there is an example of what the output should look like.
Sample Data:
- This is a small batch of raw data you will be working with. The program needs to be able to handle over 1MM rows of data in total.
Criteria for removal:
- Items with matching names in column A but a total of zero (0) quantity in column R need to be removed entirely from the sheet (entire rows deleted)
Output Sample
- No headers (Row 1) can be changed in any way.
- Additionally, the kept rows of data cannot be reorganized in any way other than for the deleted rows to be removed from the sheet.
- The sheet needs to be saved in CSV format.
Challenges:
- Some items have five possible variations, and all five must be added to see if the total inventory exceeds zero. If so, all five need to be kept. If not, all five need to be removed.
- Some items have ten possible variations, and all ten must be added to see if the total inventory exceeds zero. If so, all ten need to be kept. If not, all ten need to be removed.
-Script or program needs to work on all modern versions of Excel (Windows and Mac)
The sheet will be full of 5 and 10 variant items with no way to separate the sheet into two sheets based on if there are 5 or 10 variants.
Future Needs:
There are additional steps I would like to add to this down the road to make things more automated, but current needs are as listed above.
The goal is to slim down a massive CSV file and make the upload smaller and easier to process on Shopify's backend.
The example file shows a small amount of Sample Data, a breakdown of what would be removed (red) or kept (green) based on the total inventory qty of said item. Finally, there is an example of what the output should look like.
Sample Data:
- This is a small batch of raw data you will be working with. The program needs to be able to handle over 1MM rows of data in total.
Criteria for removal:
- Items with matching names in column A but a total of zero (0) quantity in column R need to be removed entirely from the sheet (entire rows deleted)
Output Sample
- No headers (Row 1) can be changed in any way.
- Additionally, the kept rows of data cannot be reorganized in any way other than for the deleted rows to be removed from the sheet.
- The sheet needs to be saved in CSV format.
Challenges:
- Some items have five possible variations, and all five must be added to see if the total inventory exceeds zero. If so, all five need to be kept. If not, all five need to be removed.
- Some items have ten possible variations, and all ten must be added to see if the total inventory exceeds zero. If so, all ten need to be kept. If not, all ten need to be removed.
-Script or program needs to work on all modern versions of Excel (Windows and Mac)
The sheet will be full of 5 and 10 variant items with no way to separate the sheet into two sheets based on if there are 5 or 10 variants.
Future Needs:
There are additional steps I would like to add to this down the road to make things more automated, but current needs are as listed above.