Monday, 21 July 2014

web based FBA calculator tool

While working on few Excel based projects, I found that different versions of Excel and different versions of Windows operating system causes many issues. Application might be working with Excel 2010 may not work with the Excel 2007 and vice versa. I had to spend lot of time in fixing the compatibility issues and it causes lot of frustration to my customers too. This led me to develop web based application to calculate FBA costs. I am going to explain how this tool works as below:

This require following as the input

1. Text file should have two columns.

  • First column should be the ASIN of the products for which you want to calculate the costs. Each ASIN should be on the separate line in the text file.
  • Second column should be the Selling Price of that ASIN


2. Click on the "Choose File" button and click on the input file which you want to upload.

3. Click on "upload" to upload the file.

4. Select the country from the "Amazon Sites". The default is US.

5. Click on process button. The output will be shown as below:



The output will contain, ASIN, Selling Price , Total FBA Cost( including commission fees), Lowest price and Sales Rank of the product.

6. To down load the output in a file, click on Export button. The output would be stored in a CSV file format which can easily exported to tools like Excel.

This tool is available on the subscription basis.

Subscription Fees is $20 per month ( unlimited usage)

 For registration, please contact me via email or skype.
My contact details are as follows:

email - harjit.harjit@gmail.com
skype - developersingh

Sunday, 30 March 2014

Excel FBA calculator for Amazon US / EU

Amazon FBA Merchants!!! here is good news for you...


We have developed various excel based tools  which will help you in managing your inventory and product prices.

One of my tool is FBA calculator -As every merchant knows Amazon has provided the FBA tool which is available at
https://sellercentral-europe.amazon.com/gp/fba/revenue-calculator/index.html/ref=xx_xx_cont_xx/276-7588416-9181639?ie=UTF8&lang=en_US

This helps merchants to know the fulfillment cost of the products in a particular country. But this tool takes one ASIN as the input.

Our FBA tool can work on all of the products in your inventory at once. You can load all your inventory in excel and this tool will calculate the FBA cost for all of the products given in the excel.

How this tool works !!!

1. open the excel file and input the following data in first three columns - ASIN, country code and price as shown below


2. use formula =getFBA(<asin column> ,<country column> ,< your selling price>)   to get the final price of the product after deducting the fulfillment cost and commission in case it is fulfilled by Amazon.


3. use formula =getFBM(<asin column> ,<country column> ,< your selling price>)  to get the final price after deducting the Amazon commission provided this item is fulfilled by the merchant himself.




Please feel free to contact me at

skype id - developersingh
email id - harjit.harjit@gmail.com