Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Query the customers table in invoice


mdrayner

Recommended Posts

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?

Link to comment
Share on other sites

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

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...