|
By kalkhovm - Fri 11 Nov 2011
|
Hi,
I am trying to find a way to lose the All Higher ** option in the shipping rates section, as I have a maximum weight limit on each of the shipping options I am employing. Is there any way to do this at all?
Cheers
|
|
By Paul - Mon 14 Nov 2011
|
There is, but at present it cannot be done through the back end interface. You'll need to do the following:
1. In the back end, go to database admin, then the 'triggers' page and click the link to disable all triggers. The triggers prevent casual modification of the data, so you'll need to disable these in order to do the next step...
2. Open up SQL Management Studio and view all the records in the tblKartrisShippingRates table. You'll notice some have 999999 as the value in the S_Boundary field. These records are the 'all higher orders' ones. You can delete the ones that you need to - you can check the S_ShippingMethod and S_ShippingZoneID values to see which method and zone this particular record applies to.
You can reactivate the triggers afterwards, but if you don't, it doesn't matter as they'll get reactivated over time anyway.
|
|
By kalkhovm - Mon 14 Nov 2011
|
thanks for that, works a treat
Mark
|
|