Product Field Access for Conditions/Rules

I'm trying to figure out how to access fields in Conditions/Rules that I have setup on Products. This applies to Tax Calculations. In Canada there are 3 types of Sales Tax, Provincial Sales Tax (PST), the Goods and Services Tax (GST) and a Harmonized Sales Tax (HST). The PST in some Provinces is a set rate, and applies to most, but not all, products and services. The GST is a Federal sales tax (similar to a VAT) that applies to most Products and Services, but not all. The HST is a combining of the PST and GST in some of the Canadian Provinces and applies to most products and services.

I have installed Drupal Commerce Kickstart to test the capabilities of this eCommerce distribution.

Ok, background done. Here is the challenge. I have add 2 boolean fields to the test products I am working with. One field is GST_Applies and the other is PST_Applies. Not all products have one or both of the sales taxes. (For example, most food is not taxed, but some snack foods have one or both taxes applied)

In my product setup, we'll determine which taxes apply.

In the setup of the Tax Conditions/Rules, I do not see how to check the value of one of the above 2 fields is set to "YES" (Boolean). I can see where to add "Entity has Field", and select one of the above fields, but that does not allow me to test the VALUE of the field, which is what I need to build the Tax Conditions/Rules.

Another rule that may need to be applied is on Donuts! Yes, donuts. If you purchase a single donut, then taxes apply as this is considered a snack food. However, if you purchase 6 or 12 donuts, then that is considered a food item, and the GST does not apply. (I'm not making this up!)

Can someone please help with this?

Thanks for all your help.

Posted: May 14, 2012


laclu007 on May 15, 2012

Not one to just stop when I ask for help, I kept searching to see if I could find the answer. Low and behold, there is an excellent video by the Commerce Guys on Vimeo that describes exactly what I was looking for: