Best practice for modeling Merchant business hours in CSM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
Hi Community,
I'm looking for guidance on the recommended design approach for modeling Merchant business hours in ServiceNow.
Use case
In our implementation, a Merchant is represented as an Account. Each Merchant corresponds to a single physical location, for example:
A 7-Eleven store
A Walmart store
A KFC restaurant
A small neighborhood convenience store or local grocery shop
Each Merchant has one or more POS devices installed, and field technicians may need to visit the site to perform maintenance or resolve incidents.
One of our requirements is to store the Merchant's business hours so technicians can easily identify when the location is open before scheduling or performing an onsite visit.
The challenge is that business hours can vary significantly depending on the type of Merchant. Large retail chains may have standardized schedules, while small neighborhood stores often have unique operating hours, different days of operation, or multiple business hour intervals throughout the day.
Some examples include:
Monday–Friday: 08:00–18:00
Monday–Saturday: 09:00–18:00
Monday–Sunday: 10:00–22:00
Monday–Friday: 08:00–12:00 and 14:00–18:00
Monday–Friday: 08:00–18:00, Saturday: 09:00–13:00
Tuesday–Sunday: 07:00–16:00
24x7
Future considerations
At the moment, the business hours are mainly intended to be displayed to field technicians (they use a 3rd party software integrated to SN). However, we may eventually need to:
Validate that onsite visits are scheduled within the Merchant's business hours.
Determine whether a Merchant is currently open or closed.
Use the Merchant's business hours as part of SLA calculations or business rules.
My question
What would be the recommended design approach for this scenario?
I'm considering several options:
Add a reference field on Account pointing to cmn_schedule.
Create custom fields on Account (days of the week + start/end time).
Use another OOTB capability (such as Business Calendar or another standard model) that is intended for this type of requirement.
Has anyone implemented a similar requirement?
If so, what approach did you choose, and what are the pros and cons of your design?
My goal is to follow ServiceNow best practices while keeping the solution scalable for future requirements such as SLA calculations, visit scheduling, and other business processes that may depend on the Merchant's business hours.
Thanks in advance for your recommendations!