Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Display customers Company in admin view


aksteven

Recommended Posts

Hi,

 

I am new at MySQL and php, however have successfully set up an OSCommerce store at www.weaverandknott.com. My client now wants to see the customer's company in the customer listing in the Admin section as well as their first and surnames, etc. so that they have an overview at a glance of not just the customer's name but which company they are from too.

 

So far I have added the line

 

define('TABLE_HEADING_COMPANY', 'Company');

 

in admin/includes/languages/english/customers.php

 

and in admin/customers.php I've added:

 

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COMPANY; ?></td>

 

and

 

<td class="dataTableContent"><?php echo $customers['customers_company']; ?></td>

 

Can anyone help me make the appropriate mods to the MySQL db to get the customers table to read entry_company from the address_book table and what other mods (if any) should I make to the customers.php file to get the company to display?

 

Thanks in advance for any help,

Andrew

=======================

I do not fear computers. I fear the lack of them.

Isaac Asimov

Link to comment
Share on other sites

Thanks Richard. That works a treat.

 

Plus I now have colums in the Customers admin section sorting Ascending or Descending by First name, Surname or Date subscribed thanks to this contribution:

 

Community contributionhttp://www.oscommerce.com/community/contributions,223

 

Happy developer, happy client.

Andrew :D

=======================

I do not fear computers. I fear the lack of them.

Isaac Asimov

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...