Lightquick Web Design - High Quality, Low Cost

Virtuemart-1.0.15-product-specific-coupons.zip

This Virtuemart 1.0 extension allows you to create coupon codes that can be tied to specific products. For example, you have an item on sale in your shop at £5 - SKU spade01 with product id of 35. You can create a discount coupon of £4.99 which is tied to that specific product id (35). Entering the coupon code will discount only spade01, any other product will not receive the discount. When spade01 is removed from the cart then the discount coupon is also removed. (The end result is that the product is then sold at £0.01, virtually free but the 1 penny cost allows the payment modules to recognise the sale as being valid)

The standard coupon functionality (gift/permanent coupons) is retained but the functionality is significantly improved by these changes. This additional functionality is missing from standard Virtuemart 1.0.15 and even from VM 1.1. It is absolutely essential functionality. In my opinion it should be part of core VM.

This is based upon some VM 1.1 changes found at this location: http://www.nandebayo.org/blog/?p=45. Some significant changes were made to allow it to function under VM 1.0.15. These changes are presented to you now for your Virtuemart 1.0.15 shop. The changes may well work on older versions of Virtuemart but they are untested on anything other than VM 1.0.15.

PLEASE NOTE: This hack works well on an total discount on a specific item, however a bug has been reported in the creation of % discount on a specific item, please bear with me until the bug is resolved, alternatively, please make the fix yourself and report it back to me!  I am so busy I cannot spend the time on resolving this for the moment...

This is a change /hack to core VM 1.0.15. You cannot install it using the standard Joomla installation utility. The following files will need to be changed/ replaced with the files contained in this zipfile.

administrator/components/com_virtuemart/html/product.product_list.php
administrator/components/com_virtuemart/html/coupon.coupon_form.php
administrator/components/com_virtuemart/languages/english.php
administrator/components/com_virtuemart/classes/ps_coupon.php
administrator/components/com_virtuemart/classes/ps_cart.php

This is a very safe modification to do, if you do not understand php / sql do not proceed and even if you do, it is always best to backup your installation and database. It is an easy to job to backup your whole site. If you need help then contact us and you can engage us to explain how.

When the above files have been replaced then some Database changes are required. Using MyPHP admin from your control panel add the following fields to the table jos_vm_coupons:

     product_id, user_id, min_value, discount_type

The SQL commands you must type are:

     ALTER table jos_vm_coupons ADD product_id text
     ALTER table jos_vm_coupons ADD user_id text
     ALTER table jos_vm_coupons ADD min_value text
     ALTER table jos_vm_coupons ADD discount_type text

All of the fields should be text type. All of them should have default value as null and should be nullable.

Finding the product id is very difficult in VM 1.0.15. It has been made easier by a change to the Virtuemart listing of all products allowing the id field to be displayed (exactly as per Joomla 1.5) on the far right of the product list page. This useful change has been provided as part of this modification.

If you want to see the coupon functionality in action it can be seen here: 

http://www.carstuffdirect.co.uk

There are 'free gifts' which have coupon codes tied to them. Bear this in mind this is a LIVE site.