Need to export list of orders for PowerReviews

[markw10]

I recently began integrating the PowerReviews review system into my website and am now at the step where I need to submit an order feed. The order feed can either be pulled from my server daily or just submitted via upload anytime I need to. The reason for this feed is it is used to keep track of orders because PowerReviews has the option of sending emails to all customers who made purchases with a list of the products they purchased and also the option to click on any of them to review them. It gets this information from the feed.
Below I'm listing the way the feed needs to be set up:

Guidelines For Setting Up Your Order Feed:

1. Download your orders from your web store into a text file.
Orders with multiple products should have multiple rows in the file with the same order id. See the Sample text file for an example (To save the file to your desktop "right click/save as".)

2. Make your text file CSV (Comma Separated Values) delimited

3. Use PowerReviews field names.
Use PowerReviews field names as your column headings. Match ours in capitalization and spelling.
Alter the column names in your file to use the PowerReviews field names. Match ours in capitalization and spelling.

Required Fields:

Use field names exactly as displayed below.
• order_id :
Unique identifier for an order. Only 1 email will be sent per order
• page_id :
The same page_id that was uploaded in the product feed. Each follow-up email will include up to 10 products per order.
• first_name :
The customer first name for the particular order
• last_name :
The customer last name for the particular order
• email :
The customer email address for the particular order. Multiple orders with the same email address will be merged into a single email.

Recommended Fields
Use field names exactly as displayed below.
• order_date :
The follow-up email will be sent 21 of days after the order date unless specified otherwise on the Email Home page. If no date is provided or if the order date is more than 21 days ago, the email will be sent the following day.

Order dates should be formatted either as YYYY MM DD or MM DD YYYY
with YYYY as the year in 4 digits, MM as the month in 2 digits and DD as the day in 2 digits.
The digits can be separated by slahes(/), dashes(-) or whitespace( ).

Examples of valid order dates: 2009/11/08, 2009-11-08, 11 08 2009

For our Page ID we were using the Product ID that is used for each product that is added to the store. The Order ID will be the order number. Also, if possibly so that we can send emails out in 21 days we'd like to have the order date as part of this file.

Does anyone know if there is a way to do this? I know there are some reports options in the admin but so far I haven't found any that export a file like this. Does anyone know of a way to do this or if there is any 3rd party module that would do this?

Thank you for your help.

[pgmarshall]

It depends on how good you are at SQL ... build a query to output the required data and then simply build the data into a string ie. $content then output to a csv with something like:

header("Content-Type: application/force-download\n");
header("Content-disposition: attachment; filename=power_review_" . date("Ymd") . ".txt");
header("Pragma: no-cache");
header("Expires: 0");
echo $contents;
die();

Are you really using osCommerce v2.2? If you are, I would strongly recommend you take a look at osCmax!

Regards,