[SOLVED] How to add the invoice number to the orders grid ?

[luda]

I like to add to the orders grid a column with the number of the invoice "FA0000123".

Can you help me ?

[tuk66]

Try to start with adding another array item to $this->fields_list field (between 'osname' and 'date_add') in /controllers/admin/AdminOrdersController.php.

 

It could be something like this:

        'invoice_number' => array(
            'title' => $this->l('Rechnung-Nr: '),
            'width' => 50
        ),

(not tested)

[vekia]

hello

 

it will work, but it will show only "1", "2", "3" instead of the same number on invoice (0001, 0002, 0003 etc.)

anyway, it works

[luda]

Thank you, you are great.

[fprabel]

I'd like to ask a slightly different question. I know how to add or modify a column in the orders grid by editing /controllers/admin/AdminOrdersController.php.

 

What I need (for my accountant!) is to display multiple rows for the same order in the orders grid:

- one row with a number of fields (date, customer, order number etc) + the net total for products

- one row with a number of fields (date, customer, order number etc) + the shipping total

- one row with a number of fields (date, customer, order number etc) + the tax total

- one row with a number of fields (date, customer, order number etc) + the grand total

 

Any idea on how to display multiple rows for the same order? Some code to change in AdminOrdersController.php I guess?

 

I would need to display all the orders and 4 rows per order

So if there are 100 orders, display 400 rows total

 

Then I am going to export all 400 rows to a csv file.

[tuk66]

An easiest way could be to create a custom CSV export. You shouldn't need to display all data on the page.

[vekia]

topic closed, if anyone has got question not related to main case in this thread - open new topics please.