Twitch Wholesale with Twitch Wholesale Attributes

[twitchtoo]

Twitch Wholesale with Twitch Wholesale Attributes
for ZenCart v1.51 - Version 13a
October 13.2013

This module will provide you with:
- guest/retail/wholesale login and independent landing/index pages for each
- wholesale filters for product pricing, attribute pricing and display purposes
- base price, list price, core charges (as attributes)
- wholesale prices that calculate properly with - 'product priced by attribute' and 'included in base price'
- wholesale filters are available for payment and shipping

How it works?
ZenCart has a flow, start to finish. You start as a guest, then sign up, then log in, shop and exit.

Without changing that flow, this module simply filters the display if you have a '1' beside your name.
- The 'if customers_wholesale switch absolutely equals 1' statements are the filters.
- Wholesale variables have _w added to them like product_price and product_price_w.
- This module does not change how any part of the cart works, it simply mirrors what already does work.

Important Notes:
This module has been coded as a 'price plus' addon, discount pricing/group pricing is not included in the wholesale filters.
- Yes it is possible to add the filters in.

Visit twitchtoo.com, click the ZenCart link, find this module in the list and view the final output screenshots.

Installing this module...
Twitch Base_Cost - optional
Twitch List_Price - optional
Twitch Wholesale
Twitch Wholesale Attributes

I would recommend installing all of the modules, chances are you'll need/use the other features in the future.

Background
Around 2011 I developed this module for ZenCart 1.39h, it's been working flawlessly ever since. Unfortunately a divorce got in the way of releasing a full version with instructions. So I spent the last 6 weeks rewriting it from scratch for ZenCart 1.51, testing the new version and recording each step along the way.

The resulting module is the baseline split for wholesale/retail that should come in every stock ZenCart 1.51.

See this module it in action!
http://www.twitchparts.com/

[100asa]

Very great works!
One suggestion: if special price is < wholesale price, wholesaler see and buy at special price; if special price is > wholesales price, wholesaler see and buy at whole price!
Or (better) wholesaler can't see special retail prices!
I've just installed your great contrib, and special price is always show, also by wholesaler.

[twitchtoo]

Thanks 100asa.

Please clearly define what you are calling the 'special price'.

When installed correctly guests can see the 'retail price', logged in retail customers see the same 'retail price' and if a wholesale customer logs in they will see the 'wholesale price'. The 'list price' will be seen by all customers regardless. The 'base price' is only viewable in admin.

As mentioned, this module has not been coded to filter any 'discount pricing' modules... but it's on the way :)

[100asa]

special price is the special offer of zencart default
see it at http://www.100asa.it/newcart/index.p...&products_id=3

[twitchtoo]

Thanks for the screenshot 100asa.

Your example uses ZenCart's default in Admin->Catalog->Specials
It applies a 'special price' to individual products.

Here's the filter you will need to hide the 'special price' entirely from wholesale customers:
includes/functions/functions_prices.php
replace line 25 - 31:

    $specials = $db->Execute("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and status='1'");
    if ($specials->RecordCount() > 0) {
//      if ($product->fields['products_priced_by_attribute'] == 1) {
        $special_price = $specials->fields['specials_new_products_price'];
    } else {
      $special_price = false;
    }

with this:

// bof Twitch Wholesale - Hide ZC Special Price from wholesale customer
if ($_SESSION['customers_wholesale']=='1') {
// Do not show wholesale customers the special price on any product
} else {

     $specials = $db->Execute("select specials_new_products_price from " .  TABLE_SPECIALS . " where products_id = '" . (int)$product_id . "' and  status='1'");
    if ($specials->RecordCount() > 0) {
//      if ($product->fields['products_priced_by_attribute'] == 1) {
        $special_price = $specials->fields['specials_new_products_price'];
    } else {
      $special_price = false;
    }
}
// eof Twitch Wholesale - Hide ZC Special Price from wholesale customer

Here's the before and after image tested on ZenCart v1.51 with Twitch Wholesale + Attributes installed:


Guests and Retail Customers will see the 'special price' as usual. There are no changes to the Admin.

[100asa]

Great, great, great: simply great!