Results 1 to 9 of 9
  1. #1
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Is it possible to do this?

    I set sale prices on items for a week all the time, but I want the sale price to NOT impact any chosen attribute addons for the listings...

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

    Default Re: Is it possible to do this?

    First, what are you using to apply the sale pricing?

    Second a code filter could shelter the products/attributes.
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  3. #3
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Re: Is it possible to do this?

    Quote Originally Posted by twitchtoo View Post
    First, what are you using to apply the sale pricing?

    Second a code filter could shelter the products/attributes.
    I'm just going into admin > catalog > specials to add the item and set the dates beginning and end.

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

    Default Re: Is it possible to do this?

    How would you like the sheltered products/attributes to work?

    Using:

    - relational or associative connection with product

    - category

    - 3rd variable filter

    - customer group

    - price range

    - attribute group

    - delivery location

    or some unique method your business uses that I missed?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  5. #5
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Re: Is it possible to do this?

    I just want all attributes to be imune to price adjustments via sale or removing sale price.

    Impacting all categories

  6. #6
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: Is it possible to do this?

    In each attribute you would have to use the "Apply Discounts Used by Product Special/Sale: Y/N" setting. This setting is in the edit attribute page's "rainbow" bar =)

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  7. #7
    Join Date
    May 2016
    Location
    Ohio
    Posts
    407
    Plugin Contributions
    0

    Default Re: Is it possible to do this?

    But if I have added the attribute to a thousand products, lets say, is there a SQL code I could use to apply it to everything at once or do I have to change them to all special items and as I add new items on special? I'll try it the manual way right now, thank you Melanie!!!

    Update: Applying it manually to each item on special is working, thank you!

    It would be nice if I could change them all at once though.
    Last edited by jmberman; 16 Jan 2020 at 05:23 PM.

  8. #8
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: Is it possible to do this?

    Backup first

    Code:
    UPDATE `products_attributes` SET `attributes_discounted` = '1' WHERE `products_attributes`.`attributes_discounted` = 0;
    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  9. #9
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Is it possible to do this?

    You could try this in phpmyadmin to change all products at once
    Code:
    UPDATE products_attributes SET attributes_discounted = 1
    Beware, I did not test this, and make a backup of your database before doing this

 

 

Similar Threads

  1. Is this possible?
    By RobWUK in forum Setting Up Specials and SaleMaker
    Replies: 0
    Last Post: 28 Sep 2009, 11:02 AM
  2. Is this possible?
    By xmisspurrfect in forum General Questions
    Replies: 3
    Last Post: 7 Feb 2008, 05:27 PM
  3. Is this possible with this site
    By chosin78 in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 5 Feb 2008, 08:06 PM
  4. Is this possible?
    By julia44 in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 2 Jan 2007, 06:26 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