Holiday Hours allow you to specify your business hours on days when your business has an irregular schedule. This article covers how to use a spreadsheet to add holiday hours for your business. If you prefer to do this manually, see Add Holiday Hours to an Entity.
Upload Holiday Hours
- Click Knowledge Graph in the navigation bar and click Entities.
- Click on the + Add Data button. A dialog box appears.
- Click Entity Upload.
- Click on the Choose File button to upload your spreadsheet. See the attachment below for an upload template.
- (Optional) If you have a previously saved holiday hours configuration, click Select Configuration and select it from the list; otherwise, you will create a new configuration.
- Click Continue.
- Match the columns from your file to the relevant Holiday Hour fields by selecting the desired field from each drop-down.
-
(Optional) To update the data cleansing rules, click Edit to the right of each column and select your preferred option.
-
When uploading columns with split time intervals (e.g., "9 am-12 pm, 1 pm-5 pm") uncheck the Comma checkbox so the uploader can read each time interval correctly. This must be done for each row that contains split hours.
-
When uploading columns with split time intervals (e.g., "9 am-12 pm, 1 pm-5 pm") uncheck the Comma checkbox so the uploader can read each time interval correctly. This must be done for each row that contains split hours.
- Click Continue.
- Continue to follow the steps in the upload flow until your upload has been completed. For more information, see Add and Edit Entities Through Spreadsheet Upload.
Set Up Your Spreadsheet
Ensure you include the following fields in your upload file. You should only include holiday hours for days where you want the hours to differ from the location's normal business hours. If a location is operating under normal business hours on a certain date, that date does not need to be included in the upload.
- Entity ID
- Date
- Enter the date you would like to specify hours for in MM/DD/YY format.
- Times
- Specify your holiday hours in the form of a time range (e.g., "9 am-5 pm").
- Acceptable time formats: 3:00 PM, 3:00 pm, 1500, 15:00
- If there are multiple intervals in the same day, separate intervals in the same cell with commas. For example, if the location is open from 9am-12pm and 1pm-5pm, input "09:00-12:00,13:00-17:00"
- For 24-hour service, input "12:00 AM to 12:00 AM".
- If the location is closed entirely on a certain day, input "closed" or "x".
Comments
1 comment
Step #8 seems to be essential if we have split hours
Article is closed for comments.