Thread: Shipping Methods to Prevent

Is there any way to increase the field where you list the shipping methods to prevent? I can't fit all the services I want to prevent into the config field. Thanks!

The easiest way would be to use SSMS to change the 'ConfigValue' data type in the AppConfig table to nvarchar(MAX) (rather than nvarchar(1000)), then just enter the data directly into the database. Being able to change that through the admin site would require a little bit of code mod.

Have you tried typing past the visible window? you can get alot in there past what is visible..it will scroll horizontal.

That field is limited to 1000 characters including space, therefore, simply alter the column and increase the field length and that's it...

That sounds easy. Can you please walk me through how to do that?

Run this query against our DB:

Code:

alter table appconfig Alter Column ConfigValue nvarchar(MAX)

Make sure you've done a full DB backup first, just in case.