Project Detail

Oscommerce: Display customer order total by country reports

Oscommerce: Display customer order total by country reports is project number 527653
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: oscworker

Budget: $30-250

Created: 10/13/2009 at 15:31 EDT

Bid Count: 12

Average Bid:
$ 119

10/18/2009 at 15:31 EDT

Project Creator: khime
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (7 reviews)

Description

We run OsCommerce site and we need a report to see how many sales are generated by each country.

We require a report script written to generate sales filtered by date and sorted alphabetically ascending by country.

Please see attached PDF for mockup screenshot of the data displayed

Functions

* Filter results by [date from | date to] -> Enter date as text in UK format DD/MM/YYYY
* Date to have a drop-down javascript calendar date selector also so can enter date this way
* APPLY button: so the results table do not update until apply is clicked
* Export to CSV function. Exports the current data into a CSV file

Table Data

* Country: Display the country names as stored in our database (display alphabetical order)
* Total number of orders (we disregard the number of items purchased)
* Total ex VAT (sub total ex vat)
* Total inc VAT (total price paid [item totals + tax + shipping costs,etc)
* Average Order value (total price paid (INC VAT) divided by total number of orders)

Notes:

* If a country has no sales we still display the results but zero values for all the totals
* For some countries there will be no VAT charged so the total ex VAT will be the same as total inc VAT

Access

* put a link to php file in admin group -> reports

Web environment

* We currently run PHP 4 & MySQL 4.1

Additional files submitted:
report-display country totals.pdf

Report Violation

Job Type

See more: csv file, paid inc, report script, web environment, zero values, country names, filter results, tax shipping, yyyy, shipping costs, alphabetical order, php 4, screenshot, amp

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

110

1 day

10-13-2009 18:08 EDT

9.7878/10
(278 reviews)

Glad to work. Thank you.

wildCat

120

2 days

10-13-2009 18:43 EDT

9.9888/10
(178 reviews)

check pm, please

kagg

100

2 days

10-14-2009 04:51 EDT

9.916/10
(119 reviews)

See PM for details. Thanks

sristerweb

180

2 days

10-13-2009 15:39 EDT

9.9341/10
(91 reviews)

Requirement is very clear and very eager to work on it. Kindly check PM for more details

saiSoftIndia

120

2 days

10-14-2009 02:10 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(86 reviews)

Ready to start

WSTIBS

100

1 day

10-14-2009 00:19 EDT

9.6923/10
(52 reviews)

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

oscworker

1 day

10-14-2009 03:27 EDT

9.9474/10
(38 reviews)

I can start right now.

oscommercein

200

2 days

10-14-2009 00:48 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Hi , We are interested , Please check PMB...

mmysoft

100

5 days

10-13-2009 21:11 EDT

9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10 9.8/10
(5 reviews)

Hi you, Let do it effectively I have read your requirements carefully, so that I would like to join into this project. Based on my experience, I believe that we will reach the best results. Thanks you so much

nasty

100

1 day

10-13-2009 16:21 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

We are experts in osccommerce, you requirements are clear and we are ready to start work.

seorobots

150

1 day

10-14-2009 02:18 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Please Check your PMB. Warm Regards Anurag Seorobots

jaifreelance

5 days

10-14-2009 00:48 EDT

(No Feedback Yet)

Dear Sir, We are having more than 8 yrs of experience in IT [web development] and expertise in Ecommerce websites + payment gateways.. You can visit the following ecommerce websites for your consideration: http://www.cafegadgets.com [Customized payment options] http://www.buysamsungmobile.com [Customized payment options] http://www.selenegems.com http://www.Quikdrawers.com http://totstowntoys.co.uk http://crazypricing.my http://crazypricing.com.sg/ http://sambhavrings.com http://www.dubairacingclub.com/ http://www.crazypricing.in http://blogrankers.com/ http://www.bridalsuperstore.com/ http://bags-of-taste.co.uk/ www.dubaiinternetcity.com http://www.qaieschool.com/ http://www.ads2book.com/ Other websites: http://www.impetus.com http://www.clear-trail.com I will assure you for your assignment and deliver you the quality of work.I am very pleasure if I can get a chance to work with you. I am hoping and hearing from you. Thank you very much. Thnx Jai Sachdev

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.