PriceCheck for Amazon MWS API - Amazon Pricing Information Program

Bulk lookup Amazon Pricing for Thousands of UPC, ASIN, ISBN, and EAN codes Using PriceCheck. Perform Online/Retail/FBA Arbitrage Analysis quickly and easily. Convert UPC and ISBN to ASIN, and ASIN to UPC and ISBN. The MWS demo download has been updated (3/6/2017) and so have the sample input.csv file, output.csv file, formatted Excel workbook output file, and Excel formatting macro file. I suggest you download the sample input, output, and formatted output files first so you can see what PriceCheck can do for you. Then download the MWS demo and test it out on your input files (only the first 10 items of the file will be processed). You can also go to the bottom of this page to see the sample input, output, and formatted output files without even downloading them.

Do you need to analyze price lists, wholesale DVD and CD lots from wholesalers/distributors like GENCO? Make sure you aren't overpaying?

Typically, someone like GENCO provides a file of the products they have for sale. PriceCheck will process the file and bulk lookup Amazon Pricing for thousands of UPC, ISBN, EAN, and ASIN codes and save the Amazon pricing information (e.g. sales rank, lowest new price, lowest used price, total number of new and used for sale, etc.) to an output file so you can analyze manifests/price lists from wholesalers and distributors like GENCO, decide what to buy, justify giving the wholesaler less money, and competitively reprice your products for sale. See sample input and output files below.

This program is for Amazon FBA (Fulfillment By Amazon) sellers in the AFN (Amazon Fulfillment Network), and Merchant Fulfillment sellers. You must be signed up for MWS. This program looks up UPC codes using Amazon MWS and saves their pricing information. It will identify if you own the Buy Box and what the lowest Buy Box price is for FBA and Merchants.

I charge $199 for the uncrippled version. This is a one-time fee. There are no monthly subscriptions (if you are paying $20/month for an online pricing service this program starts saving you money after just 10 months). You can run it as much as you want to. You are limited only by the Amazon API call limit for your account which is 10,000 requests per hour for the MWS version. The PA API version is limited by the Amazon API call limit for my account which is 2,000 requests per hour (which can be easily modified to use your Amazon AWS keys and call limit). Payment is usually via Paypal, but I consider other options as well. Usually, I ask for half, then I uncripple the program, and then you send the other half when you confirm the program is working. Thank you for taking a look at my program.

Update 3/6/17 - PriceCheck for MWS updated to now display the following:

  • Buy Box owner name, including if Amazon is the Buy Box owner.
  • Buy Box owner type - Amazon, FBA, or Merchant.
  • Is Amazon a seller of the item, and Amazon's selling price.
  • Item availability (is the item in stock), and Dispatch Time.
  • Latest Amazon fees as of 3/6/2017. Referral fee, FBA fee Jan-Sept and Oct-Dec, monthly storage fee Jan-Sept and Oct-Dec, inbound shipping fee, and total for all fees.
  • Buy Box price, first selller price, lowest FBA price, lowest Merchant price, and the 10 lowest prices. So you know exactly who you are competing against and what their prices are.
  • Excel formatting macro which will convert the initial output .csv file to an Excel Workbook and add various formatting so the data is easier to read and analyze. For instance, input columns have one color, output columns have other colors to help visually organize the data, Freeze Pain the first row, add Data Filter to all columns so they can be sorted and filtered. Additional formatting such as conditional formatting, and more can be easily added to suit your needs.
  • With the formatting above, common analysis such as select all items with Net Profit greater than $10 and sort by ROI descending order can be done with just a few clicks. Allowing you to quickly find the most profitable items to buy and sell. Makes online/retail arbitrage analysis quick and easy.
  • Determine multipack, count, case, etc from Amazon Title.
  • Links to Keepa.com and CamelCamelCamel.com so you can quickly look up historical pricing and rank information.

