Build / Complete Database of Suppliers

This is a database of suppliers we will be using for our company. You will notice some of these suppliers only have some information completed (Supplier Name or Email), and it will be missing other vital information which we need in order to upload them onto our database. This project is a data research, scraping and data entry project with the intent to complete the following fields on this spreadsheet: 1. Company Name (Column A) 2. Address details on columns B, C, D, E, F, G a. G is a two-letter country code. Use country code list at the end of this document. 3. Telephone (column I) 4. Email (column K) 5. Supplier Keywords (Column Q) a. This is THE MOST IMPORTANT part of this project b. You need to include at least 10 keywords which relate to the products the supplier sells/manufactures c. This also relates to BRANDS the supplier distributes. Make sure you look on the website and include all brands the supplier distributes d. You must view their website, look for their product list, and include as many products as possible e. If the supplier is a VALVE distributor/manufacturer i. You must include ALL valve types they sell ii. You must include the standards of valve they sell/manufacture. These usually start with API (API 6A, API 6D, API 6DD, etc) iii. Brands of valves they distribute f. If the supplier is a steel distributor/manufacturer i. Seamless or Welded? (must be one of these two) ii. Steel, Aluminum, Stainless, Alloy, Tool Steel, Brass, Bronze, Copper, Cast Iron? iii. Shapes: Rounds, Squares, Flats, Angles, Channels, Sheet, Plate, Tubing? iv. Grades: 1018, 1045, 1117, 11L17, 1144, 12L14, 1215, 6061, 6063, 2024, 7075, MIC6, 5052, 3003, 2011, 303, 304, 316, 17-4, 630, 410, 440, 416, 420, 4140, 41L40, 4130, 4340, 4820, 8620, 4150, o-1, a-2, d-2, s-7, h-13, 260, 360, 110, 954, 932, Class40 Cast Iron g. If the supplier is a pipe distributor/manufacturer specify all they can supply like i. Seamless pipe ii. Welded pipe iii. Line Pipe iv. Galvanized v. FBE pide Add To spreadsheet companies on these links, and ALL their respective details as per above instructions: 1. [login to view URL] 2. [login to view URL] 3. [login to view URL] 4. [login to view URL] 5. [login to view URL] 6. [login to view URL] 7. [login to view URL] 8. [login to view URL] 9. [login to view URL] 10. [login to view URL] 11. [login to view URL] 12. [login to view URL] 13. [login to view URL] 14. [login to view URL] 15. [login to view URL] 16. [login to view URL] 17. [login to view URL] 18. [login to view URL] 19. [login to view URL] 20. [login to view URL] 21. [login to view URL]