Community Add-Ons

The upgrade of January 31, 2007 contains a PriceFormatterStore class that does not work properly for groups. This has been fixed now.

This *upgrade* for the basic version of Quantity Price Breaks for SPPC 1.0.2 only has a few changes but might make quite a difference in the number of queries once a customer starts adding products to the cart. You need to have installed the basic version of Quantity Price Breaks for SPPC 1.0.2 first!

Changes:
- added PriceFormatterStore.php as a class/object to store mysql results. For the shopping cart box PriceFormatter is called 5 times per product, each time using 2-3 queries (depending on the customer group). Now only two to three are used for all products in the cart.
- changed PriceFormatter to take advantage of PriceFormatterStore (changes in function loadProduct, commented out functions encode and decode because they are not used anyway, added quotes around the $style in function getPriceString)
- added instructions to change the function tep_get_stock to take advantage of PriceFormatterStore (instead of using 1 query per product in catalog/shopping_cart.php)

Here is a german translation for
Quantity Price Breaks for Separate Pricing Per Customer

Just copy all Files to the Server, maybe you have to merge
some files if you have other modules which adds own
translations to the same files.

(-> SourceForge.net WinMerge,
http://sourceforge.net/projects/winmerge)


29.06.2006, Thomas Schittli

Changes in 1.02 from v1.01
No need to update if you have installed v1.01. This (complete) package contains additional instructions (found in the file price_break_per_category_instr.txt) and two modded class files (shopping_cart.php as shopping_cart_pbpc.php and PriceFormatter.php as PriceFormatter_pbpc.php). This modification makes it possible to calculate price breaks using the number of products from the same category.

Example: you have a price break for a product when 5 items are bought. With this mod, the number of products in the shopping cart from the same category is determined first and those numbers are used to calculate the price break. So when 2 products A and 3 products B from category 13 are bought, prices of products A and B as if 5 items from each were bought are given.

There was a mistake in a query in admin/categories (line 1083 in the modded file) where it said:
"p.products_price, ,p.products_price1" where there should be only one comma.

Screenshot (courtesy of Nate Levy) of the admin/categories.php page was added to the zip file.

Quantity Price Breaks for Separate Pricing Per Customer

Quantity Price Breaks Per Product 1.11.3 for version 4.0/4.1 of Separate Pricing Per Customer

As the original Price Break documentation mentions:
(see http://www.oscommerce.com/community/contributions,1242)

Purpose: 1) To allow quantity based pricing per product
2) To allow the ability to sell a product in
lots of # quantity only.

This particular contribution allows these settings for each customer group. The changes and line numbers mentioned assume you have the files of SPPC 4.0/4.1 installed.

Support thread: http://forums.oscommerce.com/index.php?showtopic=53436&view=getlastpost (Seperate Pricing Per Customer v3.5)