I have Opencart ... I need order tracking information from this file [login to view URL] imported into my store and then an email then sent to the customer. Daily I get a [login to view URL] file placed on my server. Using a Cron Job I need that data updated into the customers history file and an email with the tracking info sent to the customer. The email should look similar to the email that the customer already receives when they place an order. But the tracking info should be added.
The .csv File has an OHORD (Order Number Field) which should be used to UPDATE the customers order history file.
Note- Only Bid If u are able to do it in next 4 hrs...AND complete this weekend.
The customers Email is UPDATING the customer that their order has been shipped along with the shipping information.
Attached is a file with the fields. The [login to view URL] file is on my server. ([login to view URL]) The OHORD is what you can use to find the order that should be updated. The pink and green fields should be added to the system. Let me know if you have any questions.
BTW, I already had someone do this project and it kind of worked but my server crashed. You can either fix what they did or start from scratch.
This MUST BE DONE BY MONDAY 9am PST.