Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

    Default Temporarily turn off quantity discounts?

    I just want to make sure that I'm not missing it. I need to temporarily disable quantity discounts while a special discount coupon is active. There are quantity discounts set for all products in the store. Before I start emptying the products_discount_quantity table I wanted to see if there was a config option in the admin that I'm missing that would turn this off. I know there's a switch in the attributes settings but that doesn't apply to the price manager.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Temporarily turn off quantity discounts?

    If you check your table:
    products

    Are all the records set to 0 and 1 for:
    products_discount_type_from

    And, as you say ALL products have discounts, did you find they are ALL set to the same value that is NOT 0?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Temporarily turn off quantity discounts?

    oops ... I am having you checking the wrong field ...

    Let's start again ...

    If you check your table:
    products

    Are all the records set to 0, 1, 2 or 3 for:
    products_discount_type

    And, as you say ALL products have discounts, did you find they are ALL set to the same value that is NOT 0?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #4
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

    Default Re: Temporarily turn off quantity discounts?

    Quote Originally Posted by Ajeh View Post
    If you check your table:
    products

    Are all the records set to 0 and 1 for:
    products_discount_type_from

    And, as you say ALL products have discounts, did you find they are ALL set to the same value that is NOT 0?
    Hi Ajeh,
    I checked the table and all are set to 0 or 1 but they are not all 1. I just did a quick install locally and in the absence of a setting I was able to export the contents of the product_discount_quantity table then delete all the rows. That took care of the discount quantities being applied. Then I imported the table back to get the quantity discounts back.

    I'm interested to see where you were going with the question though. Maybe a more elegant way to solve it. ;-)

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Temporarily turn off quantity discounts?

    The idea is, if the field:
    products_discount_type

    are all the same, non-zero value, switching the field:
    products_discount_type

    to 0 will turn OFF the Discount Quanties, without deleting the existing Discount Quantity settings ...

    Then, if they were all the same value for:
    products_discount_type

    such as 1 ... you could then set them all back to 1 when you want them all back on ...

    To turn them OFF use:
    Code:
    UPDATE products SET products_discount_type = 0;
    To turn them ON use, if the original value was 1:
    Code:
    UPDATE products SET products_discount_type = 1;
    NOTE: Be sure to make a backup first of your database and this ONLY works if ALL Products use Quantity Discounts of the same kind ... meaning if you see a mixture of 0, 1, 2 or 3 this will NOT work for you ...

    NOTE: The update can be run in the Tools ... Install SQL Patches ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Aug 2009
    Location
    Longs, SC
    Posts
    626
    Plugin Contributions
    2

    Default Re: Temporarily turn off quantity discounts?

    Thanks for that Ajeh. I checked and they are not all the same. Some are set to zero. Since I'd need to muck around with the table contents anyway I'll just empty the table and import it back when the special is over.

    I would be interested to see if this is a problem others have run into. I might just look at adding a switch to the admin as a mod if enough people are interested.

  7. #7
    Join Date
    May 2008
    Posts
    442
    Plugin Contributions
    1

    Default Re: Temporarily turn off quantity discounts?

    Quote Originally Posted by badarac View Post
    Thanks for that Ajeh. I checked and they are not all the same. Some are set to zero. Since I'd need to muck around with the table contents anyway I'll just empty the table and import it back when the special is over.

    I would be interested to see if this is a problem others have run into. I might just look at adding a switch to the admin as a mod if enough people are interested.

    I use the quantity discount module by swguy and have this issue all the time. When I run a certain coupon discount I have to empty out the tables as well would be much better if a simple enable true or false function existed.

 

 

Similar Threads

  1. Can I turn off my site temporarily?
    By bparker in forum General Questions
    Replies: 7
    Last Post: 19 May 2012, 08:23 AM
  2. Turn off discounts on attributes
    By kenwvs in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 9 Jan 2011, 02:50 PM
  3. Turn off Model/Weight/Quantity/Mfr
    By manutd98 in forum General Questions
    Replies: 2
    Last Post: 15 Jun 2009, 08:29 PM
  4. Turn off Quantity
    By conboy in forum General Questions
    Replies: 24
    Last Post: 22 Dec 2008, 09:40 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