Night Owl Sales for Holidays


K

Kathryn WOJ

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???
 
Ad

Advertisements

A

Akber Alwani

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.
 
K

Kathryn WOJ

I will run the test today - thanks - I will let you know how it works.
 
Ad

Advertisements

K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top