Community Add-Ons

may use % (percent) in discount table
example 1 :
10€ for 1 to 9 parts
8€ for 10 to 99 parts
5€ up to 100 parts
You enter 10 for the product price and 10:8, 100:5 in the new field.

example 2 :
10€ for 1 to 9 parts
10% off for 10 to 99 parts
15% off up to 100 parts
You enter 10 for the product price and 10:10%, 100:15% in the new field.

To the newbies who keep posting in the contrib area comments please use this contribution's forum to post:
http://forums.oscommerce.com/index.php?showtopic=272283

I use the last version, but if i set attributes/optionsto an product, the script doesn't seem to notice that the product is the same, so its counting each attribute/option as another product. if i then buy three the same products with different attributes/options. i dont get the quantity-discount...

Who can solve this problem?

Removed unused products_bundle field from directions and database sql.

All fixes below incorporated in addition a couple of errors in install directions have been fixed and the install directions have been updated to make them easier to read.

Do not post problems like the person below in the contribution area, use the
SUPPORT FORUM:
http://forums.oscommerce.com/index.php?showtopic=272283

Hi Guyz I respect the contribution as its totally working except subtotal on single or multiple purchases it still displays price as per single quantity suppose we have aproduct with price $10 but for 200:9, 500:8.5, it s'd give me 200*9=1800 as subtotal since from 200 to 499 price is $9 that is 10$ if we buy less than 0 to 200 amount of products. Please provide a fix for that.

Hi.
I use v2.2 osCommerce and here are few instruction's fixes:
1. SQL sintax fix
2. Few other sintax fixes.

Full instructions included.

Hi.
Found few errors - can't find how to solve them.
here they are:
1. Step 2
SQL code :
ALTER TABLE `products` ADD `products_discount` VARCHAR( 128 ) ;

{should include also

ALTER TABLE `products` ADD `products_bundle` ?????????( ??? ) ;}
I have no idea of what type of data it should be.
2. Maybe on the reason above i have wrong displaying of this option in admin: (example):

R?duction per qty qt?:prix ht, ... ex: 10:3.95, 20:3.62

I added the following string in SQL syntaxis:

ALTER TABLE `products` ADD `products_bundle` decimal(15,4);

but I'm not sure is it correct.

I also have problem:
when trying to checkout with the product with specified discounts it always shows 1 in product quantity field. No matter if I enter 4 (for example)

If anyone knows how to solve this....

(attached file isn't related to this contribution)

Just a correction in installation instruction.
Nothing else.

Enjoy!

[Full package]

I forgot that

find (l72)
$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
replace with :
$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_discount, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_bundle from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

this contribution allow prices break for products.
It adds a new field in the admin/product description in what you enter the discounted price per quantity in the same way you can enter the price range in the spedition module.
For example :
10€ for 1 to 9 parts
8€ for 10 to 99 parts
5€ up to 100 parts
You enter 10 for the product price.
10:8, 100:5 in the new field.

This code automaticly add a tab at the end of the product description to show the price break to the customer.

I wrote this code because my own code is too modified to add the price break contribution.
This one is "easy" to install and don't modify lot of code.