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

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

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:

oscworker

I can start right now.

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

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

wildCat

check pm, please

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

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)
8.1
kagg

See PM for details. Thanks

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

Glad to work. Thank you.

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

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

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

Ready to start

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

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

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

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

$200 USD in 2 dias
(52 Comentários)
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 dias
(17 Comentários)
4.7
seorobots

Please Check your PMB. Warm Regards Anurag Seorobots

$150 USD em 1 dia
(2 Comentários)
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 Mais

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