1. Home
  2. Point-Of-Sale Software
  3. Night Owl Sales for Holidays

Night Owl Sales for Holidays

I want to set up some sales for selected items and change the "selected items" weekly from now until Christmas and I want the sales ONLY to be for a time period of 6pm-9pm Wed-Thr-Fri as Night Owl Special for the Holidays.

I set up the time frame in Weekly Schedule & it tells me to go to "putting items on sale" to apply it to multiple items - There is no way to select "Schedule" - only date ranges in the Items pricing Wizard. If I open each individual item it allows me to slecet the weekly schedule OR the date range BUT not both.

I want to use the wizard for a department or category or filter & apply both a date range and a time range. HOW can I accomplish this?

Example: Wed-Thr-Fri, Nov 28, 29 & 30 from 6pm-9pm put a category1 on discount Wed-Thr-Fri, Dec 5, 6 & 7 from 6pm-9pm put a category2 on discount (category1 is now back to regular price) Wed-Thr-Fri, Dec 12, 13 & 14 from 6pm-9pm put a category3 on discount (category1 & category2 are now back to regular price)

Can this be done in RMS???

Reply to
Kathryn WOJ
Loading thread data ...

hi, I know all these facilities are not there, but off course you will put the schedule the give certain discount. some procedure are available in RMS like setting the time periods and discounts, however from which time to which time works it is currently manually. I am writing below the procedure follow this (some is from system and some manual)

you already said that you use the wizard to assigned the appropriate discount and time line for certain catogory, now the next step is manual do as it :

Clic on SO administrator program | Click on File | Connect | Click on Query | NEW Write below the query:

Update item Set SaleScheduleID=Schedule.ID From Category,Schedule Where Category.ID=Item.CategoryID and Schedule.description='Week' and Category.Code IN ('Category1','Category2','Cateogry3')

Change above the Schedule.Description to the Scehdule you created , as all the schedule has one time 6:00 pm to 9:00 pm so we no need to create multiple scheudle one is enought. Run the query and it will update all the relvant records. test it and once you satisfied rate this.

"Kathryn WOJ" wrote:

Reply to
Akber Alwani

Reply to
Kathryn WOJ

In the Wizard I set category name 'tumbled stones' (category id '18') to be

20% off for today - then I set up a schedule named 'test sale' to apply the schedule from 3pm to 315pm on Mondays.

I went to Adminstrator - ran the query below It ran successfully but zero records were affected.

Update Item Set SaleScheduleID=Schedule.ID From Category,Schedule Where Category.ID=Item.CategoryID and Schedule.description='test sale' and category.code IN ('Tumbled Stones')

tried this next - again it was successful but zero records were affected

Update Item Set SaleScheduleID=9 From Category,Schedule Where Category.ID=Item.CategoryID and Schedule.description='test sale' and category.code IN ('Tumbled Stones')

I guess I need more clarity on this formula.

"Akber Alwani" wrote:

Reply to
Kathryn WOJ

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.