Credit Limits

Sep 27, 2005 1 Replies

Is there a way to globally increase customer credit limits by a set $ amount for all customers.



Yes, Go to Administrator, connect to the database, backup the database (always do it first !), go to the Query window and type in there:

UPDATE Customer SET CreditLimit=CreditLimit+300

and then press the big green arrow and wait for result

'300' here is just an example. This command will increase each customer's credit limit by $300. Change the number in the command as you wish. If you wish give all customers, say, flat $500 credit limit, change the command as the following:

UPDATE Customer SET CreditLimitP0

I hope it helps

"RyanMatk> Is there a way to globally increase customer credit limits by a set $ amount

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required