Ecommerce company selling inkjet and laser toner cartridges online looking for a very simple PHP/MySQL project to help with our product catalog. We need to build a cross referenced database of inkjet and toner supplies that will allow us to… 1. Lookup the printers that are compatible with a specific cartridge or toner. 2. Lookup the cartridges that are compatible with a specific printer. 3. Lookup up products related to each other, such as black/white and color paired cartridges. … The task will include… 1. Designing the database tables to store information, that will likely include a products table, printer model table, connections table, manufacturers table, etc. 2. Take our existing csv file of approximately 470 products and massing and importing the data into the database. 3. Creating a very simple (form fields on a white page is fine) data entry screen so someone can update the database. 4. Creating a php lib or class file that contains the necessary routines to perform lookups against the database to find the kind of results listed above. 5. Creating a simple XML interface that would allow you to submit a query via XML and have the search results returned via the same. … The database must contain, and the search routines need to be able to handle, the official part number, sku, common name(s), a brief description, full description, printer models, page count (number of pages the cartridge typically prints), size (ml the cartridge holds), type (b/w, color, laser, other, etc.), related part numbers for each of our suppliers with variants (OEM, remanufactured, compatible, etc.). As a bonus, I will also need to hire someone to do the internet research to populate the database with new information (printer models not in our database, etc.). If the firm would like to bid on this component in addition to the development they may do so.