I need some records from 2 OsCommerce stores pasted into excel in a hurry.
103 Canadian Customers in one sheet. 396 US customers on a separate excel sheet.
the columns for customers would be:
more address (if applicable)
fax (if available)
For canadian customers (146 orders) the 3 columns for orders would be:
discount (if applicable)
For US customers (137 orders) the column for orders would just be 'total'.
The orders need to be on the line for the customer who made the order. So for customers who have more than one order everything about that customer and their orders is on the same line.
so a total of 499 customers and 283 orders to copy and paste.