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:
first name
last name
email
company name
st address
more address (if applicable)
post code
city
state
country
telephone
fax (if available)
For canadian customers (146 orders) the 3 columns for orders would be:
GST
subtotal
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.