I originally wrote the program for a guy who bought and sold DVDs. He would get lists of DVDs for sale from wholesalers and use PriceCheck to compare the wholesalers price with the Amazon price so he could determine which DVDs were worth buying. What would take him a month to do manually, was done in an hour with PriceCheck.

By comparing their asking price with the Amazon pricing returned by this program, you can determine which items are worth buying. The output file also has links to historical pricing charts on camelcamelcamel.com which are very informative (sample chart The Negotiator). Another good site for historical pricing is keepa.com. You can also use this program to lookup the products you sell and compare your prices with your competitors.

I worte PriceCheck and can customize it to suit your needs. For instance,

  • Lookup up your corresponding inventory amounts while looking up the UPC, ASIN, ISBN, EAN codes.
  • Lookup stock Amazon photos and save the links and files.
  • Lookup pricing info on other sites like ebay. Scrape crawl spider other sites and collect product and pricing information.
  • Read and write to a database instead of .csv files.
  • Create a textbook buy back website.
  • I can also develop other programs and websites.

Amazon is a world-wide venture and operates in many countries throughout the world - United States, United Kingdom, Germany, Italy, France, Spain, Canada, China, and Japan. PriceCheck works in all of them. Not all products are listed in all locales. Typically, you will lookup by EAN.

 


 

Sample CSV input and output files Listed Below     Back To Top

You specify input and output files to hold all of the UPC, ISBN, ASIN, EAN data. The input file contains all of your UPC, ISBN, ASIN, EAN codes one per line. It can contain additional info like Title if you wish. Generally, it is saved from a spreadsheet program like MS Excel in comma delimited format (.csv file). The output file will contain the original input data plus additional columns containing the looked up pricing information. The output file can then be loaded back into MS Excel, and sorted, filtered and extra columns added which contain your logic to determine which items are purchased, repriced, etc.

