Amazon Web Services PHP API Script

IN PROGRESS
Bids
11
Avg Bid (USD)
$1044
Project Budget (USD)
$250 - $750

Project Description:
We sell many of our products on Amazon as well as our own PHP e-commerce website. Right now, when we receive a non-fulfillment order on Amazon, we manually enter the data from Amazon into our main website for order processing and record keeping purposes. Once we enter the order into our system, we save our internal order number to the Seller Memo section on the order details section on Amazon. That's how we know that we have already entered the order into our system. Once we process and ship the order, we then go back to Amazon to update the tracking number. We need to automate this process as it's starting to become a time sink.

Please note that I code our LAMP e-commerce site but don't have the time or energy to get into the AWS system to get this done in the short term so I need some assistance. Unless there is a better idea, here's what I would like to do that I believe will be the easiest and most cost effective solution. For now, I just want to automate the order entry part of the process.

For the script, I will run it as a cron job a few times a day. What I need your part of the script to do is loop through and return the order details for all the non-fulfillment orders from the date the script runs. I will then insert my code inside that loop to check and write any new orders to our system. My part of the script will return our order number which your script will write back to the seller memo section of the order on Amazon. That's it. For now, we will manually confirm the shipments and update the tracking numbers on Amazon. Eventually, I'll want a second script to automate that process also but right now, I just need the first part.

Here is the flow of the code:
Your script pulls the orders and details.

The Amazon order details I need for my part of the script are as follows:
- order number
- items total $
- order shipping $
- grand total $
- the shipping address broken up into...
-- full name
-- street address line 1
-- street address line 2 (if applicable)
-- city
-- state
-- zip code
-- phone number

With this information, my part of the script will create the new order if it's not already in our system

Then, I need a loop of the products for this Amazon order so I can write that information to the order content in our database.
For the products, I need the following data returned...
- Product name
- Quantity
- Merchant SKU
- Price
- ASIN

My part of the script will write that data to our database and then return our order number to your last part of the script that will take that order number and write it back to the Seller Memo section of that applicable Amazon order.

That's it. The only hiccup I foresee is that some Amazon orders do not post to our Amazon account until the day after so you might have to grab the orders from the last 48 hours from the date of the cron job so no orders slip through the crack. Of course, the best way would be to check for any unshipped orders that don't have our order number in the sellers memo but I'm not sure that is an option.

Regardless, this should be fairly painless for someone with AWS experience. Other than the details discussed above, we may have to discuss error handling so we're on the same page. Everything else should be fairly straight forward. This must be written in PHP.

Additional Project Description:
12/31/2011 at 20:25 IST
After some feedback here is the new flow of how I would like work the code.

I need your script to loop through and return the following variables so I can insert the new order into our system (if it does not already exist)

- Amazon order number
- customer full name
- shipping address line 1
- shipping address line 2
- shipping city
- shipping state
- shipping zip code
- customer phone number

If this generates a new order in our system, I then need your script to loop through the items in that order so I can transfer that information to our database. I would need the following variables for each item in the order.

- Product name
- Quantity
- Merchant SKU
- Price
- ASIN

From this price and quantity information, I can derive the order subtotal. I would also like to retrieve the shipping charge AND/OR the order total so I have or calculate the order sub-total, shipping charge, and grand total.



12/31/2011 at 20:45 IST
Just a clarify, I am dropping the seller memo part of our request. After thinking about it, I have no need to update the seller memo. I just need the data as outlined above.

Skills required:
Amazon Web Services, PHP
Hire vtgames
Project posted by:
vtgames United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 5000
in 40 days
$ 2000
in 30 days
$ 600
in 15 days
$ 400
in 5 days
$ 400
in 2 days
$ 480
in 5 days
$ 350
in 4 days
Hire softwarevamp
$ 399
in 7 days
$ 500
in 15 days
Hire herrybrown
$ 600
in 10 days