Jump to content
Sign in to follow this  
Robin Somes

Adding new columns to Dashboard: Orders page, and exporting data

Recommended Posts


1: Adding columns
Is there any way to add a couple of extra columns into the Orders summary page? When I'm doing the monthly reckoning for our accounts, this is the most useful page to get the information from, since the existing columns: Order Number - Customer - Status - Date - Total are all items I need.

What would be really great would be additional columns showing which payment gateway was used (in our case, either SagePay or PayPal), and how much VAT, if any, was included.

Currently, I have to open each order individually, and check the gateway and VAT amount, which soon gets boring.

The Transaction Logs page does at least show me which gateway was used - but doesn't give the customer name or order status.

2: Exporting

If I could export the information from the Orders page as a CSV, it would be superb, because with the two additional columns it would be exactly what I require, no more, no less.

3: Alternatively...

If the Sales Report function could include an indication of the gateway used for each sale, that too would fulfil everything I need - and it's already exportable.

[EDIT: I now see that the data in the exported version of the Sales Report do include VAT, Gateway and many other things besides; what's seen online is a summary only.]

Any chance?

TIA

Robin

Image1.jpg

Edited by Robin Somes

Share this post


Link to post
Share on other sites

In the admin template file orders.index.php, near the top, is a table structure. Add a <td> with the heading "Gateway", and a matching <td> with {$order.gateway}. Do the same for Tax and {$order.total_tax}.

Share this post


Link to post
Share on other sites
9 minutes ago, bsmither said:

In the admin template file orders.index.php, near the top, is a table structure. Add a <td> with the heading "Gateway", and a matching <td> with {$order.gateway}. Do the same for Tax and {$order.total_tax}.

Perfect, many thanks.

Share this post


Link to post
Share on other sites
47 minutes ago, Robin Somes said:

Perfect, many thanks.

I can confirm I've just implemented that change, and it works perfectly. Thanks again.

R

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...