Amazon Data Automator & Excel Reporting
Budget: $30 – $250 USD
Project Details
$30.00 – 250.00 USD
I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows:
Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Shipping Label, Shipping Cost, Grand Total, Status, Buyer Name, City Name, State, Zip Code, Tax Collection, Tax Responsible, SKU, Condition, Order Item ID, Package Type, Dimensions, Weight,<and any and all other information available is desired).
I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns listed above of data related to Sales, Orders, Products, Customers, and beyond.… Your primary task will be retrieving detailed information for reporting purposes and building me reporting and a UI(optional) that I request that contains all the data that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel.
The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing all tables and columns of data that I will need to build comprehensive, robust reporting.
Success and competition of this project is defined as:
Freelancer must provide a working solution to me.
Freelancer must demo it to me working on their side, and on my side.
Freelancer should ensure I can easily run this script or program on demand on my side, and that I am happy with the results.
Freelancer must also be experienced and proficient in Amazon Seller Central and marketing metrics. Freelancer must be experienced and knowledgeable in Amazon policies and metrics. Proficiency in working with Amazon Seller Central and marketing metrics is essential for success in this role.
Ideal Skills:
-Experience with Amazon Seller Central is a must.
-API’s
-Databases
-Data Analytics
-Data connections
-Microsoft Excel
-Coding
-Pulling in data columns above(and more if available) from Amazon API’s into Excel
-Detail-oriented, as accuracy is critical.
-Amazon Listing Optimization, Website Optimization, Amazon FBA, Customer Service, Customer Experience, Marketing, Link Building, Sales, Advertising
$30.00 – 250.00 USD
I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows:
Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refund Total, Shipping Label, Shipping Cost, Grand Total, Status, Buyer Name, City Name, State, Zip Code, Tax Collection, Tax Responsible, SKU, Condition, Order Item ID, Package Type, Dimensions, Weight,<and any and all other information available is desired).
I'm seeking a freelancer with experience in the Amazon Seller API to pull back data and metrics - all columns listed above of data related to Sales, Orders, Products, Customers, and beyond.… Your primary task will be retrieving detailed information for reporting purposes and building me reporting and a UI(optional) that I request that contains all the data that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel.
The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing all tables and columns of data that I will need to build comprehensive, robust reporting.
Success and competition of this project is defined as:
Freelancer must provide a working solution to me.
Freelancer must demo it to me working on their side, and on my side.
Freelancer should ensure I can easily run this script or program on demand on my side, and that I am happy with the results.
Freelancer must also be experienced and proficient in Amazon Seller Central and marketing metrics. Freelancer must be experienced and knowledgeable in Amazon policies and metrics. Proficiency in working with Amazon Seller Central and marketing metrics is essential for success in this role.
Ideal Skills:
-Experience with Amazon Seller Central is a must.
-API’s
-Databases
-Data Analytics
-Data connections
-Microsoft Excel
-Coding
-Pulling in data columns above(and more if available) from Amazon API’s into Excel
-Detail-oriented, as accuracy is critical.
-Amazon Listing Optimization, Website Optimization, Amazon FBA, Customer Service, Customer Experience, Marketing, Link Building, Sales, Advertising