Extra details to order

[mdrayner]

I need to add some additional info from the customers table to the order so that it shows on the invoice etc.

 

I have added the extra fields to the customers table and this side works fine.

 

So far I cannot seem to find a way to query the customers table from the invoice.php file or find where

the customers details are copied to the orders table so I can add them to this.

 

Has anyone got any suggestions? This info needs to show up on the invoice as it is vital to the order process.

 

Thanks.

[bill110]

I need to add some additional info from the customers table to the order so that it shows on the invoice etc.

 

I have added the extra fields to the customers table and this side works fine.

 

So far I cannot seem to find a way to query the customers table from the invoice.php file or find where

the customers details are copied to the orders table so I can add them to this.

 

Has anyone got any suggestions? This info needs to show up on the invoice as it is vital to the order process.

 

Thanks.

The invoice makes calls to the catalog/includes/classes/orders.php

this class does the database queries for the orders. you might try there

[mdrayner]

The invoice makes calls to the catalog/includes/classes/orders.php

this class does the database queries for the orders. you might try there

 

Thanks. Have been looking here and have tried to make alterations to include my extra fields.

However, I have not had any luck with this. I still cannot work out where the orders table is updated with the customer info.

 

Also I am not sure if this is the best way of doing it.

 

Would I add a query into orders.php and then call that query from invoice?

 

I have been looking at this for so long now, I can't get my head around any of it.

 

Thanks

[bill110]

Thanks. Have been looking here and have tried to make alterations to include my extra fields.

However, I have not had any luck with this. I still cannot work out where the orders table is updated with the customer info.

 

Also I am not sure if this is the best way of doing it.

 

Would I add a query into orders.php and then call that query from invoice?

 

I have been looking at this for so long now, I can't get my head around any of it.

 

Thanks

It looks like catalog/checkout_process.php does this however I'm not sure.

I can hack but writing this is beyond me. This is the first time I have looked at that file with any effort.

[mdrayner]

It looks like catalog/checkout_process.php does this however I'm not sure.

I can hack but writing this is beyond me. This is the first time I have looked at that file with any effort.

 

 

I thought the same, but as you say, is beyond me..

 

There must be an easier way.. if I can just get the info from the customers table where the customer id is the same as the cust id in orders, this should work?

Everything I have tried to do it this way has failed.

 

Thanks for your help, has anyone else got any ideas??

[mdrayner]

It looks like catalog/checkout_process.php does this however I'm not sure.

I can hack but writing this is beyond me. This is the first time I have looked at that file with any effort.

 

 

I thought the same, but as you say, is beyond me..

 

There must be an easier way.. if I can just get the info from the customers table where the customer id is the same as the cust id in orders, this should work?

Everything I have tried to do it this way has failed.

 

Thanks for your help, has anyone else got any ideas??