Query the customers table in invoice

[mdrayner]

I have added some additional fields to the customers table that I need to

show on the invoice.

 

The address etc seems to be copied to the orders table at some point and I either want to add my extra fields to this or add a query in the invoice to reference the customers table with the extra fields.

 

Everything I have tried does not work.

 

I assume the easiest way is to add the extra query but how would I do this?

[tigergirl]

I have added some additional fields to the customers table that I need to

show on the invoice.

 

The address etc seems to be copied to the orders table at some point and I either want to add my extra fields to this or add a query in the invoice to reference the customers table with the extra fields.

 

Everything I have tried does not work.

 

I assume the easiest way is to add the extra query but how would I do this?

 

What extra fields do you need to add to the invoice?

I altered my invoice in:

admin/invoice.php

admin/includes/languages/english//invoice.php

[mdrayner]

What extra fields do you need to add to the invoice?

I altered my invoice in:

admin/invoice.php

admin/includes/languages/english//invoice.php

 

I have added some extra details to the customer account that are neccesary for the completion of the order (i.e prescription details for glasses)

 

The store owner will need to be able to see this info in the same place as the order details. The best place for this would be in the invoice.

 

I have tried amending te invoice files but they refrence the orders table. I cannot seem to add a query to the customers table to get the info I need.