Find Jobs
Hire Freelancers

Get Reports from AMAZON with API using VBA and EXCEL - 01/05/2023 04:58 EDT

€30-250 EUR

Completed
Posted about 1 year ago

€30-250 EUR

Paid on delivery
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
Project ID: 36496460

About the project

9 proposals
Remote project
Active 1 yr ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
€0 EUR in 7 days
5.0 (6 reviews)
4.5
4.5
9 freelancers are bidding on average €282 EUR for this job
User Avatar
Hello, Greetings from India ! I am an experienced freelancer with expertise in MS Excel and VBA. I have completed more than 400 + excel project in last 5+ years and have more than 300+ happy customers globally. I have seen your project requirements of Excel data entry work. I would be happy to assist you on this project. I assure you to deliver a high-quality project delivered on time. Let's discuss over chat and we can start working together. Awaiting your positive response. Thank you Khushi, India
€120 EUR in 5 days
4.8 (328 reviews)
7.3
7.3
User Avatar
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to get Reports from AMAZON with API. I provide complete ranges of solution for your Excel, Custom Formulas / Functions, Pivot Table, Dashboards, VBA and Macros Automation need. I can also provide similar past Excel work example before being hired. Services we offer: ✔️ Custom Formulas ✔️ VBA Macros Automation ✔️ Vlookup / Hlookup ✔️ Countif / Countifs ✔️ Converting CSV files in to specific format. ✔️ Export & import of Excel files in to specific excel file ✔️ Visual Basic User Forms, for user interface designing and dashboards ✔️ Interactive Pivot Tables and Graphs. ✔️ Converting Excel to PDF or CSV ✔️ Complete Dynamic VBA Macros Dashboards ✔️ Removing Duplicates from the File ✔️ Data Entry with automated process As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team
€750 EUR in 10 days
4.7 (56 reviews)
6.8
6.8
User Avatar
Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
€180 EUR in 3 days
4.8 (167 reviews)
6.0
6.0
User Avatar
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Excel services include the following: Financial modeling: As an ACCA qualified professional, I have extensive experience in creating financial models in Excel. I can help you create complex financial models, including cash flow projections, discounted cash flow analysis, and financial statement analysis. Data analysis and visualization: I can perform various types of data analysis, including statistical analysis, data modeling, and regression analysis, and visualize the results using charts and graphs. I have worked with large data sets and can help you summarize and present your data in a meaningful way. Reporting and dashboards: I can create custom reports and dashboards to help you visualize and analyze your data, and make informed decisions based on the insights gained. I can also design interactive dashboards that allow you to explore your data in real-time. My development process includes an initial consultation to understand your requirements and objectives, followed by designing and implementing customized solutions to meet your specific needs. I am committed to delivering high-quality services and ensuring customer satisfaction. Please don't hesitate to contact me if you have any questions or would like to discuss your project further. Best regards,
€180 EUR in 3 days
5.0 (33 reviews)
4.7
4.7
User Avatar
Hi, I have read the requirement and understood, we can discuss more for detailed requirements. My Profile: 1. I have 11+ years of experience with SP Online/2019/2016/2013/2010 2. I have 3+ years of experience with power platform Power automate, PowerApps. 3. Experience with creating SharePoint Intranet Portals with modern templates and customizing same. 4. worked with different modern webparts: - Summary Links, Videos, News, Site Activity, Photo Gallery, Weather, World Clocks, Hero Webpart, Ms. Forms, Events 5. Creating templates with Site Design and Site Scripts, 6. Customizing lists/libraries with JSON Formatting 7. Permissions Handling and Access to internal and External users 8. Document Management with Approvals, Versioning, grouping into folder, sync with OneDrive etc. 9. SharePoint Migrations with tools like Sharegate, MS migration tool etc. 10. Worked with Nintex Forms and flows 11. Experience with SPFx, ReactJS, JavaScript, jQuery, Typescript, REST Apis, Webhooks etc. Looking forward for your response. Regards, Chandrashekhar
€200 EUR in 8 days
5.0 (2 reviews)
1.6
1.6
User Avatar
Hi there! My name is Ranjith and I'm a data entry specialist with extensive experience in Excel and other related applications. I have the required skills to help you with your project. I understand that you need reports from Amazon API using VBA and EXCEL, and I believe I am the perfect fit for this project. My expertise lies in data entry which makes it easy for me to separate sheets with credentials in programm files, organize them by client name in columns 2, get authorization at Amazon with Selling Partner API and save the result to a CSDF sheet named settlementreport. Additionally I ensure that no report is duplicates so that we get all reports in the timeline exactly when they should be. I also make sure that all reports are completed within the timeline required. This is important to prevent any missing reports from happening. I would be delighted to discuss this project further with you if given the opportunity. Please don't hesitate to contact me if you have any questions or would like more information about my skills and experience.
€30 EUR in 2 days
4.8 (5 reviews)
0.7
0.7
User Avatar
Hello sir, Excel VBA expert. I can do it. With 6+ years of experience in this field. I have read the guidelines of your work. you believe that I can provide you with the best quality work . My buyer is so important to me. So please discuss it over chat. Thank you Best regards Robin
€200 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Düsseldorf, Germany
5.0
5
Payment method verified
Member since Mar 12, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.