Closed

Zen Cart Advanced Report & CSV Download

I need an Admin Module for Zen Cart [url removed, login to view] that produces advanced sales reports.

I want to be able to generate reports using the the following:

1. Date range (select start and end date from a calender

2. Order Status (ability to select multiple order statuses from the full list)

3. Shipping Country (ability to select multiple countries from the full list)

4. Product (ability to select multiple products from the full list)

option to display summary or detailed report

The detailed report to display as follows:

First display query info from above as a title, ie. This report shows sales from jan 1 2011 - jan 31 2011

Display a table with the following info:

date of sale

order number

country

number of products in order

- a sub table with the products in order, attributes of items, sale price, cost & gross profit

Sub total for each order# showing sale price, cost and gross profit

Sub total for each country showing sale price, cost and gross profit

Grand total at bottom of report showing sale price, cost and gross profit

Ability to sort by

1. order number then by country then date

2. by country and then order number then date

I will want to be able to print this out in a nice, clear to understand report.

Ability to download csv file.

The summary report should show the following:

Report Title ie. This report shows sales from jan 1 2011 - jan 31 2011

date range

total number of products shipped to each country with total sale price, cost of goods sold and gross profit.

ie.

Germany

Total Sales $10,000.00

Cost of goods sold $8,000.00

Gross Profit $2000.00

Also show grand totals to all countries selected for the date range.

Again, I will want to be able to print this out in a nice, clear and understandable report.

Ability to download csv

The cost of each product is not in the database. I will need to be able to provide the product cost somehow. I would rather not add a table to database for this. Maybe I could create a file with this information?

Please provide me the files to upload to the server. I will not be able to give you access to the server.

Skills: Linux, MySQL, PHP, Zen Cart

See more: zen cart advanced reports, download reports zen cart, zen cart download, to advanced, range query, files will not download, file status 22, generate advanced reports using csv, linux price list, csv php, create report, php download files, php upload file csv, access report summary, linux print server, php create csv file, create file table access, php table csv, sales report access, clear linux, total product price, create report database php, end cart, create report using php database, report table

About the Employer:
( 2 reviews ) Studio City, United States

Project ID: #1237767

10 freelancers are bidding on average $195 for this job

netsolve

Glad to work. Thanks

$200 USD in 4 days
(294 Reviews)
7.3
WSTIBS

we can provide quality solution with time base completion. ******* Check PM ******** Thanks

$250 USD in 6 days
(103 Reviews)
7.3
kev2me

I have 6+ years experience with oscommerce based sites and can get this made for you.

$250 USD in 5 days
(87 Reviews)
6.1
Terabi

Hi please check **PMB** for details.

$270 USD in 10 days
(37 Reviews)
6.0
PHPsoldier

########################################################################################################################## DEAR SIR, ZENCART EXPERT HERE. CAN DO IT. MANY THANKS... ################################### More

$125 USD in 5 days
(58 Reviews)
5.8
azjs

Hi, please check PM for details.

$199 USD in 5 days
(36 Reviews)
5.8
cristisst

I can do it in 1 day.

$160 USD in 1 day
(30 Reviews)
5.3
binhtq

Hi, I have much experience in Zencart. I am ready to do it. Regards.

$200 USD in 4 days
(16 Reviews)
4.7
hipper

Ready to start your project. Check your inbox for more information. Thanks!

$150 USD in 3 days
(11 Reviews)
4.6
wsdlab

5+ year php/mysql programmer.... please check pmb

$150 USD in 5 days
(2 Reviews)
3.0