Closed

OpenCart MySql Export To Xls file, attach to mail and send.

This project was awarded to valleysoftware for $135 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30-$200 USD
Total Bids
5
Project Description

What i need is an excel file to be made everytime a cronjob is run. This file needs to be send as an attachment to an e-mail adress (1 or more) specified.

This export needs to check all the orders of an OpenCart shop of the previous day (date of today - 1), and export data of this into excel file.

Mark: This is no out of the box opencart customisation!
There is an module made to enter shipping adress per item in shopping cart.

The first excel file needs to be made into specific format, and contain the shipping adresses per item from the custom module! (see attachment at this post!)
Some database entries may need to be combined into 1 excel cell (for instance date and time or street and house number). also some cells will need to be left empty. This excel file needs to contain the shipping adresses of the orders. It has a fixed look (see attachment), that needs to be created, also it must be an XLS file. (note, also column "gewicht" needs to come from mysql database, weight is there in grammes and need to be in XLS file in Kilogrammes.). On bottom row these values count up. Column "colli aantal" is allways 1, but also counts up at bottom row.

For this Excel file there is need to:
-enter e-mail adress(ses) to send file to
-enter range of zipcode of only export these orders.
zipcode in Holland are all like this: 1234AA, 5678BB, 9999ZZ, etc.
What i need in script is to select : only export orders with zipcode from 1000 up untill 1999 for instance.


A second Excel file needs to be created with the billing adresses of the orders of the previous day (date of today - 1), and export this into excel file.
Also in this excel file there must be information about how many items, and some of the specifications of that items. Those specifications are filled in by the customer in the custom shipping adress per item module, so not standard from OpenCart. An example of this excel file will follow asap.
For this Excel file there is need to:
-enter e-mail adress(ses) to send file to
-enter range of zipcode of only export these orders.
zipcode in Holland are all like this: 1234AA, 5678BB, 9999ZZ, etc.
What i need in script is to select : only export orders with zipcode from 1000 up untill 1999 for instance.


It's ok if i have to enter zipcode ranges in the php script, as well as the e-mail adresses. Scripts will run daily at 02:00 hour or something by cronjob. Must be possible to run the script twice (rename, with 2 different zipcode ranges or e-mails).

I will specify what database entries need to go in what excel cells.
Second attachment with example of excel file will follow asap.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online