Database Manipulation, API Import and Search Engine Functionality

Project entails database management, including importing data, deleting data when conditions apply, mapping data. Knowledge of the Commission Junction, Linkshare, Google Affiliate Network and Shareasale API's is a plus, but not required. Search results. Searching the database for data, along with suggestions when data returns no results. Expanding search to product database when needed. ## Deliverables The programmer will need to work with the existing code to make the search functionality more successful and robust. Currently we are importing data from Commission Junction, Linkshare, Google Affiliate Network and Shareasale api's and txt files. Currently there are issues with the api feed and the txt files containing expired coupons and coupon codes. When importing this data, the programmer will need to check that the dates are not expiring before today, in addition, the programmer will need to check the description for date formats, so that if there is a date prior to today in the actual description string, it will recognize the date as expired. Example => Description: Save on shipping at [login to view URL] this offer expires on 7/9/2010. Date from: 7/2/2010 Date to: 00/00/0000 (The publisher never entered the expiration date here) The database should not contain duplicate entries, based on the url description and description. One or the other can be duplicate as long as it is not both. ==================== Search functionality The database imports two types of feeds one is a coupon feed the other is a product feed (product feed is not complete and will also require coding) The main database we want to search is the coupon database, however if no results are available we will then search deeper into the product database, only if the results = 0. (This is typical of when a user searches a product like motorola h850 bluetooth) and more than likely the product search will be effective here. When a user searches for something and the database shows less than 5 results, the search results will suggest variations of the search query that contain results. Example: Cheap Las Vegas Tickets You might want to refine your search to get more results Cheap Las Vegas Las Vegas Tickets Cheap Vegas Tickets etc So if you are a master at working with database importing, data manipulation, and search engine functionality, we would love to hear from you. We are not asking for someone to re-develop the website from scratch, we are asking for someone to implement code based on existing code.