Details

Written by: Valérie Isaksen

Category: Calculation Rules

Published: 05 June 2012

Hits: 29756

Buy here in store!

The Quantity calculation plugin create product quantity based discounts. This tutorial explains how to install and to configure the Quantity calculation plugin.

Some notes to the virtuemart calculation rules system in general

It is quite easy to stumble over the calculation rule system, when you are not used to it. The power of the calculation systems is in its variety of combinations. The most interesting attributes to combine are usually the product categories and the shoppergroups. Consider that you can use unpublished product categories, to layout an hidden structure about your products and to create with it a fine grained calculation. 
Lets assume you have a lot different products, from different manufacturers, but mostly of 3 different distributors. Lets assume the quantity discount depends mainly by the category and the distributor. Then add for each distributor a category and set it to unpublished. Then you can add this category to your product. It is not visible in the Frontend, but the rules are working with it.
The same with sizes. Lets assume you sell beer. In germany we have as package size 6, 12, and 20. Of course you like it when the people by “even” numbers. So you can create three rules, combine it with the quantity =6, =12 and, =20 and connect it to a category size6, size12, size20. Add these categories then to your products.

For more information about the rule system please read http://docs.virtuemart.net/manual/17-products-menu/30-taxes-and-calculation-rules.html

Installation

1. Install the plugin with the Joomla Extension Manager
2. Enable the plugin named iStraxx Quantity with the Plug-in Manager

How to use it

1. Go in VirtueMart administration, choose the menu Products > Taxes and Calculations rules.
2. Create a new rule. At the bottom of the page, the new calculation options are displayed.

Amount Condition

When you use the min/max option or the table, then this field is usually empty. You can enter a value with "=" or % to define different modes.

• "=" means that the rule is only used, when the ordered amount is exactly the entered one. For example =5 is valid only when the product quantity is 5.
• "%" is used for a modulo. This means that every quantity dividable by the entered value is valid for the rule. For example use %6 to give a discount for "six packs".

When you use the min/max limit, then you can create a table. The overwrite value is used then.

EXAMPLE 1: Create a discount of 2% for each 6 packs

1. Create a rule with "Type of Arithmetic Operation" = "Price modifier after tax"
2. Use as Math Operation "-%"
3. Use as Value 2
4. Amount Condition Modus= %6

EXAMPLE 2: create a discount of 2% for each 6 packs and quantity > 15

1. Create a rule with "Type of Arithmetic Operation" = "Price modifier after tax"
2. Use as Math Operation "-%"
3. Use as Value 2
4. Amount Condition Modus= %6
5. Set min to 15

When you use Amount Condition %5 and one row for the table with min=6 max=15 and no overwrite value, then only the quantities 10,15 are discounted by 2%.

Lets assume you set for the Amount Condition nothing and you add a table like this:
min = 5, max = 20, no overwrite value
min = 21, max = 50, overwrite value =5
min = 50, max = , overwrite value = 10
Then every quantity from 5-20 is discounted by 2% and from 21 to 50 discounted by 5% and more than 50 by 10%

Use “Add a min/max limit” to add a new row.

How to display the resulting quantity diagram in Product details

If you use "Rule per product" you can display a discount table on product details. Activate via checkbox to display.
Note: when your rule does not start with min = 0: insert dummy line min = 1, max = 1 it will not be shown and rule will load properly.

Depending on your settings you can display several table variants:

How to combine quantities of categories and/or variants

You can combine quantities of different products. Just use "Consider categories and manufacturers for the value" and or "Combine childs/Variants".

FAQ:

Q: I get a message like:

vmError: vmTable loadTable 'xx.yy_virtuemart_calc_plg_istraxx_quantity' doesn't exist SQL=SELECT `yy_virtuemart_calc_plg_istraxx_quantity`.* FROM `yy_virtuemart_calc_plg_istraxx_quantity` WHERE yy_virtuemart_calc_plg_istraxx_quantity.`virtuemart_calc_id` = "zzz"

A: this just means that you need to store some calculation rule one time, the missing table is then created.

Q: My rule is set up correctly but neither the price changes nor the quantity table appears, what to do?
A: Ensure the calculation rules are assigned properly to product, browse the administration product details and check calculation rules and tax rules to be set as "apply default rules" and "apply generic rules"