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.
11 freelancers are bidding on average $1044 for this job
we already did that , along with some other complex features as repricing module, etc. If you are able with a serious budget for a top quality product please do consider my offer, check pmb for a screenshot.
Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp [http://bit.ly/rVWw63]