Shipping calculations help required.

[edgedata]

Hello,

I have a problem with defining a rather complicated shipping table.

Our site sells various curtain making sundries, fabrics, books and curtain design courses.

We ship only to the UK

We have a fixed shipping charge of £5.50 per order to the mainland with different fixed charges for highlands, channel islands etc.

When orders are over £120 the shipping is reduced by £5.50 making it free for uk mainland and reducing highlands etc.

No problems so far.

We send out free sample of curtain poles and fabrics for £2.50 per order. This is not charged if the customer orders other items from the store as they will then pay the standard £5.50 etc.

Our courses which are held in our workrooms obviously do not attract postage at all.

We are now selling a range of fabrics which are shipped directly from the manufacturers and charge £8.50 per order of fabrics. This is in addition to the standard charge if sundries are also ordered at the same time.

The same £8.50 per consignment applies to orders for Silks which are also shipped directly from the supplier. This is a different supplier to the other fabrics.

So in summary.

- Book a course = £0.00
- Free Samples = £2.50 per order but only if nothing else ordered.
- Sundries = £5.50 per order but free if sundries over £120 in total to uk mainland only
- Sundries = £11.50 per order but £6.00 if sundries over £120 in total to - Scottish highlands only.
- Fabrics = £8.50 per total number of fabrics ordered in addition to above
- Silks = £8.50 per total number of Silks ordered in addition to all above.

I have played around for several days now using Zone/Category and supplements but cannot achieve the above.

Can anyone help? I would be so grateful if you could.

[bcomp]

the best way ii can think of would be to use weight, not the actual weight but the products which require shipping from the supplier at £8.50 you could set as 200.00kg (you will need to consider what people will be ordering and set the weights so that the chances of them reaching the direct from manufacturer weight is pretty impossible) and mark the box ship seperately, then for everything else you could set the product weight to 20.00kg and 10.00kg or something (probably be better to use lower weight levels) and set up weight based shipping that meets your requirements something like:

200.00kg > £8.50 (shipped seperately handles the charge per item issue)
20.00kg > £5.50 (standard charge, if sample ordered the weight would go over 20.00kg so they would be charged the standard £5.50)
10.00kg > £2.50 (this covers the samples although if they order 2 they would then fall in to the standard charge of £5.50)
up to 10.00kg > Free (only thing under 10.00 kg will be the course (set the weight to something like 0.10kg)

You would then need to set up all the fabrics and silks to be shipped seperately and that there weight is 200.00kg so they are charged £8.50 per item.

Then you need to set up different locations for the UK so you can charge a different amount for Scotish Highlands, Scotish Offshore Islands, Southern Ireland, Northern Ireland and Channel Islands (you need to set these up for VAT reasons as well as products sold to Jersey etc are zero VAT).

When you set up the additional locations you will need to use UK1, UK2, UK3, UK4 etc etc as the code or you might well run in to problems with your payment service provider.