How can I add a new 'range' to 'shipping costs'

[gray]

How can I add a new 'range' to 'shipping costs'

 

I have set up my first range to be 0-1kg and then others up to 25kg

But how can I add new column for 0-0.5kg It keeps throwing errors when I try to change existing columns

ie changing 0-1kg to 0.5-1kg and then add a new column 0-0.5kg

It looks like I have to delete all range columns and start again.

Any ideas. Or point me to the table name in the Mysql database.

Thanks

[joseantgv]

Table is ps_range_weight

[gray]

Hi - Managed to find the correct table, this being ps_delivery

This lists id_carrier, id_range_price, id_range_weight, id_zone, price

However does any know what sql command I would need to list, the actual country/zone as well as price and range_weight ?

 

It also list 36 different carriers. I presume it has not deleted all the test/setup entries, as I only have 2 carriers only, with one of them being collection.

 

How do I know which carrier is the actual one I am using ? As I think I would need to purge the database.

I am using PS 1.7.3.3