Page 10 of 10 FirstFirst ... 8910
Results 91 to 96 of 96
  1. #91
    Join Date
    May 2009
    Posts
    95
    Plugin Contributions
    0

    Default Re: Twitch Restrict Categories by Customer or Group

    Thank you for the great add-on.

    I have having an issue with the new product & featured page. I have set up as a single product linked to multiple categories. For example if an item 1TW is linked to 3 categories and if I set it item a featured then I see that on the featured page this item is displayed three times. The page works fine if the item is only set to one category.
    After looking in to the codes( I am not a good programmer) found that includes/pages/featured/header_php.php has the code. How do I make change in the query to take only one one row instead of three rows from TABLE_PRODUCTS_TO_CATEGORIES?

    $featured_products_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
    p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping,
    p.products_qty_box_status, p.master_categories_id
    FROM ("
    . TABLE_PRODUCTS . " p
    LEFT JOIN " . TABLE_MANUFACTURERS . " m
    on (p.manufacturers_id = m.manufacturers_id),
    "
    . TABLE_PRODUCTS_DESCRIPTION . " pd
    LEFT JOIN " . TABLE_FEATURED . " f
    on pd.products_id = f.products_id,
    "
    . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
    LEFT JOIN " . TABLE_CATEGORIES_CUSTOMERS . " ccu
    on p2c.categories_id = ccu.categories_id

    )
    WHERE p.products_status = 1
    and p.products_id = f.products_id
    and f.status = 1
    AND p.products_id = pd.products_id
    and pd.language_id = :languagesID
    AND p.products_id = p2c.products_id

    AND (ccu.customers_cat_group = '" . (int)$_SESSION['customers_cat_group'] . "' OR ccu.customers_cat_group = '0' )

    " . $order_by;

    Thanks so much for any help!

  2. #92
    Join Date
    Mar 2006
    Location
    Auckland, New Zealand
    Posts
    173
    Plugin Contributions
    0

    Default Re: Twitch Restrict Categories by Customer or Group

    Just wondering if this module is being upgraded to 1.5.7? :-)
    Elemi

    The Art of Bespoke Aromatherapy
    www.AmorAromatherapy.co.nz

  3. #93
    Join Date
    Jul 2012
    Posts
    345
    Plugin Contributions
    0

    Default Re: Twitch Restrict Categories by Customer or Group

    This is not working for 1.5.6. In admin/categories.php file codes are very different. Do you have updated version of this?

  4. #94
    Join Date
    Jun 2016
    Location
    Suffolk VA
    Posts
    425
    Plugin Contributions
    0

    Default Re: Twitch Restrict Categories by Customer or Group

    Here's another person who would really like this to work with 1.5.6 and up.

  5. #95
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,688
    Plugin Contributions
    22

    Default Re: Twitch Restrict Categories by Customer or Group

    This module is being included in the next release of Twitch Wholesale PRO Public/Commercial for ZC 1.56c as the Twitch Bridge Matrix now handles product and category level relationships with customer groups using the new wsPRO Manager in Admin.

    Release is pending imminently for Zen Cart 1.56c and will be next on the list for development into ZC 1.57c when funding/donations afford it.

    Thanks for your support!
    Twitch.
    http://www.twitchtoo.com - Do you work for free? Please donate.
    Twitch Wholesale PRO, ZC 1.38 - 1.57c - Expert Site Migration & Upgrades!

  6. #96
    Join Date
    May 2009
    Posts
    95
    Plugin Contributions
    0

    Default Re: Twitch Restrict Categories by Customer or Group

    Thank you for the great mod.

    I am having an issue with this module in the mobile version.
    1)
    The sidebox categories box displays all the categories if a customer is not logged in. I want to hide the sidebox category when the customer is not logged in on mobile. Works fine on the Desktop version.

    2) In the mobile version It shows all the categories when a customer is logged in ( means it is not hiding some categories based on the category group of the customer). Does not show the products through but shows category names and this defeats the purpose of hiding categories

    Did anyone solve this issue? I have picture attached to show this. The first two categories are only for a specific group.Name:  Capture.JPG
Views: 20
Size:  32.3 KB

    Thanks

 

 
Page 10 of 10 FirstFirst ... 8910

Similar Threads

  1. Group Pricing - how can I restrict against certain categories?
    By DodgeGirl in forum Setting Up Categories, Products, Attributes
    Replies: 26
    Last Post: 2 Jun 2011, 09:20 PM
  2. How to restrict access for specific categories to registered customer?
    By tutebarra in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 28 Apr 2011, 03:20 PM
  3. Restrict Customer access to certain products or product categories.
    By henryk in forum Managing Customers and Orders
    Replies: 1
    Last Post: 27 Nov 2008, 08:45 AM
  4. Restrict Ordering Process for One Customer / Group
    By blackpig in forum Managing Customers and Orders
    Replies: 3
    Last Post: 17 Jun 2008, 05:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR