Get Reports from AMAZON with API using VBA and EXCEL
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. Report name willl be delivered later to you. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no duplicates.
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. Report name willl be delivered later to you. Save result to CSDF sheet "VAT-Transaction-Report". Be sure it is complete and no duplicates.
Good luck