Community Add-Ons

Forgot to replace the following modified files in the package for 4.2.1 (download removed - this replaces it):

admin/orders.php
admin/products_attributes.php (the one that changed so much)
admin/specials.php
admin/includes/filenames.php

Version 4.2.1a is a full package and the included modified files are based on osC v2.2 Release Candidate 2a (December 2007).

The only new functionality is support for making order_total modules customer group selectable.

Changes in:
- admin/products_attributes.php In RC2 there were quite a few changes made to fix a register globals issue in RC1 for the pagination. Therefore a number of changes in the instructions for adding the code for SPPC needed to be made.
- includes/modules/featured.php: missed something in a query where products from subsubcategories wouldn't be displayed
- includes/modules/products_listing_col.php updated for bugs, added support for actual attribute price in drop-down
- catalog/includes/classes/order_total.php This is new in 4.2.1: support for making order_total modules customer group selectable.
- admin/customers.php added support for the order_total modules, changed the code for sorting customers (with the arrow icons) and added the text for title tags of the arrows to defines in the language file.
Put the arrow icons in admin/images and renamed them to icon_up.gif and icon_down.gif (there are more contributions out there who use these icons in this way).
Moved the query for existing_customer_groups to just above where the results are fetched (from around line 340 to around line 838).
- admin/customers_groups.php bugfix in code for inserting a new group
Also changed all occurences of $HTTP_POST_VARS to $_POST, $HTTP_GET_VARS to $_GET, and $PHP_SELF to $_SERVER['PHP_SELF']
Changed all occurrences of 'customers_group.php' (in tep_href_link for example) to the more proper way of using FILENAME_CUSTOMERS_GROUPS. The define FILENAME_CUSTOMERS_GROUPS was not in admin/includes/filenames.php yet.
Added support for making order_total modules customer group selectable.
- admin/includes/filenames.php: the define FILENAME_CUSTOMERS_GROUPS was added to it.
- catalog/includes/shopping_cart.php Correction of the way the calculation of price for attributes is done. The code that was changed already in RC1 was not changed in SPPC.

See the included changelog_v421a.txt for a few more details.

Separate Pricing Per Customer (SPPC) Version 4.2.1a

Version 4.2.0 is a full package and includes the attributes mod and mail functions that were contributed before. It also contains a modification to exempt individual customer and/or customer groups for specific taxes (different from the add-on of insaini of August 24, 2007).
It is MySQL5 proof and the included modified files are based on osC 2.2 Release Candidate 1.

Sorry all, just a stupid mistake. I forgot to include the good general.php file. Its been corrected. Download this file and disregard the one below.

------------------------------------------------
TAX RATES EXEMPTABLE - ADDON TO SPPC 4.1.6
------------------------------------------------

The current 4.1.6 version of SPPC did not really have a complete tax exemption solution. It was pretty basic at best. In Canada, companies can be exempted from their provincial taxes if purchasing products for resale from suppliers within their operating province. Some companies can be exempted from both the federal taxes as well as the provincial taxes. This was key so that if I made a specific customer group I could exempt them from either the provincial, or federal or both. It was a very simple addon, took me roughly two hours and modified a few files.

This addon will give you a select box drop down which can have multiple selected tax rates under the customers_groups page. When you add or edit a group, if that group is tax exempt, it will store those rates which you select for this group. When taxes are calculated, they will be calculated without those exempted tax rates.

insaini

------------------------------------------------
TAX RATES EXEMPTABLE - ADDON TO SPPC 4.1.6
------------------------------------------------

The current 4.1.6 version of SPPC did not really have a complete tax exemption solution. It was pretty basic at best. In Canada, companies can be exempted from their provincial taxes if purchasing products for resale from suppliers within their operating province. Some companies can be exempted from both the federal taxes as well as the provincial taxes. This was key so that if I made a specific customer group I could exempt them from either the provincial, or federal or both. It was a very simple addon, took me roughly two hours and modified a few files.

This addon will give you a select box drop down which can have multiple selected tax rates under the customers_groups page. When you add or edit a group, if that group is tax exempt, it will store those rates which you select for this group. When taxes are calculated, they will be calculated without those exempted tax rates.

insaini

Forgot to add the needed sql command for a database change:

ALTER TABLE `newsletters`
ADD send_to_customer_groups VARCHAR(32) DEFAULT NULL;

