ZONES SHIPPING MODULE HACK

[Guest]

My problem: orders in my shop must be from min.1Kg to max.30Kg - FedEx rates take 0.5Kg increments in account. Longest string is then FedEx's B Zone:

 

682 chars [breking it up so it doesn't stretch too much]

1.0:60.92,1.5:68.40,2.0:75.83,2.5:83.17,3.0:92.02,3.5:92.02,4.0:98.98,4.5:105.94

,5.0:112.84,

5.5:106.73,6.0:113.04,6.5:119.19,7.0:125.42,7.5:131.57,8.0:137.83,8.5:144.03,9.0

:150.17,

9.5:156.40,10.0:162.67,10.5:200.49,11.0:206.58,11.5:212.66,12.0:218.75,12.5:224.

81,

13.0:230.89,13.5:236.98,14.0:243.07,14.5:249.15,15.0:255.24,15.5:261.32,16.0:267

.41,

16.5:273.50,17.0:279.58,17.5:285.67,18.0:291.75,18.5:297.84,19.0:303.93,19.5:310

.01,

20.0:316.07,20.5:321.43,21.0:313.42,21.5:318.54,22.0:323.67,22.5:328.79,23.0:333

.92,

23.5:339.05,24.0:344.17,24.5:349.30,25.0:354.42,25.5:359.55,26.0:364.67,26.5:369

.80,

27.0:374.92,27.5:380.05,28.0:385.17,28.5:390.30,29.0:395.42,29.5:400.55,30.0:405

.67

 

The field where the string is stored is `configuration_value` in table `configuration`, which is set to varchar(255) - thus a 682 chars long string will be truncated...

 

The field type needs to be changed to 'blob' or 'text'. If you're using phpMyAdmin that's pretty simple: select the table (configuration) and click on "edit" (the pencil-like icon) and change the type from 'varchar(255)' to 'text'.