Twitch Wholesale with Twitch Wholesale Attributes

Thanks Twitch,

Just downloaded a copy, look forward to trying it.

Goshawk

There now exists a version **Twitch WS + Att - STD - 18d Certified ~ November 19.2018 **which performs the following update to the CORE Charge dashboard display.

YOUR_ADMIN/index_dashboard.php

replace line 162-193

            echo '<div class="row"><span ><a href="' . zen_href_link(FILENAME_ORDERS, 'oID=' . $orders->fields['orders_id'] . '&origin=' . FILENAME_DEFAULT, 'NONSSL') . '" class="contentlink"> ' . $orders->fields['customers_name'] . '</a>';
            
            echo '<span class="right">';
            
            echo '<strong>' . $orders->fields['order_total'] . '</strong><br/>';
            
            echo '' . zen_date_short($orders->fields['date_purchased']);

            echo '</span>';
// bof Twitch display CORE Charges per order
// loop through products matched to the current order_id
$matchOrder = $orders->fields['orders_id'];

$findCoresql = $db->Execute("select orders_id, products_options, options_values_price, options_values_price_w
                            from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES ."
                            where orders_id = '" . $matchOrder . "' 
                                  ");
    foreach ($findCoresql as $coreFound) {
    //print_r ($findCoresql);

    //if ($findCoresql->RecordCount() > 0) { // BOF print if records found
        // display wholesale price
        if ($orders->fields['customers_wholesale'] == '1') { 
            echo '<span class="left">CORE Charge ' . '<strong>WS $' . number_format($findCoresql->fields['options_values_price_w'], 2) . '</strong><br/></span>';
        } else {
        // display retail price
            echo '<span class="left">CORE Charge ' . '<strong>RT $' . number_format($findCoresql->fields['options_values_price'], 2) . '</strong><br/></span>';
        }
    // } // END print if records found
        }
// eof Twitch display CORE Charges per order
            echo ' </span></div>' . "\n";

with this:

            echo '<div class="row"><span ><a href="' . zen_href_link(FILENAME_ORDERS, 'oID=' . $orders->fields['orders_id'] . '&origin=' . FILENAME_DEFAULT, 'NONSSL') . '" class="contentlink"> ' . $orders->fields['customers_name'] . '</a>';
            
            echo '<span class="right">';
            
            echo '<strong>' . $orders->fields['order_total'] . '</strong><br/>';
            
            echo '' . zen_date_short($orders->fields['date_purchased']);

            echo '</span>';
// bof Twitch display CORE Charges per order
// loop through products matched to the current order_id - filter ws|rt customers_wholesale
$matchOrder = $orders->fields['orders_id'];

$findCoresql = $db->Execute("SELECT opa.orders_id, o.orders_id, opa.products_options, opa.options_values_price, opa.options_values_price_w, o.customers_wholesale
                            FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " opa left join " . TABLE_ORDERS . " o 
                            ON (opa.orders_id = o.orders_id)
                            WHERE opa.orders_id = '" . $matchOrder . "' 
                            AND opa.products_options = 'CORE Charge'
                                  ");
// Redoc Note: you can change or remove the line -  AND opa.products_options = 'CORE Charge' in the filter above to single out product options or hide the core charge display 
// find and match order ID to Customer ID/Wholesale switch in orders table                                  

    foreach ($findCoresql as $coreFound) {
    //print_r ($findCoresql);

    //if ($findCoresql->RecordCount() > 0) { // BOF print if records found
        // display wholesale price
        if ($findCoresql->fields['customers_wholesale'] == '1') { 
            echo '<span class="left">CORE Charge ' . '<strong>WS $' . number_format($findCoresql->fields['options_values_price_w'], 2) . '</strong><br/></span>';
        } elseif ($findCoresql->fields['customers_wholesale'] == '0') {
        // display retail price
            echo '<span class="left">CORE Charge ' . '<strong>RT $' . number_format($findCoresql->fields['options_values_price'], 2) . '</strong><br/></span>';
        } else {
        // print nothing
        }
    // } // END print if records found
        }
// eof Twitch display CORE Charges per order
            echo ' </span></div>' . "\n";

Now the lookup will split wholesale/retail core charge display correctly on the admin -> home page.

New! - Additional support is now available if you would like to filter an attribute other than 'core charges' in your store - simply match the 'CORE Charge' text to the **products_options **name of your liking.

Redoc Note: This bug caused no harm to the data - this was an output only display.

Great changes and additions to this module.

The installation of the old module used to take anywhere from 2- 4 hours to install (depending on stock carts versus custom carts) and now the new install is a fraction of the time!

Well done! Thanks so much; a donation for saving my time, was sent your way.

Trinity14:

Great changes and additions to this module.

The installation of the old module used to take anywhere from 2- 4 hours to install (depending on stock carts versus custom carts) and now the new install is a fraction of the time!

Well done! Thanks so much; a donation for saving my time, was sent your way.

Thanks Trinity! :lamo::cheers::clap:

This also applies to anyone using Twitch Wholesale as mirrored in the core **List Price **module found in the original post here:
https://www.zen-cart.com/showthread.php?212386-Twitch-List-Price-how-do-I-display-List-price&p=1353966#post1353966

To tie in the List Price ON/OFF switch in the Admin > Configuration > Product Listing

directly

to control the Product Info Display -** includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

Replace this:
<span class="productsList_price">List Price: $<?php echo $products_list_price; ?><br/></span>

With this:
**<?php if (PRODUCT_LIST_THE_LIST_PRICE >= '1') { ?>
<span class="productsList_price">List Price: $<?php echo $products_list_price; ?><br/></span>

<?php } ?>

v155f php7.1

I would just like to confirm that this plugin will override sale maker when activated, and any active promo coupons, such that a wholesale customer gets wholesale prices only and that the sale maker discount or coupon discount is not applied at bottom of transaction, i.e. any discount is negated.

cheers,
Mike

shags38:

v155f php7.1

I would just like to confirm that this plugin will override sale maker when activated, and any active promo coupons, such that a wholesale customer gets wholesale prices only and that the sale maker discount or coupon discount is not applied at bottom of transaction, i.e. any discount is negated.

cheers,
Mike

If the module has not been installed correctly this can happen...

***Alternately ***

There are add on's and filters available to correct this issue. Some are already mentioned or available on the forum, others have been custom coded to maintain the seemingly custom nature of wholesale business requirements for product pricing, sales, discount coupons and specials.

If you could provide more specific details and perhaps the conditions or other modules you have installed I'd be happy to help.

Module scheduled for update to 1.56c March.2020.

*Feature updates expected:
*
Master Wholesale ON/OFF switch
~ (beta) Turn the module on or off completely.

**Master WS/RT Group Management Control Center with Module Bridging Option
~ (beta) View, manage all pricing groups and their relative settings + (complete) toggle bridging to existing Zen Cart modules in one dashboard.

Example of a bridged module: Instead of using Twitch WS groups independently shop owners could used the stock Group Pricing groups and manage them using the default settings - retaining all of the functionality the new Twitch WS module offers - installing right into an existing shop.

Alternately you could bridge Zones with Twitch Wholesale groups to separate customers in any geographical zone for shipping, payment and delivery, etc.

**Static Multiple Pricing Levels including Multiple Attribute Pricing Levels
~ (beta) Multiple pricing levels for each product and their attributes.

Multiple Pricing Reports
~ (beta) Advanced reports updated to reflect pricing groups.

**Supplier Invoice Record with Search
~ (beta) Input supplier invoice, update stock view recorded supplier invoices.

Integrated Inventory Stock Tracking from Invoice Record
~ (beta) Connect Invoice Record with product stock/inventory for *inbound *shipping/receiving records.

Integrated WS/RT Payment/Shipping Control
~ (complete) WS/RT payment/shipping dashboard.

WS/RT Order Pick List
~ (complete) Customized order reports to use as paperless pick list for wholesale or retail.

Pending ! - Twitch Restrict
~ If there's enough time/funds I will be able to integrate this module for added site WS/RT separation and security not available in the stock cart.

As with previous releases this module will work independently or can be integrated to use or work with all existing stock Zen Cart modules - 3rd Party, pricing groups, payment, shipping, sales, specials, banners, etc.

Donations are always appreciated ~ Thank you for your continued support!

shags38:

v155f php7.1

I would just like to confirm that this plugin will override sale maker when activated, and any active promo coupons, such that a wholesale customer gets wholesale prices only and that the sale maker discount or coupon discount is not applied at bottom of transaction, i.e. any discount is negated.

cheers,
Mike

You'll need to install the WS/RT switch to each of the sale/discount locations to have them calculate correctly. Switches are available in the package or on the forum, you're more than welcome to contact me directly for assistance.

Twitch Wholesale Free Shipping Order Limit Switch - Mar.2020

Designed for use with 1.55f, most likely works with previous versions of Twitch Wholesale - be certain to file compare.

This switch allows control of Admin > Modules > Shipping > Free Shipping Options to set Order Total Min and Max for Retail and Wholesale separately during checkout.

These are core overwrites to ensure the override system defaults correctly.

Example:
Retail Customer - Free Shipping over $100
Wholesale Customer - Free Shipping over $500

For existing sites, record your current settings, REMOVE the shipping module in admin, then upload these files (file compare/overwrite) then refresh your admin page and click **INSTALL.

Failure to remove the old module and settings will prevent the new features from working correctly.**

https://twitchtoo.com/tR_codeSHOP/download/ZenCart_155f/TwitchWS_Free_Shipping_Order_Limit_Switch.zip

Your donations are appreciated :cheers:

Also, these features will be included in the newest release of Twitch WS for 1.56c - coming soon!

Does this mod allow you to create group discounts based on category? We have a dealer group that resells our products and the discount they receive is based on the category the products falls in. So each category has a different % discount.

Carbonless:

Does this mod allow you to create group discounts based on category? We have a dealer group that resells our products and the discount they receive is based on the category the products falls in. So each category has a different % discount.

The current public versions point at products, it's possible to point the code at the categories.

Future versions will have multi tier pricing and multiple target/source options to provide Twitch Restrict level control of each category, product and things like MRC Category Groups along with Twitch Product Level Control.

If you need a new custom module you could hire a coder, like me :)

How does one get hold of this module to try?...your site is down for maintenance.

torvista:

How does one get hold of this module to try?...your site is down for maintenance.

Post 150...? The download link for Twitch Wholesale Free Shipping Order Limit Switch remains active.

https://www.zen-cart.com/showthread.php?210792-Twitch-Wholesale-with-Twitch-Wholesale-Attributes&p=1366632#post1366632

Unfortunately the Code Shop is being discontinued. For now it remains a reference/showcase site as my focus is building all Twitch modules into Twitch Base6, Twitch Wholesale PRO and the Twitch Bridge Matrix :-D

If there's something specific you would like please contact me directly via PM or email - my site is in my signature below :-)

Thanks but I meant the Wholesale module....the Plugins download is just instructions.

Torvista, I just downloaded a copy from the plugins...

Read This First.txt explains the fileset is in **Step 5 - Add - Fast Quantity Updates.

**You'll still need to read the instructions to install the SQL patches correctly in this version.

Newer versions of Twitch Wholesale no longer include step-by-step installation instructions.

Is this plugin compatible with version 1.5.7c? I'd be installing it in a new installation of 1.5.7c with no other plugins except the Fluorspar template.

Twitch Wholesale for 1.55f - Public (current release) is compatible with Zen Cart 1.55f.

Twitch Wholesale for 1.56c - Public (pending release) is only compatible with Zen Cart 1.56c.

Twitch Wholesale for 1.57c - Public (in development) is only compatible with Zen Cart 1.57c.

twitchtoo:

Twitch Wholesale for 1.55f - Public (current release) is compatible with Zen Cart 1.55f.

Twitch Wholesale for 1.56c - Public (pending release) is only compatible with Zen Cart 1.56c.

Twitch Wholesale for 1.57c - Public (in development) is only compatible with Zen Cart 1.57c.

Does that mean I should not attempt to install the 1.55f version in a 1.57c environment? Or only that the 1.57c version will not work with earlier versions?

I built it and I would not try to make the jump from 1.55f to 1.57c as the module is far too integrated into the Zen core in every version.

Plus there are a host of new wholesale features you would be missing out on, and how would I or anyone else support any potential errors or future upgrades?

For those that can wait, the public version will be released shortly to the forum for 1.56c.

The best way to get the 1.57c version completed faster is by funding the project as a client of mine.

Currently my clients are being upgraded from 1.55f to 1.56c and will roll to 1.57c by year's end to meet the PHP 8 standards... https://www.php.net/supported-versions.php

** The life cycle of most Twitch modules...**

• idea (coffee)
• map code (volunteer hours)
• develop code to integrate into current Zen Cart as a plugin (donations and client funding)
• integrate into all other Twitch modules (Twitch Base6) (my time)
• test public and advanced client versions (donations and client funding)
• release
• support (volunteer hours)

** ...drink more coffee and repeat the cycle.**

Alternately if you have time and coding experience you could integrate it into your cart, or hire someone to 'get it working' as there are plenty of expert coders around and if I can do it it's not impossible to do!

:cheers: