How to set up Quantity Discounts??

[swguy]

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

[VGlide]

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?

[swguy]

You're looking at the wrong table. Products table, master_categories_id. Follow the link I posted; it's explained there.

[VGlide]

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?

[swguy]

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.

[VGlide]

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.

[VGlide]

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?

[fredmccay]

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
fred@idsupply.co