In Progress

Oscommerce: Display customer order total by country reports

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

Skills: eCommerce, PHP, Shopping Carts

See more: table customer, mysql customer database, customer table, orders country oscommerce, uk tax, sales order, order, mm, exports, display, admin ex, update mysql csv php, mysql calendar table, pdf text generate, mysql selector, table filter javascript, access order, sales report access, php script mysql export, display mysql, filter amp, order number mysql, javascript order function, access notes database, number selector javascript

About the Employer:
( 11 reviews ) Manchester, United Kingdom

Project ID: #527653

Awarded to:

oscworker

I can start right now.

$70 USD in 1 day
(82 Reviews)
6.7

12 freelancers are bidding on average $119 for this job

wildCat

check pm, please

$120 USD in 2 days
(308 Reviews)
8.3
sristerweb

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

$180 USD in 2 days
(252 Reviews)
8.1
kagg

See PM for details. Thanks

$100 USD in 2 days
(242 Reviews)
7.9
netsolve

Glad to work. Thank you.

$110 USD in 1 day
(319 Reviews)
7.4
WSTIBS

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

$100 USD in 1 day
(107 Reviews)
7.4
saiSoftIndia

Ready to start

$120 USD in 2 days
(286 Reviews)
7.2
nsweb

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

$100 USD in 1 day
(41 Reviews)
6.5
oscommercein

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

$200 USD in 2 days
(52 Reviews)
6.4
mmysoft

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

$100 USD in 5 days
(17 Reviews)
4.7
seorobots

Please Check your PMB. Warm Regards Anurag Seorobots

$150 USD in 1 day
(2 Reviews)
3.4
jaifreelance

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: htt More

$80 USD in 5 days
(0 Reviews)
0.0