Star Pubs & Bars - Houselist Management

Star Pubs & Bars - Houselist Management

Every Monday, we receive a ticket in Client Desk with subject "PLEASE DO NOT REPLY TO THIS EMAIL – Houselist Attached [Date]".

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. Open up 7zip application, navigate to the file and then click “Extract”:


3. Double click the file and you will be prompted to enter a password to unlock the file, which is 'support@hgem.com_K1664'
WarningThis file contains sensitive data so the password must be kept secure and confidential


4. Copy the file to a location by dragging it out of the window (desktop is easy for access).
You can’t open two files with the same name update/rename this file so you can identify the old file from the new.
5. Open both files and copy columns A and B 'Ship-to party' and 'Rental Obj Name' from last weeks' file to the new one.



6. Highlight columns A and B and the columns you copied over (in the example this is columns Q and R) then select Conditional Formatting> Highlight Cells Rules> Duplicate Values.



7. Choose to highlight Unique values:



8. Review any highlighted cells.
      - For this file, Broncos Sheffield needs to be retired as both the branch ID and Name is highlighted.



      - In addition, Mousetrap Edinburgh needs to be renamed to Dog House Leith Edinburgh and Bar1 Ascot renamed to Falak Royal Ascot, as the branch IDs have not been highlighted and are the same.




9. Remove the Conditional Formatting.

10. Filter column J 'Cont Type Desc' to see sites listed as "MRO FRI" or "MRO IRI". 



11. Repeat the steps above with the "MRO" filter and retire any branches as needed.

12. Filter Column K "Vac.Reason Name" to see sites that are currently closed.



13. Repeat the steps above with the "Vac.Reason" filter and retire any branches as needed. You may need to cancel visits for any new closures.

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

Alert
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 ...