>> Back to NSBS Home


Case Study 8:
Monitor Competitor's Prices
 
A small business reseller wants to be able to beat its competitors by offering the lowest price on any product it carries on an online marketplace. The reseller stocks more than 500 different products and titles, making it difficult to manually look up competitor prices and adjust his prices on a regular basis.
 

Using Newbie Web Automation, custom scripts were developed to lookup the lowest price for any given product and update his price to be the lowest price. The following configurable parameters were implemented:

Stop Price - The minimum price; the lowest price the reseller is willing to offer.

Better Price By -  The amount to lower by based on lowest competitor's price.

For example: lowest competitor price for a certain product is $10.00, Better Price By is set to $0.50 and Stop Price is $7.50. The new price will be $9.50. If the competitor's price fell below $7.50. The new price will be set to $7.50.

An Excel Audit Log file is also generated containing the following information: the products that were updated, the competitor's price, the previous price and the new price. Running the scripts took only a few minutes compared to hours and days it would have taken if this web task was done manually.

 

   
   
Copyright © 2007 Newbie. All Rights Reserved • ©2007 Microsoft Corporation. Windows Vista is a registered trademark of Microsoft Corporation.