Need to Export Orders

Posts: 139
Joined: 08/22/2007
Spreading the word - Ubercart for president.

We will pay.

We need to be able to export orders into the format found in the attached file. We are running Ubercart 1.3.

AttachmentSize
test_order-export-rumble-tuff_(1).xls20.5 KB
Posts: 5617
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

I'd hate to put someone (myself included) out of a job, but have you checked out http://drupal.org/project/uc_edi? I can't open the .xls right now, but the EDI module can create CVS exports that should be "openable" in Excel. Sorry if that's a red herring.

Posts: 139
Joined: 08/22/2007
Spreading the word - Ubercart for president.

Hey Ryan, thanks for the reply. We are currently using the EDI module and it works great, its just now quite flexible enough. We need to be able to export column headers and orders in a specific format. I've tried configuring EDI to accommodate this but haven't been able to get the format we need.

I've attached a screen shot of the Excel file.

AttachmentSize
excel-capture.PNG54.83 KB