Typically, the wholesaler will provide you a file containing a list of the products they have for sale. It will usually be a plain text file, .csv file, or Excel spreadsheet. I prefer a .csv file, but can work with just about anything. The default CSV format of fields being delimited with comma (,) and text being delimited with double quote marks (") works best.

To create a TEXT CSV file in Excel, follow the steps below:
1. Open your spreadsheet in Excel.
2. Select File from the top menu bar.
3. Select Save As...
4. Click on the "Save As Type:" list box, and select TEXT CSV. Then enter your filename, and click the Save button.
5. Accept default field delimiter of comma (,) and default text delimiter of double quote (") and click on the OK button.

Below is a sample .csv input file containing UPC codes for DVD movies. This sample includes additional data in the file that the seller received from the wholesaler.

UPC,TITLE,CUT UPC,Cost Price
085391675020,The Negotiator,,$1.90
012569767553,Comedy Double Feature: Spies Like Us & Nothing But Trouble,CUT,$2.25
883929002931,Risky Business,cut,$2.00
741952698890,Lord of the Dance,,$1.90
883929016693,Triple Feature- Clint Eastwood,,$3.00
012569763739,Jesse James,cut,$1.90
012569678385,Triple Feature- John Wayne,CUT,$2.25
850928002057,Blood Ties,,$1.00
741952695691,The Bangbang Club,,$2.00
741952693390,Everyday Black Man,,$1.25

Below is the output file after runninging it through PriceCheck for MWS. The output .csv file is a hard to read until you load it into your spreadsheet program and it looks like below. Now the seller can compare the wholesaler's price with the lowest price on Amazaon and determine which DVD movies are worth buying. Please download the sample output files so you can see the Keepa.com and camelcamelcamel.com links in the file.

ASINUPCTITLECUT UPCCost PriceAmazon TitleMulti Pack Qty (from title)Product GroupProfit Potential (bb-amz fees)Net Profit (bb-amz fees-your cost)ROI % (net profit/your cost * 100)RankBuyBox PriceSeller CountFBA CountMerchant CountBB NameBB TypeOut of StockDispatched WithinAmazon Seller?FirstSellerPriceFirstSellerFBA?FBA1 Lowest $Merchant Lowest $Keepa Historical PricingCamel Historical Pricing1 Lowest $2 Lowest $3 Lowest $4 Lowest $5 Lowest $6 Lowest $7 Lowest $8 Lowest $9 Lowest $10 Lowest $FBA1 Feedback RatingFBA1 Feedback CountMerch Listing $Merch Shipping $Merch Feedback RatingMerch Feedback CountTotal Amazon Fees (Ref+FBAJ-S)Referral FeeFBA Fees J-S (incl. 1 month storage)FBA Fees O-D (incl. 1 month storage)Monthly Storage Fees J-SMonthly Storage Fees O-DInbound Shipping Fee (weight*$0.5)WeightWeightUnitsHeightHeightUnitsLengthLengthUnitsWidthWidthUnitsNonMediaIOwnBuyBoxMy Lowest $My Listing $My Shipping $
'0790739739'085391675020The Negotiator$1.90 The Negotiator1DVD10.328.4248485714.99256My_Treasure_Chest_? Merchant No Match & FBA blanknow24 hours24 hours5.44NoNoData5.440790739739The Negotiator5.445.549.98NoDataNoData1.453.9995-97%388894.672.252.422.420.010.030.10.2pounds0.6inches7.3inches5.4inchesFALSEFALSENoDataNoDataNoData
B000E8QVCY'012569767553Comedy Double Feature: Spies Like Us & Nothing But TroubleCUT$2.25 Spies Like Us/Nothing But Trouble (DBFE)1DVD4.292.041177547.892234Amazon.comAmazonnow24 hours24 hours7.897.69No7.727.69B000E8QVCYSpies Like Us/Nothing But Trouble (DBFE)7.697.729.899.9811.9212.7612.7712.9898-100%766533.73.9995-97%743503.61.182.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData
B0018QPPXW'883929002931Risky Businesscut$2.00 Risky Business (25th Anniversary Edition)1DVD0.76-1.24-194063.743941Amazon.comAmazonnow24 hours24 hours3.743.74Yes3.746.84B0018QPPXWRisky Business (25th Anniversary Edition)3.746.847.447.718.1898-100%1663962.853.9995-97%1836352.980.562.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData
B004SKQAJI'741952698890Lord of the Dance$1.90 Michael Flatley Returns as Lord of the Dance1DVD1.74-0.160131654.895861CV Trading CorpFBA matchnow24 hours24 hours13.544.48No4.894.48B004SKQAJIMichael Flatley Returns as Lord of the Dance4.484.494.494.894.894.985.2498-100%515740.493.9990-94%4853.150.732.422.420.010.030.090.18pounds0.55inches7.48inches5.28inchesFALSEFALSENoDataNoDataNoData
B0014VPFT0'883929016693Triple Feature- Clint Eastwood$3.00 Every Which Way But Loose / Any Which Way You Can / Honkytonk Man (Triple Feature)1DVD39.1836.1812396260612? FBA - Neither matchY48.94No49.9948.94B0014VPFT0Every Which Way But Loose / Any Which Way You Can / Honkytonk Man (Triple Feature)48.9448.9449.9998-100%1172344.953.9998-100%43769.7602.422.420.010.030.130.25pounds0.6inches7.4inches5.3inchesFALSENoDataNoDataNoDataNoData
B0010DR4BO'012569763739Jesse Jamescut$1.90 The Assassination of Jesse James by the Coward Robert Ford1DVD2.670.77076035.996035Amazon.comAmazonnow24 hours24 hours5.995.99Yes5.996.84B0010DR4BOThe Assassination of Jesse James by the Coward Robert Ford5.996.846.846.987.9898-100%4956152.853.9995-97%88003.320.92.422.420.010.030.070.15pounds0.6inches7.5inches5.3inchesFALSEFALSENoDataNoDataNoData
B00G4RG71Y'012569763739Jesse Jamescut$1.90 ASSASSINATION OF JESSE JAMES1Book2.670.7705427213072? Merchant No Match & FBA blankY5.98NoNoData5.98B00G4RG71YASSASSINATION OF JESSE JAMES5.989.9314.1214.98NoDataNoData1.993.9995-97%169943.3102.412.390000NoData0NoData0NoData0NoDataFALSENoDataNoDataNoDataNoData
B000HT38C6'012569678385Triple Feature- John WayneCUT$2.25 "The Big Stampede / Ride Him, Cowboy / Haunted Gold"1DVD4.592.341414348.243527Amazing Prime ExpressFBA matchnow24 hours24 hours8.356.98No8.246.98B000HT38C6"The Big Stampede / Ride Him, Cowboy / Haunted Gold"6.986.987.748.2498-100%324552.993.9998-100%148533.651.242.422.420.010.030.070.15pounds0.6inches7.5inches5.3inchesFALSEFALSENoDataNoDataNoData
B002FG9N8W'850928002057Blood Ties$1.00 Blood Ties1DVD1.750.7513142684.9925CV Trading CorpFBA matchnow24 hours24 hours4.9Yes4.95.45B002FG9N8WBlood Ties4.955.455.4898-100%515741.463.9998-100%165563.150.732.422.420.010.030.070.15pounds0.6inches7.4inches5.3inchesFALSEFALSENoDataNoDataNoData
B0052T1EF4'741952695691The Bangbang Club$2.00 The BangBang Club1DVD2.470.470915485.755235CV Trading CorpFBA matchnow24 hours24 hours6.094.98No5.754.98B0052T1EF4The BangBang Club4.984.984.984.995.645.7598-100%515740.993.9995-97%27793.280.862.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData

 

Run the output through the Format macro so the headers are color coded and it becomes even easier to read. Please download the sample output files so you can see the Keepa.com and camelcamelcamel.com links and all the other formatting in the file.

ASINUPCTITLECUT UPCCost PriceAmazon TitleMulti Pack Qty (from title)Product GroupProfit Potential (bb-amz fees)Net Profit (bb-amz fees-your cost)ROI % (net profit/your cost * 100)RankBuyBox PriceSeller CountFBA CountMerchant CountBB NameBB TypeOut of StockDispatched withinAmazon Seller?FirstSellerPriceFirstSellerFBA?FBA1 Lowest $Merchant Lowest $Keepa Historical PricingCamel Historical Pricing1 Lowest $2 Lowest $3 Lowest $4 Lowest $5 Lowest $6 Lowest $7 Lowest $8 Lowest $9 Lowest $10 Lowest $FBA1 Feedback RatingFBA1 Feedback CountMerch Listing $Merch Shipping $Merch Feedback RatingMerch Feedback CountTotal Amazon Fees (Ref+FBAJ-S)Referral FeeFBA Fees J-S (incl. 1 month storage)FBA Fees O-D (incl. 1 month storage)Monthly Storage Fees J-SMonthly Storage Fees O-DInbound Shipping Fee (weight*$0.5)WeightWeightUnitsHeightHeightUnitsLengthLengthUnitsWidthWidthUnitsNonMediaIOwnBuyBoxMy Lowest $My Listing $My Shipping $
'0790739739'085391675020The Negotiator$1.90 The Negotiator1DVD10.328.42441%8485714.99256My_Treasure_Chest_? Merchant No Match & FBA blanknow24 hours24 hours5.44NoNoData5.440790739739The Negotiator5.445.549.98NoDataNoData1.453.9995-97%388894.672.252.422.420.010.030.10.2pounds0.6inches7.3inches5.4inchesFALSEFALSENoDataNoDataNoData
B000E8QVCY'012569767553Comedy Double Feature: Spies Like Us & Nothing But TroubleCUT$2.25 Spies Like Us/Nothing But Trouble (DBFE)1DVD4.292.0491%177547.892234Amazon.comAmazonnow24 hours24 hours7.897.69No7.727.69B000E8QVCYSpies Like Us/Nothing But Trouble (DBFE)7.697.729.899.9811.9212.7612.7712.9898-100%766533.73.9995-97%743503.61.182.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData
B0018QPPXW'883929002931Risky Businesscut$2.00 Risky Business (25th Anniversary Edition)1DVD0.76-1.24-62%94063.743941Amazon.comAmazonnow24 hours24 hours3.743.74Yes3.746.84B0018QPPXWRisky Business (25th Anniversary Edition)3.746.847.447.718.1898-100%1663962.853.9995-97%1836352.980.562.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData
B004SKQAJI'741952698890Lord of the Dance$1.90 Michael Flatley Returns as Lord of the Dance1DVD1.74-0.16-9%131654.895861CV Trading CorpFBA matchnow24 hours13.544.48No4.894.48B004SKQAJIMichael Flatley Returns as Lord of the Dance4.484.494.494.894.894.985.2498-100%515740.493.9990-94%4853.150.732.422.420.010.030.090.18pounds0.55inches7.48inches5.28inchesFALSEFALSENoDataNoDataNoData
B0014VPFT0'883929016693Triple Feature- Clint Eastwood$3.00 Every Which Way But Loose / Any Which Way You Can / Honkytonk Man (Triple Feature)1DVD22.1319.13638%396260612? FBA - Neither matchY48.94No49.9948.94B0014VPFT0Every Which Way But Loose / Any Which Way You Can / Honkytonk Man (Triple Feature)48.9448.9449.9998-100%1172344.953.9998-100%43769.7602.422.420.010.030.130.25pounds0.6inches7.4inches5.3inchesFALSENoDataNoDataNoDataNoData
B0010DR4BO'012569763739Jesse Jamescut$1.90 The Assassination of Jesse James by the Coward Robert Ford1DVD2.670.7741%76035.996035Amazon.comAmazonnow24 hours5.995.99Yes5.996.84B0010DR4BOThe Assassination of Jesse James by the Coward Robert Ford5.996.846.846.987.9898-100%4956152.853.9995-97%88003.320.92.422.420.010.030.070.15pounds0.6inches7.5inches5.3inchesFALSEFALSENoDataNoDataNoData
B00G4RG71Y'012569763739Jesse Jamescut$1.90 ASSASSINATION OF JESSE JAMES1Book2.670.7741%5427213072? Merchant No Match & FBA blankY5.98NoNoData5.98B00G4RG71YASSASSINATION OF JESSE JAMES5.989.9314.1214.98NoDataNoData1.993.9995-97%169943.3102.412.390000NoData0NoData0NoData0NoDataFALSENoDataNoDataNoDataNoData
B000HT38C6'012569678385Triple Feature- John WayneCUT$2.25 "The Big Stampede / Ride Him, Cowboy / Haunted Gold"1DVD4.592.34104%414348.243527Amazing Prime ExpressFBA matchnow24 hours8.356.98No8.246.98B000HT38C6"The Big Stampede / Ride Him, Cowboy / Haunted Gold"6.986.987.748.2498-100%324552.993.9998-100%148533.651.242.422.420.010.030.070.15pounds0.6inches7.5inches5.3inchesFALSEFALSENoDataNoDataNoData
B002FG9N8W'850928002057Blood Ties$1.00 Blood Ties1DVD1.750.7575%3142684.9925CV Trading CorpFBA matchnow24 hours4.9Yes4.95.45B002FG9N8WBlood Ties4.955.455.4898-100%515741.463.9998-100%165563.150.732.422.420.010.030.070.15pounds0.6inches7.4inches5.3inchesFALSEFALSENoDataNoDataNoData
B0052T1EF4'741952695691The Bangbang Club$2.00 The BangBang Club1DVD2.260.2613%915485.755235CV Trading CorpFBA matchnow24 hours6.094.98No5.754.98B0052T1EF4The BangBang Club4.984.984.984.995.645.7598-100%515740.993.9995-97%27793.280.862.422.420.010.030.090.18pounds0.58inches7.1inches5.42inchesFALSEFALSENoDataNoDataNoData
Google