Attached CSV file into MySQL
This project received 17 bids from talented freelancers with an average bid price of $251 USD.Get free quotes for a project like this
Project Budget$100 - $300 USD
The project consists of writing code to do the following:
* Monitor a dedicated email address on our mail server for incoming messages
* Each message will have a CSV file attached to it with an agreed format, containing an order. The data in the CSV file needs to be inserted in an order system that is written in PHP and MySQL.
* If an order contains more than one product, it will be emailed in multiple messages, one for each different product but each time with the same order number. This means that before inserting an order into the order system, the code has to check if means inserting a completely new order or adding an order line to an already existing order.
* Some of the order attributes such as SKU and shipping method need to be mapped to the corresponding values in the order system.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online