Results 1 to 9 of 9
  1. #1
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Is it possible to hide products in a category from showing in specials?

    Scenario: A category where all products remain perpetually discounted. Basically I want to show the retail price and a wholesale price for each item. I can't use salemaker because the discounts are not uniform across all items. I can use specials and set each, but then they would all, (over 100 items), appear in specials. Not an acceptable alternative. Is there a way to hide just this category so that the products do not show in specials? Barring that, is there a plugin that would allow me to set a sale price at the individual product level?

    Note: I already played around with the MSRP mod. It doesn't work for what I want to do.

  2. #2
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Is it possible to hide products in a category from showing in specials?

    Specials are displayed through a process similar to this:
    Once identified as a special, the product id is added to the products_to_categories table such that it is associated with the specials category id that is defined in the admin control panel for configuration->specials...

    My suggestion instead of hacking the specials code would be to see/use a notifier in the specials code that follows the addition of the product to the products_to_categories table (or perhaps just before to prevent further processing of it). To investigate the category and if it is in the category(ies) or meets other requirements, then to not add it to that table or to remove it from the table. (Depends on which notifier, what condition the data is in at the time, etc...)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Is it possible to hide products in a category from showing in specials?

    Quote Originally Posted by RescoCCC View Post
    Scenario: A category where all products remain perpetually discounted. Basically I want to show the retail price and a wholesale price for each item. I can't use salemaker because the discounts are not uniform across all items. I can use specials and set each, but then they would all, (over 100 items), appear in specials. Not an acceptable alternative. Is there a way to hide just this category so that the products do not show in specials? Barring that, is there a plugin that would allow me to set a sale price at the individual product level?

    Note: I already played around with the MSRP mod. It doesn't work for what I want to do.
    Have a look at the Twitch Restrict module (category based product level restriction), it works with Twitch Wholesale and both stock ZC Specials and Sales.
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  4. #4
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: Is it possible to hide products in a category from showing in specials?

    Thanks for the suggestions, I really appreciate it. Tried, and not working for what I'm trying to do. Let me ask another way. Is there any way to set sale prices for individual items? Is there a plugin for this? The issues I'm running in to with the various mods I've tried are 1) They nuke the ability to calculate sales tax, 2) The discounted prices doesn't show in the product listing display, and 3) Since group pricing is involved, a user must be logged in to see discounted prices. I need the discounted prices to be visible whether logged in or not.

  5. #5
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Is it possible to hide products in a category from showing in specials?

    Okay lets try it this way:

    1 - you're using zc stock group pricing module as 'wholesale customers' yes?

    2 - where exactly do you want to see the 'sale' prices?

    3 - are you using % or $ amount or manual enter for sale prices? or what's your preference?

    4 - how do you intend to manage sale prices? meaning:
    a - i want to manually enter them in on a product listing and just quickly run down the list and change the field
    b - i want to navigate to each product and make changes to it's pricing
    c - i want to use the default ZC Specials or SaleMaker already in admin

    5 - are you running any attributes or 'priced by attribute' ?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  6. #6
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: Is it possible to hide products in a category from showing in specials?

    Quote Originally Posted by twitchtoo View Post
    Okay lets try it this way:

    1 - you're using zc stock group pricing module as 'wholesale customers' yes?

    2 - where exactly do you want to see the 'sale' prices?

    3 - are you using % or $ amount or manual enter for sale prices? or what's your preference?

    4 - how do you intend to manage sale prices? meaning:
    a - i want to manually enter them in on a product listing and just quickly run down the list and change the field
    b - i want to navigate to each product and make changes to it's pricing
    c - i want to use the default ZC Specials or SaleMaker already in admin

    5 - are you running any attributes or 'priced by attribute' ?
    1. Yep, using the native ZC group pricing, but I'm not actually using it to provide different pricing. I have one group set up and everybody who creates an account is automatically added to the group. I'm using it in conjunction with the Invoice mod so that customers can select "invoice me" during checkout and get instant credit set up, (after verification of info, of course). There is no tiered pricing.

    2. I'd like to see the sale prices in the product listing. In other words, when a customer opens the category they see both prices. This category is for building supply packs from a list of about 100 different products. The goal is for the customer to get an idea of how much profit they can realize by selling the packs they build.

    3. Preference is manual entry of actual prices. But I can make percentage work IF I can do it on an individual product basis. The discount is not uniform across all items. The spread between wholesale and retail selling price varies from product to product. I'd also note, that this is the only category where I need to do this.

    4. a&b Either way is fine.
    c. Salemaker won't work because the discount is not uniform across all products in the category. I could use Specials IF if I can hide the products in this one category from showing up in Specials.

    5. There are no attributes for the products in the category.

  7. #7
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Is it possible to hide products in a category from showing in specials?

    Quote Originally Posted by RescoCCC View Post
    1. Yep, using the native ZC group pricing, but I'm not actually using it to provide different pricing. I have one group set up and everybody who creates an account is automatically added to the group. I'm using it in conjunction with the Invoice mod so that customers can select "invoice me" during checkout and get instant credit set up, (after verification of info, of course). There is no tiered pricing.

    2. I'd like to see the sale prices in the product listing. In other words, when a customer opens the category they see both prices. This category is for building supply packs from a list of about 100 different products. The goal is for the customer to get an idea of how much profit they can realize by selling the packs they build.

    3. Preference is manual entry of actual prices. But I can make percentage work IF I can do it on an individual product basis. The discount is not uniform across all items. The spread between wholesale and retail selling price varies from product to product. I'd also note, that this is the only category where I need to do this.

    4. a&b Either way is fine.
    c. Salemaker won't work because the discount is not uniform across all products in the category. I could use Specials IF if I can hide the products in this one category from showing up in Specials.

    5. There are no attributes for the products in the category.
    Ask the right questions, get the right answers... NOW I understand what you want need and how your using zc, thank you.

    I'm not directly aware of any combination of settings or modules that will make somethings so simple as:
    Base Price - Price shop owner pays (Twitch Base Cost)(static)
    Retail Price - Guest/Public retail price (Stock ZC)(static)
    Retail Gross Price - Retail price including taxes (Stock ZC)(dynamic)
    Wholesale Price - Price wholesaler pays (Twitch Wholesale)
    List Price/MSRP - Dealer price or desired market value (Twitch List Price)

    Sale Price - Discounted price retail customer pays (Nothing)
    Wholesale Sale Price - Discounted price retail customer pays (Nothing)

    So, you need a 'sale' price that will statically remain in the database, be manually entered per product and only available to customers belonging to a Group Pricing - Group.

    This I can develop

    All the meaty bits are done in the various Twitch modules l've listed above... there simply isn't a field called static_sale_price and static_sale_price_w in the product table. And of course there needs to be a code that displays the sale price then applies it to every step along the checkout process from the shopping cart, checkout, completed order, email confirmation and then in admin (Fortunately Twitch List Price already follows this path)

    If you'd like it built - feel free to PM or email me.
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  8. #8
    Join Date
    May 2010
    Location
    WA State
    Posts
    1,678
    Plugin Contributions
    3

    Default Re: Is it possible to hide products in a category from showing in specials?

    Thanks for the offer. I accomplished what I needed to do by using JS that automatically shows the profit to the customer as items are added.

  9. #9
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: Is it possible to hide products in a category from showing in specials?

    Great! One question how does the java handle the pricing/taxes through rest of the shopping cart?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

 

 

Similar Threads

  1. Replies: 16
    Last Post: 2 May 2014, 10:07 PM
  2. Hide upcoming products from all and category listings
    By jmsnyder23 in forum Templates, Stylesheets, Page Layout
    Replies: 8
    Last Post: 8 Mar 2012, 02:44 PM
  3. Stop Disabled Products From Showing in New Products for Category?
    By way10c in forum Customization from the Admin
    Replies: 10
    Last Post: 14 Mar 2011, 03:52 AM
  4. It's possible to hide products from some client Groups?
    By intersol in forum General Questions
    Replies: 5
    Last Post: 13 Mar 2008, 12:42 AM
  5. Can you hide everything from public viewers, showing products only after they login?
    By duran.goodyear in forum Managing Customers and Orders
    Replies: 3
    Last Post: 29 Jan 2008, 07:44 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