Shipping Charge by Order Value

[mwilliamson]

Hello,

I am trying to get the following shipping charge by order value:

Order less than £39 - Pay £11.99 for shipping
Order less than £59 - Pay £9.99 for shipping
Order over £59 - Pay £7.99 for shipping
Extra Large Orders - Pay £7.99 for every £80 ordered


However, when I enter the corresponding values into business settings, I get the following error message:

*********************

There was a problem with the database

Operation: Editing a record in the [Bands] table sorted by [ZoneID], [ClassID], [CalculationBasis], [BandWeight]

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

SELECT `BandID`,`ZoneID`,`ClassID`,`BandWeight`,`BandCost`,`CalculationBasis` FROM `Bands` ORDER BY `ZoneID`, `ClassID`, `CalculationBasis`, `BandWeight`

Action: Contact your Actinic reseller or Actinic Support as appropriate

**************

Any clues as to what is going wrong and what I need to do?

[leehack]

Can you provide some screenshots of the settings you have put in?
Did you notice we have a forum called 'shipping'?

[mwilliamson]

Can you provide some screenshots of the settings you have put in?

Attached below. I'll also post this thread on the Shippings Forum. Thanks.