Auto parts kit builder

Currently we have a script that will pull part numbers and year make model fitment. We need a program that we can upload the scraped information into. the program will ultimately put together a user defined set of parts using a part type and position. Steps (partnumconversion table) 1. import the scraped CSV file 2. Compare the scraped part number to our partnumber(partnumconversion table) 3. Assign partpartterminologyname(partnumconversion table) 4. Assign VehQty (partnumconversion table) (VCDB) 1. Validate year 2. Validate make 3. Validate model 4. parse engine information and validate 4A. aspiration 4B. cylinderheadtype 4C. liters 4D. block 4E. cylinders 4F. enginedesignation 4G. enginemfr 4H. engineversion 4I. enginevin 4J. fueltype 4K. ignitionsystemtype [login to view URL] 4M. fueldeliverysubtype 4N. fuelsystemcontroltype 4O. fuelsystemdesign 5. parse and validate body style 5A. bodynumdoors 5B. bodytype 6. Parse and validate brakes 6A. frontbraketype 6B. rearbraketype 6C. brakesystem 6D. brakeabs 7. Parse and validate transmission 7A. transmissionnumspeeds 7B. transmissioncontroltype 7C. transmissiontype 7D. transmissionmfrcode 7E. transmissionmfr 8. Validate trim 9. Validate position 10. Validate drive type Kit designation User will define part type ans position to create a group of parts that will be knows as a kit. There will need to be some special logic here that will be able to add a prefix or suffix to the converted part number. The unique set of components will be driven by the exact match of the validated year make and model. (Proposed table Kit Designation) 1. KitCategory {User Defined} 2. partterminologyname {user defined validated from Step 3 from (partnumconversion table)} 3. position {user defined validated from Step 9 VCDB} 4. qty {Assign VehQty (partnumconversion table)} part KitNum subCat newpartterminologyname Missing data. If a specific year make and model are missing information the scrape script should be run to capture the information. We should have the ability to review and input missing data. I'm pretty sure this will handle phase 1