Amazon Seller Central - Script to Extract Data From Amazon Using Their API's
$30-250 USD
Cancelled
Posted over 9 years ago
$30-250 USD
Paid on delivery
We need a script designed to extract specific information from Amazon using their API's
We sell products on Amazon and when a customer places an Amazon order for our product(s), we personally call that customer.
We use a service that makes outbound voip telephone calls for us, but it requires that we upload a CSV file with the appropriate call data.
We would like to automate the DAILY process of extracting the appropriate data from Amazon -and- uploading the CSV file via ftp.
We can manually download a daily text file from Amazon that contains MOST of the data we need except for the customer's phone number ... (see [login to view URL]). Also, we have another problem because this text file does NOT tell us if the customer has ordered from us before.
An important note regarding the "example_Amazon_order_download" spreadsheet: IF the buyer orders two or more items, that spreadsheet will have a separate line for each of the items ordered (even if they are identical).
Unfortunately, to retrieve the customer's phone number, we have to look up the amazon-order-id on another screen and manually copy and paste it into the CSV file (see [login to view URL])
IF the customer has ordered from us before, the order_detail_page will also display a message: "see all X number of orders from this buyer".
The first column of the "Data for Outbound Calling CRM" spreadsheet lists the exact data fields contained in the daily text file we download from Amazon, BUT please note that the ship-phone-number field is always blank.
The second column of the "Data for Outbound Calling CRM" spreadsheet lists the fields that we need to upload via ftp to the voip telephone service ... BUT please note that as described earlier, we need to get the "ship-phone-number" and the "date(s) of prior orders" from another webpage on Amazon. Regarding the "quantity-shipped" field, if the customer has ordered more than 1 of the same item, you would determine the exact quantity, insert the quantity in that field and delete the duplicate records. Regarding the "multiple items ordered Y/N" filed, if the customer order several different items, you would place a "Y" in this field.
==================== YOUR SEARCH ENDS HERE =====================
I have read your project description and I found it very interesting and challenging too. Some part of the project needs extra ordinary experience in Amazon Web Services. As a developer I have been in Amazon Marketplace and related product since last 4 years and got outstanding experience.
I am confident to carry on your project with more professional manner. I also understand the workload required in completion of the project and hence estimated the bid amount. It all most impossible one can do in your budgeted amount.
So our purpose is not just competition with other freelancers rather we have our own standard which we never compromise on them.
refer to my profile so that you know my expertise in Amazon Web Services.
My profile : http://freelancer.com/u/mehboobafridi786.html
Apart from this, I am highly experienced in amazon marketplace and have strong hold on the following.
1. Listings
2. Inventory Management
3. Variation (Child/Parent relationship) maintenance
4. Order Processing/Downloading
5. Order Acknowledgement
6. Listings SEO
7. Getting BuyBox (using my repricer tool)
8. Amazon Repricer
9. Amazon Market analysis
10. Amazon Store Setup
11. Acknowledgement Reports
12. Settlement Reports
+ much more.
See my profile for evidence http://www.freelancer.com/u/mehboobafridi786.html
I am offering my services for your project with confidence.
Regards,
Mehboob Afridi
Hi,
I have faced same problem with other employer. We found the customer phone # in some other Reports. He also needed phone number for promoting his products. Amazon got some different report types with different information for the same order. Are you FBA seller or MFN Seller? Because both will get different versions of same report type.
Amazon don't provide the background of customer. So, to achieve this, we need to store all of your old/present orders on to local database to match up with cusotmer name and phone#. Lets talk more if you are interested. I can complete the project in less than 2 days.
Sorry for long text.
I'm a 6-year experience web developer with large experience in developing integrated apps. There is an API by amazon called Amazon Marketplace Webservice that allows you to do pretty much everything you do from the web site but programatically. From my understanding to your description is that you need an application that tracks your products and get customer orders and create a cvs file with that all customer and order confirmation including the customer phone number and number of orders and upload custom information to a voip server using FTP. I'm sure there are other requirements to make the process more easily and reliable. Kindly PM for further discussion
I'm 6-year experience web developer with large experience in developing complex software applications. I understand that you need a utility application to help you decide by inputting some parameters, for how much to offer your products on different retails to get a certain net value. I need to discuss more about the project. Kindly PM me.