Closed

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, audit php code, audit file, audit details, audit company, need audit, audit process, warehouse system, seed, process map, php opencart, php mysql imap, order process

About the Employer:
( 0 reviews ) Rotterdam, Netherlands

Project ID: #1085820

10 freelancers are bidding on average $805 for this job

p4provider

please check pmb for more details,Thanks

$750 USD in 20 days
(48 Reviews)
6.7
netexbd

Please check PM

$550 USD in 15 days
(23 Reviews)
6.6
Magjoom

Will be done Sir, lets start if you want to

$1500 USD in 20 days
(20 Reviews)
5.9
stuntrider

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

$500 USD in 3 days
(17 Reviews)
4.8
Vikiztech

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

$700 USD in 5 days
(0 Reviews)
0.0
kamachi2009

Please check in PMB.

$750 USD in 4 days
(0 Reviews)
0.0
stevejohn2

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)
0.0
hasan4368

https://www.odesk.com/users/~~641393ea439de09c

$500 USD in 7 days
(0 Reviews)
0.0
pioneeringesol

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

$1500 USD in 19 days
(0 Reviews)
0.0
aniwebdesigns

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)
0.0