Skip to main content

How to manage opening hours

Set, import, and customize opening hours for your locations, including CSV import format and display settings.

Updated yesterday

You can add opening hours to each location so visitors can see when stores are open. Hours show up in the location details on your store locator.

Setting hours in the dashboard

Edit any location, scroll to the Hours section, and set the open and close times for each day (Monday through Sunday). You can mark individual days as Closed or Open All Day.

Reusable hours templates

If many of your locations share the same schedule, create a reusable template instead of entering hours one by one.

  1. Go to Hours in your dashboard

  2. Click Create and name your template (e.g. "Standard Hours" or "Weekend Only")

  3. Set the hours for each day

  4. Save

Then when editing a location, you can select a reusable template from the dropdown instead of entering custom hours.

Importing hours via CSV

There are two ways to include hours in your CSV import:

Option 1: Use a reusable hours template

Add a column called hours_id with the template name:

name, address, hours_id
Store 1, 123 Main St, Standard Hours
Store 2, 456 Oak Ave, Weekend Only

The template must already exist in your project.

Option 2: Set hours per day

Add columns for each day of the week:

name, address, monday, tuesday, wednesday, thursday, friday, saturday, sunday
Store 1, 123 Main St, 09:00-17:00, 09:00-17:00, 09:00-17:00, 09:00-17:00, 09:00-17:00, 10:00-14:00, Closed

Use 24-hour format: 09:00-17:00. Write Closed for days the store is closed, or leave the cell empty.

The same column format works for Google Sheets sync.

12-hour vs 24-hour display

StoreRocket can display hours in either format. Go to Widget > Settings and look for the Time Format option. Switch between 12-hour (9:00 AM) and 24-hour (09:00) display.

Note: always use 24-hour format in your CSV or spreadsheet, regardless of the display setting. StoreRocket converts it automatically.

Hiding hours from the widget

If you don't want hours to show in the store locator, you can toggle hours visibility off in Widget > Settings. The hours data stays in your account, it just won't be displayed to visitors.

Hours not showing correctly?

A few things to check:

  • Hours entered but not displaying: Make sure the hours toggle is enabled in Widget > Settings

  • Wrong format after import: Use 24-hour format in CSV (09:00-17:00, not 9am-5pm)

  • All days showing as closed: Check your spreadsheet for formatting issues. Dates/times in Excel can get reformatted automatically. Try formatting the cells as "Text" before entering hours.

Questions? Reach out on live chat.

Did this answer your question?