I posted a question last week on the Drupal Commerce forum (http://www.drupalcommerce.org/node/773), but figured I would provide more details in the hopes that someone could help me figure this out.
The client is selling wine. He wants to provide different flat shipping rates for quantities 1-3, 4-6, and 7-11.
But, if a user wants to purchase a case (12 bottles), the client wants to ship that for free as an incentive to purchase larger quantities. But, if a user buys a case and 1 bottle, the case will be shipped free, but the single bottle will needs to be charged the 1-3 flat rate.
I'm not quite sure how to manipulate the rules to accommodate this scenario.
For example, when I add a case (the individual bottle and case are each separate products in the system) to the order and 3 single bottles, the cart sees 4 items, and the flat shipping rule for 4-6 quantities wants to apply.
I need the system to ignore the case quantity amount in the cart for the shipping rules and only apply the flat rates that pertain to single bottle purchases.
If someone could suggest a way I could tackle this, it would be greatly appreciated...
Thank you,
Joe