Contributions

use this one instead. Just copy and paste the php file

Improved Display and CVS download file:
1. group orders by order id
2. add customer name, billing address, shipping addres, model, qty, Product Name, comments,

Improved selection of orders Display Type:
1. Create CSV file
2. Print to screen in table format
3. Adding heading to the CSV / Html output
4. Sorting & group orders by customers id (name)
5. Link on the order number, from the Html output page direct to the customer order Details.

Good Luck :-)

Replaced hardcoded tables with DEFINED tables.

At the bottom of this file there is instructions how to output the result in the browser, usefull while setting up the script! Easy to read and you don't have to download the xls.

Full package.

Addition or readme file with installation instructions which will put a link in your reports section of Admin in order to access the csv.

No file, but there was a missing PHP tag which meant the Order Status query was failing. To fix change line 82 to

<?php

Fixed file attached

Not all orders have sales tax associated with them. If an order without sales tax follows one that does, then the tax is entered for the previous order. To fix this, I had to reset the variable $Order_Tax. The correction resides on line 203 of the code, and is simply: $Order_Tax = '0';

Attached is the full version with the one additional line to correct this bug.

Much more flexible now. No more DB errors.

Works with osCommerce 2.2 ms2

This script exports all order data (customer data products, coupons...) to a csv file. This script can be adapted with some php knowledge but is still hard coded. You are welcome to add some extra features!

Works with osc 2.2 ms2 and probably also with ms1.

mightyx