These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Monday, November 22, 2010

Competitive Scraping,

Executive Summary

I currently work for, a major internet retailer. Our main competitor is, and we have many different methods of trying to keep current on's prices. Our philosophy at is that we want to be know as the internet's low price leader. As such, when aware that we are selling the same product at a higher price than, we lower the price or drop the product. That way consumers can have confidence that when they have found what they want on our website, that we will have lowest price. We currently have a team of 5 full-time employees whose sole job function is keep our database of information current. When I asked my boss for ideas about this project, he said it would be really useful if I could write a macro where we could feed it Amazon Stock Identification Numbers (ASINs) and it would bring back the name, current pricing, current shipping, and total current cost for that item. As requested, I did just that. Both my direct boss and his boss have tested this macro, and found it to exceed their expectations. We are excited to implement it as a tool that will save both time and money.

No comments:

Post a Comment