Proposal summary
The proposal covers the scope of updating item record based on the CSV attached for vendor Pacific Lifestyle.
Requirement
The requirement is to map SKU(product code), SRP price and Stock in item record based on the CSV file attached
Our Solution
We assume that you will create a folder and a file inside it in the NetSuite file cabinet and you will add the CSV file attached there. You can overwrite this file to add new details. Only one file needs to be maintained in the folder.
We will create a map reduce script to fetch this file from the file cabinet and process the CSV details.
We will use the Product Code in the file to find out the Item in NetSuite and we will update the SRP Price and Stock in the Item record
After processing the CSV file we will remove/delete the contents of this file and move the processed file to another folder. Incase if we face any errors, then we will maintain another folder to keep the error data that we couldn’t update to NetSuite.
Field Mapping
| CSV file Column | Netsuite Field |
| Product Code | Item Name/ Number |
| Unit RRP | SRP price level |
| Stock | Dropship Quantity (Custom Field) |
Please confirm the field mapping
Assumptions
- We assume that each day, only one file will be received to the folder in file Cabinet
- We assume that the Item name will be added in the Product code column of CSV.
- We assume that we only need to add the Unit RRP and stock from CSV file to Item record in NetSuite
- We assume that you can download the CSV file from email and can attach it in file cabinet
- We assume that we can schedule the script to work once every day.
- We assume that updating the item record is independent of vendor. That means, if the header of the CSV file is same for each vendor , we can map the data from CSV file independent of vendor.
- Incase if we face any errors, then we will maintain another folder to keep the error data that we couldn’t update to NetSuite.
Risks
- File cabinet folder should only have one file. This file needs to overwritten with new details instead of creating new files
- The headers of the CSV file should remain the same.
- If the header of the CSV file is same for each vendor , we can map the data from CSV file independent of vendor. If the header is different per vendor then we may need to use another folder to map the details to NetSuite.
Time
18 Hrs
| Analysis | 2h |
| Development | 12h |
| Testing | 3h |
| Documentation | 1h |
Additional Recommendations
Since we are adding the processed files in to a folder, this may increase the file cabinet capacity based on the number of files. You can either manually delete this files when it is no longer needed or we can add a functionality in script to delete old files based on their created date. We are not included this in the current scope of proposal. Please let us know if we need to include that one.