Get Reports from AMAZON with API using VBA and EXCEL - 01/05/2023 04:58 EDT
Budget: €30 – €250 EUR
Hi Everbody,
please create a Excel-sheet and VBA Modules (programm-file). We need the following fuctions:
1. separate Sheet with credentials in programm-file. As we got serveral Clients, the credentials have to be organized in rows per client. column 2 shows the client-specific-data-file (csdf) name in the same folder as program file
2. authorize at Amazon with Selling Partner API
3. get the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE from Amazon
4. save the result to csdf sheet "settlementreport"
5. ensure not report are duplicates. ensure we got all report in the timeline, not timeperiod is missing
same for a VAT-Report from AMAZON: GET_VAT_TRANSACTION_DATA. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no duplicates.
Initially load the reports for the last 360 days. Build a UPDATE - Function, which looks for the latest reports.
Good luck
please create a Excel-sheet and VBA Modules (programm-file). We need the following fuctions:
1. separate Sheet with credentials in programm-file. As we got serveral Clients, the credentials have to be organized in rows per client. column 2 shows the client-specific-data-file (csdf) name in the same folder as program file
2. authorize at Amazon with Selling Partner API
3. get the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE from Amazon
4. save the result to csdf sheet "settlementreport"
5. ensure not report are duplicates. ensure we got all report in the timeline, not timeperiod is missing
same for a VAT-Report from AMAZON: GET_VAT_TRANSACTION_DATA. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no duplicates.
Initially load the reports for the last 360 days. Build a UPDATE - Function, which looks for the latest reports.
Good luck