rocaholic Posted June 10, 2010 Posted June 10, 2010 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?
Guest Posted June 10, 2010 Posted June 10, 2010 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
NodsDorf Posted June 10, 2010 Posted June 10, 2010 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.