logic add to script -- 2

I need to have logic added to a script to update a column showing the remaining time left or if it's no longer available determine what happened to it. The script currently scrapes data from a json feed similar to this [login to view URL] It compares the table entries by auc id against the new json feed with the same parameters and on duplicate entries it will update the timeleft column with the remaining time (VERY LONG, LONG, MEDIUM or SHORT) and if there's no entry in the new json feed with the same auc id and still has one of the time strings it will need to determine what happened to that entry by using this logic [login to view URL] and update the column with SOLD, CANCELED or EXPIRED. - Scraping experience is required. - Knowledge of World of Warcraft is highly preferred.