|
Group: Forum Members
Last Active: Mon 15 Jul 2013
Posts: 14,
Visits: 153
|
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
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
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.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
Group: Forum Members
Last Active: Mon 15 Jul 2013
Posts: 14,
Visits: 153
|
thanks for that, works a treat
Mark
|