15% Discount

We use a 15% discount coupon quite a bit. This discount applies to the whole order except for items already on sale.

Questions:

  1. What is the easiest way to allow regular cashiers that don't have discount privileges to ring this up without Manager or Supervisor involvement? (Set up a 15% generic customer for this?)
  2. How do I keep on sale items from being discounted again? In other words if an item is on sale it should not receive the 15% discount on top of the sales price.
  3. We also have buy 1 get 2nd half price items, in this case neither one of these two product need to be given a 15% discount since they are discounted already, how do I accomplish or rather prevent this?

Any suggestions or solutions would be appreciated!

Reply to
Alex
Loading thread data ...

You would use the "Item not discountable at the POS' selection on the Item|Options tab to accomplish this.

Rick Brown DataBasics

Reply to
Rick Brown

Sorry, but which one of the original questions are you referring to or answering?

Keep in mind that I (obviously) want to give the customer the best discount available and that the buy 1 get 1 50% off items are all priced differently!

Anybody?

Reply to
Alex

I think what Rick is referring to is the items that are 'on sale'. When you set the items as on sale, also check the 'not discountable' option. It sounds like you may have too many criteria for RMS to resolve.

For example, take this three-item transaction:

Item #1 = buy one get one 50% off. - full price item qualifies for the 15% coupon? - half price item definitely not

  • item not discountable may or may not work - possible conflict with half price item?

Item #2 = in-store sale, 25% off - item does not qualify

  • item not discountable should work perfectly

Item #3 = regular price - item qualifies for 15% off coupon

  • item not discountable does not apply, discount should be applied.

Does the potential conflict with item #1 cause trouble with the other items? If not, Rick's suggestion may work for you.

Are there other potential discount scenarios in effect?

Setting the 'not discountable flag' would probably take a lot of time unless you used a query.

I think that this query: UPDATE Item SET ItemNotDiscountable = 1 WHERE SaleType 0 Would accomplish the task.

Run queries at your own risk. You should always backup first. It's best if you do it after hours just in case you screw things up and need to restore.

HTH, Tom

Reply to
Terrible Tom

These scripts might work a little better if your sale is based on a timeframe

UPDATE Item SET ItemNotDiscountable = 1 WHERE SalePrice 0 AND CONVERT(datetime, CONVERT(nvarchar, SaleStartDate, 101), 101) CONVERT(datetime, CONVERT(nvarchar, GETDATE(), 101), 101)

Reply to
CptSoft

We have a promotion module which might help you out.

Reply to
Afshin Alikhani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.