Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18
  1. #11
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: How to set up Quantity Discounts??

    The category is id the master_categories_id of your product. Be sure this field is set correctly in the products table. (If it's a linked product, it may not be what you think it is.)

    http://www.thatsoftwareguy.com/zenca...ry_issues.html
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  2. #12

    Default Re: How to set up Quantity Discounts??

    Quote Originally Posted by swguy View Post
    The category is id the master_categories_id of your product. Be sure this field is set correctly in the products table. (If it's a linked product, it may not be what you think it is.)

    http://www.thatsoftwareguy.com/zenca...ry_issues.html
    OK, I went to MySQL (gulp!) and I got this to display using browse:

    Full Texts categories_id language_id categories_name categories_description
    Edit Delete 65 1 CD Box
    Edit Delete 66 1 Bracelets MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 67 1 Zippo Lighters
    Edit Delete 68 1 ClassyWraps MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 69 1 CD Trays
    Edit Delete 70 1 Digi Trays
    Edit Delete 71 1 DVD Boxes
    Edit Delete 73 1 Game Cases
    Edit Delete 74 1 Incense MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 75 1 Gift Wraps MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 76 1 JiffyWraps MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 77 1 Sleeves
    Edit Delete 78 1 CD Sleeves
    Edit Delete 79 1 LP Sleeves
    Edit Delete 80 1 Comic Book Sleeves
    Edit Delete 81 1 45 Sleeves
    Edit Delete 82 1 DVD Sleeves
    Edit Delete 83 1 Shrinkwrap
    Edit Delete 87 1 CD Frames MIX N MATCH DISCOUNTING available for this categor...
    Edit Delete 86 1 LP Album Frames MIX N MATCH DISCOUNTING available for this categor...

    Obviously, the ones with the MIX N MATCH are the ones I want to use your discount on. The balance to be excluded. I did not use link product at all so I think these category ids are good. Any other ideas?
    Sherry

    Zen Cart 1.3.9e

  3. #13
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: How to set up Quantity Discounts??

    You're looking at the wrong table. Products table, master_categories_id. Follow the link I posted; it's explained there.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  4. #14

    Default Re: How to set up Quantity Discounts??

    Quote Originally Posted by swguy View Post
    You're looking at the wrong table. Products table, master_categories_id. Follow the link I posted; it's explained there.
    Hi Scott,

    I finally figured out what is going on. I imported my products from QB into the categories I had setup. I had an idea so I also tried to move products from one category to another and the same thing happens. No Product Master Category number gets generated. It displays "0" for that product. The Product Master Category number will generate only if I create a new product one by one in that category. Is there an easy fix for this?
    Sherry

    Zen Cart 1.3.9e

  5. #15
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: How to set up Quantity Discounts??

    Again, please take the time to follow the link I posted.

    Look for the phrase "This is the most common root cause of category problems." It's in bold. You can't miss it.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  6. #16

    Default Re: How to set up Quantity Discounts??

    Quote Originally Posted by swguy View Post
    Again, please take the time to follow the link I posted.

    Look for the phrase "This is the most common root cause of category problems." It's in bold. You can't miss it.
    Sorry I guess I've been "working" on this a bit to long.
    Sherry

    Zen Cart 1.3.9e

  7. #17

    Default Re: How to set up Quantity Discounts??

    Quote Originally Posted by VGlide View Post
    Sorry I guess I've been "working" on this a bit to long.
    OK, categories are all fixed. I turned off your discounts before running the category fix. After the categories were fixed, I then turned your discounts back on. Discounts 1-5 work fine. I had added a Discount 6 but, it does not calculate now. It did before I turned off
    because I had played with the percentages to make sure they were good for me. Is it something simple to edit?
    Sherry

    Zen Cart 1.3.9e

  8. #18
    Join Date
    Dec 2010
    Posts
    60
    Plugin Contributions
    0

    Default Re: How to set up Quantity Discounts??

    Version 1.3.9
    I am going crazy with product discounts. i have product discounts and options for products. The options do not affect pricing as they are just colors and such. I have a page where if I add 10 of one product in black and a 1000 in red it works right for some of the products and not others on the page. 9they should be different prices)

    Fred McCaughey
    www.idsupply.co
    [email protected]

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. How do I hide the Quantity Discounts box?
    By piranetus in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 11 Aug 2010, 11:19 PM
  2. Quantity Discounts - how do I enable?
    By cs_jono in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 7 Apr 2010, 03:58 AM
  3. How to configure Case Quantity Discounts
    By pico1079 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 7
    Last Post: 14 Feb 2008, 05:04 PM
  4. How to change quantity discounts table view
    By manada in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 5
    Last Post: 5 Oct 2006, 05:08 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