Get Product Stock Level via API Banggood.com

Get Product Stock Level via API Banggood.com

Task:
Retrieve stock levels of products using Banggood API service. Products will be based off an excel spreadsheet and the output should be populated into the same spreadsheet. Require stock levels for 2 warehouses; China and USA. The solution will also allow us to schedule the task/script automatically each day (Windows 10)

Requirements:
NOTE: We need to update stock levels for 20,000 – 30,000 items each day so the solution provided must be completed in less than 5 hours of processing time. We are on fibre and our current download speeds are 100mb/s which is enough internet speed for this task.
We need the solution to have the option to run the process manually and also be scheduled to run in the background each day or specified time. We are using Windows 10.


1) Requires login to BG API webpage (we will provide this)

Get Stock API
https://api.banggood.com/index.php?com=document&article_id=25



2) We will provide product ID for retrieving based from an excel spreadsheet


3) Retrieve stock levels for China and USA warehouses. You should receive 3 types of results, a value (instock), 0/nil (out of stock), Product ID does not exist! (discontinued product)

Example