I am having a problem when setting up the table rates for shipping.
Firstly i shall explain what i am trying to achieve-
Like everyone else on e-commerce, we have light products and heavy products.
Everything that is less than 2kg can be sent abroad and to uk off-mainland for normal money.
Everything over 2kg that is going abroad or uk off- mainland needs to be charged extra.
i know that royal mail will ship 1st class anywhere with a postcode over 2kg but this is the benchmark we are going to set.
I want to set all items that are over 2kg and that are purchased by an address outside of the couriers standard rate boundary to a higher rate. This way, when a heavy item is bought off-mainland, i can afford to ship it by courier.
I have a spreadsheet from them with all the uk postcodes in this format - eg: HP22 8 - not the full postcode.
I export the csv file, add the postcodes, etc.. then import.
The european settings work fine. It recognises the countries and adjusts the price accordingly.
But, when i purchase something from UK and put in my full postcde eg HP22 8BB it does not recognise it. It only recognises exactly what is put into the database.
For example - if the postcode region is set to raise rates on HP18 and i put in checkout HP18 8GG the price is not converted. The checkout only converts the price when there is an exact match with the postcode and the spreadsheet.
I tried putting in the full postcodes into the database and this then works except if the database format is HP22 8BB and i put in checkout HP228BB (no space) then it does not recognise it!!!
Do I have to put in all the postcodes in full format with and without space to overcome this or is there a way round it on excel. I have tried using HP22* but this does not work.
Any help greatly appreciated.