Discounts/Promotions Reports

Seems like the values in the quantitydiscountid field in the item table are 0 for no discount, 1 for mix and match, 2 for buy x get y, and 3 for qty schedule; In store ops administrator connect to your db and run the following query BACKUP FIRST......

select * from item where quantitydiscountid = 1

this will show you all the items that have a "mix and match" discount scheme

then go to file - export - and save the result as a csv file on your desktop (or my documents), which you can then open with excel

H> Does anybody have a report which would show what discounts are set up, and

Not exactly...

item.quantityDiscountID links to quantityDiscount.ID quantityDiscount.Type defines the type of discount

I don't have a list of the discount type IDs readily available, sorry...

Glenn Adams Tiber Creek C> Seems like the values in the quantitydiscountid field in the item table are 0

I understood the question as being wanting to list items that have a discount scheme (at the item level) assigned, whether it was buy x get y or a mix and match discount - if that's the case it appears the select query will do just that Tested fine on my store ops admin.

If the questi> Not exactly...

Couldn't figure out a single query that would do the trick, you can always do it in two steps....

first run the following query, it will list all the discount schemes you've created select id, description, type from quantitydiscount

jot down the discount scheme ID you want to report against

then run select itemlookupcode, description from item where quantitydiscountid = x (where x is the ID you want to report against)

sorry if my > Does anybody have a report which would show what discounts are set up, and

Perfect Guys, thanks for your help on this one!!