Oscommerce: Display customer order total by country reports
Orçamento $30-250 USD
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
Concedido a:
12 freelancers estão ofertando em média $119 para esse trabalho
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
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