A package that contains the files (and descriptions of manual changes if you prefer) that enables customer group specific emailing and sending of newsletters. Although it is tagged as being for the upcoming version 4.2.0 it really can be used with any version of SPPC of the last couple of years.

queries of advanced_search_result.php updated to be compatible with mySQL V5

Allows to memorize in the DataBase the change carried out on the payment and deliveries modes available

Bux fix for:

Separate Pricing Per Customer v4.1.5 (build 051113) 9 Jul 2006 package

This is a small bug fix for admin/categories.php. I noticed that if you copy a product as a duplicate and do not have an existing group price, a group price for the default group (i.e. customers_group_id=0) will be created anyway. This small modification prevents that to happen. Hope this helps someone. Please, comment at the forums. Includes only the bug fix.

Added code to the class order.php (catalog side). Although all prices for groups showed correctly on screens and in the database, in the object $order the retail price for a products attribute was used. This would have had consequences somewhere (perhaps online payment?) so a bit of code was added to correct that. Also some wrong, not-working (luckily) code can be removed from the function query in that class. In the added file the code for the show_tax modification is slightly different than in versions 4.1.1-4.1.5. That was only done to cut back in the amount of code (assessing $customer_group_show_tax from the session variable sppc_customer_group_show_tax only once instead of twice).

This modification enables attribute pricing for customer groups and assumes you have SPPC 4.11-4.15 already installed. The admin side is provided through a pop-up window (attributes_groups.php) that is reached through an extra button in the product attributes table at the bottom of admin/product_attributes.php. In the pop-up window the retail price and the group price for the attribute can be changed, as well as for which groups this attribute should be hidden.

This mod will added to the next version of SPPC.

Minor modifications to SPPC contribution to force PWA (Purchase Without Account) contribution to observe Group=0 (Retail) settings for shipping and payment modules. Without these modifications, PWA uses all active shipping and payment modules, which is a problem when certain modules (e.g., "Net 30") are enabled for use by certain customer groups (e.g., Wholesale) but inappropriate for use by customers without accounts.

This package consists of instructions alone, describing the modifications, which affect only the files /catalog/includes/classes/shipping.php and payment.php.

Using version 4.1.4 the date stamps are compared with the dates of files in OScommerce MileStone 2 build 051113. A few files for the build were newer than the contributed files. Using the new install instructions the included files that were not as new as the build were manually updated.

After changes the test website seems to work, but users need to test extensively and maybe do a 4.1.5a :)

Here is a german translation 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 uses the same files.

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


IMPORTANT:
------------
You have to define the Admin-eMail-Address in
includeslanguagesgermanlogin.php
again. (-> SPPC_TOGGLE_LOGIN_PASSWORD)


28.06.2006, Thomas Schittli

If you are getting the 1054 error replace the index.php file and advanced_search_results.php file with the ones included in this .zip in /catalog
new installs only!

Fixed a bug in the Admin module which incorrectly calculated percentage discounts for non-group 0 customers based on group 0 item prices.

This is the full package, including the modified file (catalog/admin/specials.php)

Fix in admin/categories.php in

} elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate')

for customers_group_id, customers_group_price, products_id

The file index.php contains 2 faulty SQL statements.

They cause an SQL error when OSC attempts to show a products list.

The attachement is the full package SPPC v4.1.1 with spanish

Aquí esta la traducción de éste maravilloso módulo al español en su última versión 4.1.1, tan necesario para algunos, indispensable para otros.

El módulo es el completo, tanto para actualizar como para nueva instalación y sobreescirbir los archivos.

Para más ayuda e inquietudes visitad la gran comunidad de habla hispana sobre oscommerce en http://oscommerce.qadram.com que crece dia tras dia y llena de ilusiones a miles de personas a ganarse la vida.

===================================

This is a complete package with Last version 4.1.1, with Spanish language included.

