How can I block an entire category of items for a specific time and make them unavailable for sale?

(0) Share

Report

Posted on by Corey Hardersen

I see that if you go to Database, then schedules, one can create a schedule for a particular product to be unavailable for sale, that is not allow the product to be rung up in the POS program. For example: Liquor cannot be sold on sundays before 12PM, therefor when a employee attempts to scan liquor it blocks the item from going on the order. Is there a way I can select the entire category of Liquor and block all of the items in that category to a specific time? Currently I can go to each item in my database, and block it under the schedule I have created. But there has to be a better way than going item by item. Help?

*This post is locked for comments

All responses (2)

Answers (0)

Ryan Sakry 3,425 on at

Like (0)

Report

Re: How can I block an entire category of items for a specific time and make them unavailable for sale?

Corey,

Tim is correct and his SQL Statement is sound and should work as advertised. If you are interested in creating something custom that you can use on a regular basis, please let me know and we can discuss what it would take to make happen.

Tim,

Thanks for the name drop :-)
Suggested answer

TimB 1,175 on at

Like (0)

Report

Re: How can I block an entire category of items for a specific time and make them unavailable for sale?

RMS has no inbuilt capability of adding blocks by category. You could contact Ryan from RITE rsakry@rite.us for a custom program to do it or use the following SQL code if you feel comfortable doing it. Just edit the bold values to the values that match your config. You need to have created a schedule and put it's name in the bold Liquor field.

declare @CategoryID int

declare @ScheduleID int

set @CategoryID = (select id from category where name = 'Liquor')

set @ScheduleID = (select id from schedule where description = 'Sunday')

update item

set blocksalestype=2,

BlockSalesScheduleID=@ScheduleID

where categoryid = @categoryid

Hope this helps...