Zen Cart custom software development, Zen Cart modules, Zen Cart Expert eCommerce Starts Here!
Zen Cart Per User or Group Specials

Zen Cart Per User or Group Specials

A Zen Cart™ module enabling you to offer specials to a specific user or user group instead of to all customers.

Background: See the Zen Cart Matrix-o-discounts

Relevance: Zen Cart™ 1.3.9, 1.5.x

Current Version: 1.3

Occasionally, new features are documented prior to being publicly available; please check the version history to ensure the feature you want is available in your version.

Support Thread: My commercial software is not supported on the Zen Cart forum. Please email me questions instead.

Cost: $60.00 (Note: this low price covers software only for self-installation.)

Buy Now

Would you like to ask me questions before buying? I'm happy to help likely purchasers make the right decision. Just use my contact form.

Installed Cost: $180.00 (Professional installation by That Software Guy)

Installation Difficulty: Moderate to High (Some file merging may be required.)

Installation Instructions: click here

Common Installation Problems: click here

Buy: Buy Per User or Group Specials!
Pre-purchase questions? No problem! Just click here.

FAQ: click here

Configuration: Per-User Specials may be accessed from the Admin->Customers->Customers screen. Per Group Specials may be accessed from the Admin->Customers->Group Pricing screen. Adding a Per User or Group Special is just like adding a regular special, except you specify a user or group to which it applies.

Bugs: click here


Zen Cart has a built-in mechanism for discounting individual items called Specials (accessible under Admin->Catalog->Specials).

But Specials are available to all customers, and this may not be what you want. Using this mod, you can segment specials so that they are only available to a particular user or group.

Detailed Description


Per User Specials may be accessed from the Admin->Customers->Customers screen.
Zen Cart Per User Group Specials

Per Group Specials may be accessed from the Admin->Customers->Group Pricing screen.
Zen Cart Per User Group Specials

The list of Per User/Group specials is shown on its own screen. Of course it looks similar to the regular Specials screen. It can be directly accessed by going to the Admin->Customers->Per User Group Specials.
Zen Cart Per User Group Specials
The currently selected row shows on the right of this screen.
Zen Cart Per User Group Specials
For User Specials, the name of the user is shown. For Group Specials, the name of the group is shown. You can also see the date range for this special (if there is one) and how the price display will look for the user(s) who receive this special.

Editing looks like editing a special, except there are dropdown boxes for group or customer id.
Zen Cart Per User Group Specials

Catalog Appearance

On the catalog side, Per User/Group Specials look like any other special. To see them, a customer must login (so that their group and customer number are known to the system).
Zen Cart Per User Group Specials

Specials are not like Order Total modules; items on special have their lowered prices reflected throughout the shopping experience. (Order Total modules, by contrast, create discounts which are only shown at checkout time by default.)

Here is the on special item shown in the shopping cart.
Zen Cart Per User Group Specials

Installation Instructions:

  1. Back up everything! Try this in a test environment prior to installing it on a live shop.
  2. Unzip the file you have received
  3. Take the file per_user_group_specials.sql and run it in Admin->Tools->Install SQL Patches.
  4. Change directory to the common_files folder. Copy the contents to the root directory of your shop.
  5. Go back up a level, and change directory to the premerged folder. Change directory to the version of Zen Cart closest to (but not greater than) the version your cart is using. If you have not changed any of these files, you can just copy the ones in this folder to your cart (in the same structure). If you have changed them, see the README.txt included with the mod for the details on how to change each file.

Installation Problems:

The most common installation problems for this module are as follows:
  1. If you upload the files in this mod prior to creating the required tables, you will get a blank page. To fix this, revert the file admin/includes/init_includes/init_special_funcs.php to to the version before you installed this mod (or comment out the four lines starting with "pugs_"), then go to your admin and run per_user_group_specials.sql in Admin->Tools->Install SQL Patches. Then put back the changes to admin/includes/init_includes/init_special_funcs.php from this mod.

Major Versions

  • Version 1.3 10/01/2016 - Addition of Sale support for 1.5.4, 1.5.5a.
  • Version 1.2 05/09/2016 - Updates for Zen Cart 1.5.5, 1.5.5a.
  • Version 1.1 - 01/03/2015 - Updates for Zen Cart 1.5.4.
  • Version 1.0 - 01/01/2014 - First Release.


  • Any modification which (like this one) selectively lowers prices in the cart cannot update the products.products_price_sorter field, which enables such things as searching by price range on the Advanced Search page, and sorting by price on a Listing page. Thus, features which depend on this field will operate as though there were no per user or group special prices. (For most shops this is a non-issue but it is listed for completeness.)
  • I should have created indexes on customers_id and customers_group_pricing fields in the per_user_group_specials table. If you have version 1.2 or prior of this mod, you can do this within Admin->Tools->Install SQL Patches.
    ALTER TABLE per_user_group_specials ADD INDEX idx_cust_id(customers_id);
    ALTER TABLE per_user_group_specials ADD INDEX idx_cust_group(customers_group_pricing); 


Q: How do I install this software?
A: If you've never installed a Zen Cart mod before, please read my Guide to Mod Installation on Zen Cart.

I charge a fee of $60 for Per User/Group Specials. Buy Now!
The fee covers software only; installation is extra if you require help.