Contributions
Separate Pricing Per Customer
This mod allows the site owner to assign customers to seperate groups and then give different pricing per product for each group.
Expand All / Collapse All
[EN]
Small error detected.
By adding a product to order shows an error: table does not exist.
Search catalog/admin/edit_orders.php line
'tax_id' => tep_db_input(tep_db_prepare_input($_POST['update_entry_company_tax_id'])),
Replace
'entry_company_tax_id' => tep_db_input(tep_db_prepare_input($_POST['update_entry_company_tax_id'])),
Complete instructions with error corrected.
[ES]
Detectado pequeño error.
Al añadir un producto a la orden se muestra un error: la tabla no existe.
Buscar en catalog/admin/edit_orders.php la línea
'tax_id' => tep_db_input(tep_db_prepare_input($_POST['update_entry_company_tax_id'])),
Reemplazar por
'entry_company_tax_id' => tep_db_input(tep_db_prepare_input($_POST['update_entry_company_tax_id'])),
Instucciones completas con error corregido.
reflex-ocasion
[EN]
Added to the contribution order_editor (http://addons.oscommerce.com/info/1435)
to add or modify the customer's tax number if necessary.
Also includes instructions to display the number tax on the packingslip, invoice and invoice PDF (http://addons.oscommerce.com/info/5321 y http://addons.oscommerce.com/info/6122)
I do not have this useless information so important to check if it is not shown anywhere.
Only instructions in English and Spanish.
[ES]
Añadido a la contribución order_editor (http://addons.oscommerce.com/info/1435)
para añadir o modificar el número fiscal del cliente en caso de necesidad.
Tambien se incluyen instrucciones para que se muestre dicho número fiscal en el albaran, factura y factura PDF (http://addons.oscommerce.com/info/5321 y http://addons.oscommerce.com/info/6122)
A mi no me sirve para nada tener ese dato tan importante para la facturación si no se muestra en ningún lado.
Solo instrucciones en español e ingles.
reflex-ocasion
NB osCommerce 2.3 stores only!
Single file: replacement for catalog/product_reviews.php
not full package - use together with preceding download for a full set of SPPC 4.2.2 files for osc 2.3.1
for osc 2.2 stores use earlier downloads
I'm afraid that I've not produced a 2.3.1 version of the wonderful documentation to go with it.
Please conduct your own beta testing; I have tested against the documented features and believe this works as described
but am not familiar with SPPC on 2.2 so I can't swear that I haven't made anything work differently.
The code changes applied are those in the documentation for SPPC 4.2.2 on osc 2.2
ANY SUBSEQUENT BUG FIXES TO CODE AMENDMENTS HAVEN'T BEEN INCLUDED, so that would be a good thing to cover
in your beta testing!
Package contains:
full set of amended and new files for SPPC 4.2.2 on 2.3.1 (no further add-ons)
full set of documentation for installing SPPC on 2.2 that you can follow for 2.3.1
full set of documentation for using SPPC on 2.2 that should be unchanged
Changes for 2.3.1:
(main places where the code amendments needed to be different, not just at a different line in the file)
catalog/admin/includes/boxes/customers.php - done differently on 2.3
catalog/admin/categories.php - no longer has a preview
catalog/admin/products_attributes.php - jquery buttons
catalog/admin/specials.php - fixed a bug preventing insertion of a special for a non-zero group with no group product price
catalog/includes/boxes/specials.php now catalog/includes/modules/boxes/bm_specials.php in a different format
catalog/includes/boxes/whats_new.php now catalog/includes/modules/boxes/bm_whats_new.php in a different format
catalog/includes/modules/new_products.php - quite different because of shop layout changes
catalog/includes/modules/product_listing.php - quite different because of shop layout changes
catalog/product_info.php - quite different because of shop layout changes
catalog/specials.php - quite different because of shop layout changes
Modified Product_info.php for Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 (1)
NOT FULLPACKAGE
Español.
Adaptación para la contribución
Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 (1)
Just created a file for directions to change
admin/orders.php
to be able to sort orders by customer group name
NOT full package. Just txt install file.
English_____________
Little detail in admin/customers_groups.php. Path of the 2 images was wrong.
Added file admin/customers_groups.php correct and screenshot.
Español____________
Pequeño detalle en admin/customers_groups.php. El path de 2 imágenes era erroneo.
Añadido fichero admin/customers_groups.php corregido y screenshot.
NOT Full package
English_____________
When you insert an special for a client group did not appear in new_products.php
Español____________
Cuando se insertaba una oferta para un grupo de cliente no aparecía en new_products.php
BUG FIX in catalog/includes/modules/new_products.php
FULL PACKAGE
Auto Installer 2.13 for Separate Pricing Per Customer 4.2.2 by Jan Zonjee (20 Jul 2008)
Few lines of code were added to the sp_autoinstaller/autoinstaller.php file to make it list all the files, directories that should have 777 permissions.
The file catalog/admin/customers_groups.php was updated to the latest version from "Hide products from customer groups for SPPC" Version 2.0.3 (5 Aug 2008) contribution to make it use new icons.
It is for clean (not modified) install of osCommerce Online Merchant v2.2 RC2a only !
The autoinstaller script requires PHP5
The SPPC documentation is not included.
Auto Installer 2.8 for:
Separate Pricing Per Customer 4.2.2 by Jan Zonjee (20 Jul 2008)
It is for clean (not modified) install of osCommerce Online Merchant v2.2 RC2a only !
The autoinstaller script requires PHP5
The SPPC documentation is not included.
This allows you to set a minimum purchase amount for your wholesale customers; if the minimum isn’t met they see a notice and checkout is disabled.
The amount is set in admin.
This is a complete set of files.
This is the full contrib with french languages files.
Full package
This is the full contrib with hungarian languages files.
Full package that includes a bugfix in login.php (customer specific taxes exempt would still not work if you logged in as the test user).
Added the SPPC modified tax class for contribution "Optimize tep_get_tax_rate() method" (http://addons.oscommerce.com/info/2417).
Full package that includes a bugfix in login.php (regarding customer specific taxes exempt not working), fix of a mistake in the install.html (includes/classes/order_total.php a line too much) and a change in includes/modules/new_products.php to be compatible with MySQL4 (would get an error about products_id being ambiguous).
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.
Note: Contributions are used at own risk.
small error edit_orders
Bug fix to SPPC 4.2.2 on oscommerce 2.3.1