Star Pubs & Bars - Houselist Management

Every Monday, we receive a ticket in Client Desk with subject "Star Pubs House List".

We need to check this file for any changes to locations and location names using the below process:

1. Download file from the weekly email.

2. Locate the file from the previous week and download this.

3. Open both files and copy columns C 'PropertyId' and M 'LocationCode' from last weeks' file to the new one.

4. Highlight columns C and M and the columns you copied over (in the example this is columns X and Y) then select Conditional Formatting> Highlight Cells Rules> Duplicate Values.

5. Choose to highlight Unique values:

6. Review any highlighted cells.

      - For this file, Half Moon Sheffield needs to be retired as both the branch ID and Name is highlighted.

      - In addition, Tiger Market Hall Approach needs to be renamed to The Tiger Derby as a branch name change only, as the branch IDs have not been highlighted and are the same.

7. Remove the Conditional Formatting.

8. Add filters and filter column F 'LmsLeaseType' to see sites listed as "MRO" and "CLOSED". 

9. Repeat the steps above with the filters and retire any branches as needed. For example, Golden Lion Newton Abbot, Courthouse Rugby and Bell Inn Whittington are highlighted and therefore any visits scheduled should be cancelled and the branches retired.

Changes to Area and Site Manager will be confirmed by our Star contacts separately.

Once the check has been completed, please delete both files.

• Related Articles

• Adding Star L&T Visits

  Please see how to video here for process on adding Star visits for the L&T round.

• Star Capex Requests

  1. Check if the branch is L&T or JAT. 2. Check branch is Live and set to 1 visits in Hive> Branches> Branch Settings. 3. If JAT, change brand to JAT Capex in Hive> Branches> Branch Settings. 4. If JAT, check the branch is selected in the relevant ...

• Branch Permanently Closing

  1. Check for any visits scheduled after the closure date. 2. Email diners and cancel visits, ensuring this does not impact the diner’s status. 3. Set the branch to 0 visits in Hive> Branches> Branch Settings. 4. Retire branch. - This may need to wait ...

• Automated Review Responses

  Clients can automate their review responses for Google, Booking.com, and Facebook using review response templates. The automation can be configured by review score and by whether a review includes comments. This feature saves clients significant time ...

• Dynamic Survey Validator

  The validator triggers after every save. The severity of the error will be a different colour; red means this could be a breaking change, yellow means this could cause data loss, and blue is just for information. It will highlight the following ...