You have chosen to sponsor your bid up to a maximum amount of .
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)
-- 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
- Merchant SKU
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
- Merchant SKU
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.