Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

E-Commerce Modules

Discuss about the various e-commerce modules available:
Ecommerce, SS Shop, SilverCart and SwipeStripe
Alternatively, have a look the shared mailinglist.

Moderators: martimiz, Nicolaas, Sean, frankmullenger, biapar, Willr, Ingo, Jedateach, swaiba, simon_w

Editing the export order to csv functionality


Reply

4 Posts   1312 Views

Avatar
IDOLYZ

23 March 2011 at 9:05pm (Last edited: 23 March 2011 9:09pm), Community Member, 40 Posts

Hi,

I am building a website that requires orders to be exported into a csv file.

Has anyone modified this function to include the full order? If so, what are the files used?

I need to grab certain fields and export in a set structure for importing into an accounting program.

Any help would be much appreciated.

Cheers,
Ben

Avatar
IDOLYZ

24 March 2011 at 3:37pm Community Member, 40 Posts

I have found where the array of fields is called. It's on ecommerce/code/model/Order.php around ln 147:
public static $summary_fields = array(
   'ID' => 'Order No',
   'Created' => 'Created'
);

Add the extra fields you want in there...

Only problem I have now is getting the order items to appear on the summary list when searching for orders. Does anyone know how to do this?

Thanks, Ben

Avatar
Jedateach

28 March 2011 at 9:11am Forum Moderator, 227 Posts

Hi Ben,

I've created a new ticket here:
https://code.google.com/p/silverstripe-ecommerce/issues/detail?id=126

In the mean time, you could create a custom function that outputs the order items as a string, and then include that in the summary fields.

regards,
Jeremy

Avatar
IDOLYZ

28 March 2011 at 1:38pm Community Member, 40 Posts

Hi Jeremy,

Thanks for your reply and creating the ticket.

I have written a script that queries the database separately from the export function... basically creating my own export functionality.

It's not ideal, but works, so am happy.

Cheers,
Ben