Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11
  1. #11
    Join Date
    Sep 2009
    Posts
    40
    Plugin Contributions
    0

    Default Re: How to add discount to item for only one attribute value?

    BTW, here is the SQL script I ran to update my 11" size to set the Apply Discount attributes flag to NO.

    Code:
    update zen_products_attributes
    
    set attributes_discounted=0
    
    where (options_id=25 and options_values_id=3)
    options_id=25 is the Option Name - Size

    options_values_id=3 is the Option Value - 11"

    You will have to apply the id's for your Option Names and Option Values.

    To set to YES, set attributes_discounted=1

    (as always, BACKUP YOUR DATABASE BEFORE RUNNING SCRIPTS!)

    Good Luck.
    Last edited by kavlito; 6 Dec 2010 at 10:15 PM.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Attribute Grid / Quantity Discount only one attribute
    By quattro in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 21 Jan 2011, 10:07 AM
  2. How do I add quantity to one specific size for one Item?
    By Moy2005 in forum Setting Up Categories, Products, Attributes
    Replies: 18
    Last Post: 20 Oct 2008, 07:45 PM
  3. how to add a discount for second item purchased etc
    By sendmenews in forum General Questions
    Replies: 0
    Last Post: 13 May 2008, 09:52 PM
  4. Drop down with only one value in attribute
    By justinae in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 6 Dec 2007, 06:08 AM
  5. How to allow mixed attributes for one attribute only?
    By adflkajdlfkajefiaudl in forum General Questions
    Replies: 1
    Last Post: 22 Apr 2007, 05:55 PM

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