Complex Flat Rate Shipping
A client has a flat rate shipping table.
It is grouped into three zones (US-only, multiple states per zone), and then by quanity of items (1-2, 3-10, 10+).
Plus, if an item costs more than a certain $ amount, it counts as (2) items.
1. Customer is from OH and orders 2 items (under $15) it should go in the zone with OH and use the 1-2 item rate for that zone.
2. Customer is from KY and orders 2 books under $5 and one book over $15.. it should go to the zone with KY and calculate as 4 items for shipping.
Between the zones and item-range it gives me 9 options (plus the >$15 item count issue).
I have Drupal Commerce Kickstart and the Shipping and Flat Rate Shipping modules installed.
I created a computed field (using the computed field module) in my product that sets a 1 or 2 depending on the price.
I am not sure if I can use this field in drupal commerce rules to help calculate the shipping rate.
Any ideas on where to start?