Opencart Order Process

We want to use [url removed, login to view] which is an open source php/mySql shopping cart.

Our goods are stored in a warehouse which is managed by another company. We need to email to them each day a .csv file which contains the order made on the shop, with the customer details and products ordered.

Development Work Required:

We require a tool to build the CSV file from a MySQL database, email it to the fulfilment warehouse and update the MySQL record to show the order has been sent to the warehouse.

This application can either be a Opencart Extension (so integrated with the cart) or a separate app which can run as a service on a IIS/Windows server.

Detailed Requirements:

1. Select DB tables/fields for inclusion in export

2. Be able to apply a filter to any field (using equals, if, and, or configurations)

3. Be able to define the CSV Colum header name and order for export, so map the MySQL field (this is to enable the CSV file to be imported in to the warehouse ordering system, the Colum headers need to match their defined fields)

4. Be able to add a column header and set/fix the data in each record (we need to be able to seed each record with a code which identifies the order is from us)

5. Be able to select which MySQL field is updated to show the export has been done, and what it updates with.

6. Login in to an IMAP server to send email with CSV file attached.

7. Set the email address to send to, with CC & BCC, and define the CSV file naming conventions.

8. Set the From email address and email subject/body message

9. Set the frequency of the export and send (daily, weekly or number of hours)

10. If the process fails: Send export failed email with audit log attached

11. Run an txt file audit log for each step of the process

12. Run automatically as a service/routine

Skills: MySQL, PHP

See more: opencart order process, process order opencart, define order process opencart, opencart send order warehouse, opencart order database, order process opencart, cart mysql order record, opencart select mysql php, opencart process order, shopping app development, n equals, define send, data warehouse process, build a shopping cart with php and mysql, audit php code, audit of company, audit file, audit details, audit company, opencart php code export order, windows 8 app development, need an audit, audit process, warehouse system, seed

About the Employer:
( 0 reviews ) Rotterdam, Netherlands

Project ID: #1085820

10 freelancers are bidding on average $805 for this job


please check pmb for more details,Thanks

$750 USD in 20 days
(48 Reviews)

Please check PM

$550 USD in 15 days
(23 Reviews)

Will be done Sir, lets start if you want to

$1500 USD in 20 days
(20 Reviews)

I'm definitely your guy for this. Please see my private message, thanks!

$500 USD in 3 days
(17 Reviews)

Please check in PMB. I am interested in your project.

$700 USD in 5 days
(0 Reviews)

Please check in PMB.

$750 USD in 4 days
(0 Reviews)

Hi we are web technology company and we feel pleasure to assist you on your project for more detail please see your PMB Thank you Regards John

$799 USD in 7 days
(0 Reviews)

[url removed, login to view]~~641393ea439de09c

$500 USD in 7 days
(0 Reviews)

We are expert in OpenCart, See at pmb and discuss with me.

$1500 USD in 19 days
(0 Reviews)

Hi Thanks for giving us chance to bid on your project. We are AniWeb Designs Pvt Ltd established in 2009. I would like to appreciate you, that you have clear you requirement very breifly. You saying you need More

$499 USD in 15 days
(0 Reviews)