We are looking to bring the following data into Google Sheets via Amazon's API's:
1. Our current selling price of the ASIN/SKU
2. Number of our sales in the past 7 and 30 days of the ASIN/SKU
3. Current BuyBox Price of ASIN/SKU
4. Current Lowest Price of ASIN/SKU (include shipping fees if it’s FBM and not free shipping)
5. Does the ASIN have a BuyBox or Not of ASIN/SKU?
6. Current FBA fees of ASIN/SKU
7. Number of FBA sellers within 3% of BuyBox price of ASIN/SKU
8. Current BSR of ASIN/SKU
9. 90 Day Average BSR of ASIN/SKU
10. Is Amazon listed as a seller of the ASIN/SKU
11. Amount of inventory that is Inbound of the ASIN/SKU
12. Amount of inventory that’s checked in and available at Amazon of ASIN/SKU
13. Amount of inventory that’s moving between warehouses at Amazon of ASIN/SKU
We would like for this data to be as current as possible.
We currently have about 5,000 SKU's that we monitor.