Complex shipping ASP script help

I need help either scripting or telling eCart what I want to do with a bookshop -

*If customer orders 1 book, then shipping = databasecolumn.minShipping
If customer order >1 book, then shipping = if (totalweight < 500g) $5, if (totalweight >500g) $10 UNLESS CombinedMinShipping < $5,$10 respectively, then use combinedMinShipping

*If customer country is NOT Australia, then skip paypal process and redirect to InternationalCheckoutSuccess. It already captures the data, she plans to review the order details, and send an invoice manually through paypal, then manually update the database payment status.

Note the customer country is not known until the checkout page collects it, just before confirmation. Selection>Cart>Checkout>confirmation>(suspended payment)>confirmationsucess>manual invoice>manual database update

Its confusing and overly complicated I know, but the person I'm building it for has absolutely ruled out using the AusPost calculator or fixed rate shipping, as well as using stored customer log ins.

To stat this off you should ensure that you have a minimum shipping column in the cart to hold the value from the db.

Next you can break down the logic into different rules. The first one will be very simple, you will have the the trigger set to 'if total items' = 1, then for the calculation you would have based on a column subtotal and specify the min shipping column.

The next rule will be a little more involved. The triggers will be if total items > 1, AND subtotal of total weight < 500 AND subtotal of min shipping >= 5. The calculation will be flat rate value of 5.

For the greater than 500g the triggers will be if total items > 1, AND subtotal of total weight >= 500 AND subtotal of min shipping >= 10. The calculation will be flat rate value of 10.

To account for when you would use the combined minimum shipping you would repeat these last two shipping rules, but you would check for min shipping < 5 and < 10. For these you would use the subtotal of the min shipping column for the calculation.

This is a guideline for how you could craft these shipping charge rules within eCart. If you have any questions about any part of this let us know.