We recently published the article Minimum Advertised Price (MAP) Enforcement Best Practices discussing why manufacturers should monitor and enforce MAP. In this post, we’ll show you how Import.io helps manufacturers keep track of product pricing to ensure compliance with MAP. This example is based on monitoring just a few websites, but if you have 100s of retail partners or you want consolidated reporting, Import.io offers price monitoring as a service.
Example: How to monitor minimum advertised price with Import.io
Import.io provides baseline data on pricing and then alerts you by email when prices change on any website you are monitoring. The email alert contains a spreadsheet of the data and a PDF report on price changes like the sample Change Report section below.
In this scenario, you are the manufacturer of Mr. Coffee brand coffee makers and accessories. You want to monitor pricing on online marketplaces selling Mr. Coffee products including Amazon™, Target™, Walmart™, and Bed Bath & Beyond™.
First, navigate your browser to each website and search on Mr. Coffee, then copy the resulting URLs.
Once you have your URLs (4 in this case), you will enter them into Import.io to extract the name of the product and the price.
After clicking go, you will then choose what data to collect for monitoring. First, name the two columns of data you need to collect – Product Name and Price. Then, while in the appropriate column, click on the items. After choosing a few items, Import.io determines the pattern and highlights the rest of the Product Names or Prices in green.
Once you have your Product Name and Price columns populated, then click to “extract data from website”.
After clicking extract data, you’ll set up your Change Report. In the “Match field” section drag and drop “Product Name”. In the Monitored Column, drag and drop “Price”.
Import.io will detect if more pages exist with Mr. Coffee products and you can add those after clicking Yes on the Change Report.
Next step is to decide how often you want to monitor the prices – hourly, daily, weekly, or choose once only if you want to manually trigger each Change Report.
Once you have this data, you can download an Excel spreadsheet as a baseline for data changes going forward.
The next day, you will be emailed both a PDF and CSV version of what’s changed on the website. As you can see in the email, the reports not only show what items (in this case prices) have changed, but also any items that have been added or removed from the website you are monitoring.
This week, Target and Bed Bath & Beyond had no pricing changes, but Amazon and Walmart had several. Here are excerpts of the Amazon and Walmart change reports in PDF format. You can also download a CSV spreadsheet.
You may need to monitor hundreds of websites or more complicated scenarios, so Import.io also provides price monitoring as a service; you tell us what you want to monitor and where and we send the data to you.
Contact Import.io to determine how change monitoring can benefit your business!