Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Admin Side - Assign Customer Number


rocaholic

Recommended Posts

Posted

Hi, I've been looking around for a mod that will allow the admin to assign a custom customer ID or number to an account but I could not find one. The reason being is that we use Sage MAS 90 to maintain our stock and customer accounts and we'd like to keep the same account number for our customers that use the website. We are a wholesale business so it'll be very convenient for us. I'd like for us to assign a customer ID or number for the customer that would show up on the invoice as well. Is this possible?

Posted

John,

 

I may be wrong, but I don't think there is currently a contribution like that. However, there are a couple that may be modified to do what you want. I am thinking of Customer Extra Fields, but you would have to add the query to the order.php file and allow for the field to echo onto the order itself. It can be done, but would take some custom work.

 

 

 

Chris

Posted

customers already have a unique id number

 

Check your database

Table customers

Field customers_id

 

You could then just echo that on the invoice....

 

If you want to give them a different number then the one that is assigned by the oscommerce you could just add a field into the database, then echo that on the invoice. Of course you would have to enter that data in manually, unless you wanted to create an interface to do it, maybe on the admin page.

 

For me if I couldn't use the oscommerce customer number, I'd just make an csv file with all the customers and their personal account number and convert it into an sql update statement, then update the database.

Archived

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

×
×
  • Create New...