Regards from spain guys (F.C. Barcelona is the best team of the World, isn't It ¿?)

This package contains ONLY the HTML-Documentation. I took it from the version 4.1, which is not accessible here anymore. It's a separate package and not bundled with SPPC, because both together exceed the 500k file upload limit.

But please look first at this thread, since it's kind of a quick overview with pictures too:
http://forums.oscommerce.com/index.php?showtopic=53436&st=360&p=556240&#entry556240


This contains ONLY the HTML-Documentation, NOT the SPPC contribution itself.

Version 4.1.1 has a small change in admin/categories.php. The state of the checkboxes in the part with the customer group prices was not preserved when going back from the preview page. This has been fixed now.

This release does not include the HTML overview of the contribution in action with extensive pictures. Download version 4.1 of March 15, 2005 for that.

This is the long awaited Version 4.0 of Separate Price Per Customer. It includes too many bug-fixes to list plus much more features and functionality.

Inlcuded are complete install docs, pre-made files, SQL install & un-install Scripts. Also included is an overview of how the contribution works.

If you are considering this contribution, or upgrading, please look at this post; http://forums.oscommerce.com/index.php?showtopic=53436&view=findpost&p=556240

as it describes the complete contribution along with extensive pictures.

Bugfix.

Fixed wrong tax and total in Order Confirmation.

Thank you Oliver Huebner, I just used your code to fix this.

This package fixes two bugs

1. Shows prices with tax for new accounts.
2. Guests see prices with tax.

This Extension allows you to Enable or Disable tax for different customer_groups.
It requires a running Seperate_Pricing_Per_Cstomer_v3.51 Installation.

Please backup first

I just did a minor change. Now it´s possible to show prices including tax for Retail-Customers and prices excluding tax for Wholesale-Customers.
You can easily edit the file for other or more custumers.

This package has been assembled with all files modified and ready to paste over a fresh install of oscommerce-2.2ms2. Includes SQL file. The SQL file drops the customer, products_groups and specials tables completely and then reloads SO BACKUP IF YOU HAVE MADE CHANGES.

If you have modified your installation in any way, do a manual install using the file PriceModInstall_manual_v3.5.txt as you guide. And remember to backup first.

There was an error in the original PriceModInstall_manual_v3.5.txt file which has been corrected.

Installation Instructions:

Step 1.
Copy the entire Catalog folder over your fresh install of oscommerce-2.2ms2.

Step 2.
Using MySqlAdmin or some other MySQL tool, load the Separate_Pricing_Per_Customer_v3.5.sql file into your database.

Thats it !!

WotzHotNow

Updated by Scott Everson (scott AT everson DOT ws), 08/02/2003

Bug fixes:

-Added in mod to products_new.php (so correct price displayed in new products list)
-Adjusted location of mod in modules/product_listing.php
-Changed $product_info_values[] to $product_info[] in product_info.php mod. My 2.2MS2 used the $product_info[] array.

Improvements:

-Added option mod to support special prices per group. This means that you can create a special price for your 'Retail' group and only customers in that group will see the special price. Create a special price for your 'Wholesale' group and only customers in that group will see the special price. Special prices will not default.. meaning if there is no special price for 'Wholesale' but there is one for 'Retail' your wholesale customer will NOT BE SHOWN the retail special price.

More info: When you add special prices, you will see the prices for each group next to the product title. It a price/group is missing, it is because a special price for that prodcut/group already exists. If the product is missing, it is because there is already a special price for all groups.

I am willing to offer support for this MOD and version 2.2MS2.

Here is an updated version for MS2. There is no upgrade from previous versions. If you have a stock version of MS2, this should work. I'm sorry, I cannot support this anymore as I don't have the time. If you run into any problems, please go to the forums for support.

Typo fix in the complete full install of V3.3

This little added code let you show in the header application the status of "reseller"
you may use it whith the complete package in this section.
It must be personalized,also if you want have more than two group of customer (searc for this string "---HERE PERSONALIZE THE TABLE WHIT YOUR GROUPS------")

Good luck
(we love open source)

This file allow to correct a bug in this package: if you need both specials and separate pricing per customer you need to whatch out the differences between this file and the previous. Some code added for considering special.
That's all
good luck

Some code from an old version made it into the install for v3.2. This fixes that problem and adds modifications to a couple of more files so the updated price shows up throughout the whole store.

Fixed a bug that erased old prices when a new group was added.

Fixed some bugs with the previous release. There is an upgrade document for people that have already installed and are using v3.0 and a install doc for new installations. Only two files need to be updated. This is also listed in the Features category by mistake.

Fixed some bugs with the previous release. There is an upgrade document for people that have already installed and are using v3.0 and a install doc for new installations. Only two files need to be updated.

Fixes a small bug in customers.php that would assign the default customer group of Retail a number other than 0.

Fixes a small bug where products would not be deleted from the table when they were contained within a deleted category.

This mod alllows the site owner to assign customers to seperate groups and then give different pricing per product for each group. It's based on David Garcia Watkins' Alternative Attribute Handling mod so thanks David. There is only an install text because you need to modify quite a few of the core files and the database. Hope it helps.