I'm looking for a web-based script that can be used to scrape data from two different databases and compare fields. This will be done on a weekly basis. Both databases are dynamic and change weekly.
I'll be comparing the brand and product from the shopping site and matching it with the coupon data from the other site.
Then I need a dashboard that will let me accept, correct or reject the matchups. Ideally, for future matches the script will look up previous verified/corrected matches.
One source will be from something like this:
[url removed, login to view],1,2,3,4,5&bfmt=*23!2|1|4|*12!2|1|4|*13!2|1|4|5|*15!2|1|3|4|5|*20!2|1|4|*18!2|1|4|5|*14!2|1|*21!2|1|4|5|*16!2|1|4|5|*19!2|1|4|*22!2|1|4|*1!2|1|4|5|*11!2|1|4|*6!2|1|4|
The other source will be from this:
[url removed, login to view]
(several grocery stores use the same mywebgrocer system, I'll be starting with 3 different stores)
The focus will be mostly on products with special prices (specials), but if possible I'd like to do the whole grocery DB each week.
Each store handles coupons differently and have variations on policy. Some stores multiply coupons: double-coupons (some stores double up to 50 cents, others double up to 99 cents), double-dollar-coupons (double coupons with a value of $1, but only on Wednesdays), triple-coupons (up to 99 cents), super-double-coupons (up to $1.98).
Finally, I'll need a way to output a merged list (for each store) with matches for products with coupons available:
Product Brand and Item - Price (from mywebgrocer)
coupon Y (output is "blog format" from mycoupondatabase)
Final Price: (this will be calculated from the (Price * required number of items, less (coupon value * coupon multiplier))/required number of items for a unit price after coupon
(for each coupon that is a match)
Output can just be an html page that I can copy and paste into my blog.
For this work-for-hire project, I'm looking for well-documented code.
Please provide links to projects of similar nature.