I have Opencart ... I need order tracking information from this file [url removed, login to view] imported into my store and then an email then sent to the customer. Daily I get a [url removed, login to view] 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 [url removed, login to view] file is on my server. ([url removed, login to view]) 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.