OK, in eCart's Archived Documentation there is a solution recipe for ecart 3.7 Database-driven Sales Tax and Shipping.
It talks about: Shipping cost = base rate + (increment x total weight) - increment
Using a table called ShipRates (ref Blue Sky Footwear) with the columns ShipID, ShipRate, ShipType, ShipState ShipInc and ShipZone and uses an extra page "customer_info.php". Does this recipe apply to eCart5?
Meanwhile, I've simplified the DHL database as follows (note: now only one method of delivery):
DHL Next day UK Domestic:
Times:- Next day UK
Flat Charge 1kg-10kg: charged at £6.75 (inc tax).
0.5kg thereafter: £0.26
Fuel surcharge: at present the fuel surcharge is 13% of the parcel value, and has to be added on at the end, this percentage changes each month, and so needs to be editable.
DHL Express Worldwide:
Times:-refer to DHL zones country list (A zone column is added to the countries table).
Flat Charge:- Dependant on country zone and a value in DHL shipping database
Thereafter charges: Dependant on country zone and a value in DHL shipping database
Fuel surcharge: at present the fuel surcharge is 13% of the parcel value, and has to be added on at the end, this percentage changes each month, and so will needs to be editable.
Do I have enough here to apply to the recipe?