How can Special Opening Hours be updated in bulk?

    Last updated on August 11th, 2025

    Uberall allows you to manage a wide range of location data—including addresses, services, keywords, photos, regular hours, and special opening hours—directly within the platform.

    This article outlines how to add special opening hours using both the In-App Bulk Editor and the Bulk Edit via Excel options.

    Option 1: In-App Bulk Editor (Use When Hours Are the Same Across Locations)

    1. In the Location Hub, select the locations you want to update.
    2. Click Bulk Update.
    3. Choose In-App Bulk Editor.
    4. In the Basic Data tab, scroll to the Special Opening Hours section.
    5. Click Add Special Hours.
    6. Choose the specific date you want to update.
    7. Set the special hours:
      1. Enter custom opening and closing times, or
      2. Mark the location as Closed for that date.
    8. Click on Next to confirm the changes.
    9. In the confirmation screen, you can:
      • Discard Changes
      • Go Back and edit
      • Save Changes to apply them across all selected locations

    Option 2: Bulk Edit via Excel (Use When Hours Differ Across Locations)

    If special hours vary across locations, use the Excel method:

    1. In the Location Hub, select the relevant locations.
    2. Click Export to download an Excel file of location data.
    3. Open the file and locate Column X: specialOpeningHours.
    4. Add or edit the special hours in the appropriate format.
    5. Save and rename the file for clarity.
    6. Return to the Location Hub and click Bulk Update.
    7. Select Bulk Edit via Excel and upload your file.


    Delete

    Important

    Do not change contents of Column A (locationId) or Column B (businessIdentifier). Altering these may create new locations unintentionally.


    Was this article helpful?

    Save as PDF