Em Andamento

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


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


* 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


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

Web environment

* We currently run PHP 4 & MySQL 4.1

Habilidades: Comércio eletrônico, PHP, Carrinhos de compras

Ver mais: table customer, php script to export mysql database to pdf, mysql customer database, customer table, orders country oscommerce, screenshot to pdf, 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, export button, order number mysql

Acerca do Empregador:
( 11 comentários ) Manchester, United Kingdom

ID do Projeto: #527653

Premiar a:


I can start right now.

$70 USD em 1 dia
(82 Avaliações)

12 freelancers estão ofertando em média $119 para este trabalho


check pm, please

$120 USD in 2 dias
(308 Comentários)

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

$180 USD in 2 dias
(252 Comentários)

See PM for details. Thanks

$100 USD in 2 dias
(242 Comentários)

Glad to work. Thank you.

$110 USD em 1 dia
(319 Comentários)

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

$100 USD em 1 dia
(107 Comentários)

Ready to start

$120 USD in 2 dias
(286 Comentários)

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

$100 USD em 1 dia
(41 Comentários)

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

$200 USD in 2 dias
(52 Comentários)

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 dias
(17 Comentários)

Please Check your PMB. Warm Regards Anurag Seorobots

$150 USD em 1 dia
(2 Comentários)

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 Mais

$80 USD in 5 dias
(0 Comentários)