Is there a way to globally increase customer credit limits by a set $ amount for all customers.
Credit Limits
Sep 27, 2005
1 Replies
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