Converting a Multivenue Site to a Single Venue site with the correct reseed StoreID's

Overview

This guide will show you how to extract a venue from a Multivenue Setup, into a Single Venue Setup, along with the StoreID's being correctly reseeded and to maintain all the Summary data. 

Prerequisites​​​​​​​

• HO Database Backup

• SSMS

• FULL BACKUP

  Using Database.exe

  Perform a Full Backup of the Headoffice Database. 

  

  Restore Backup

  Using Database.exe 

  Restore the HO Backup on to your Test Environment system

  

  Create a Venue Data Recovery

  Using Database.exe 

  Navigate to the MultiVenue Tab and Click on Venue Data Recovery and Specify the VenueID you would like to Extract from the Headoffice database

  

  Restore the Venue Data Recovery

  Using Database.exe 

  Navigate to the Backup Tab and Click on Restore Database button and Specify the Location of the VenueRecovery and Give the Database a new Name of the Single Site.

  

  Restore Sales Summary Data 

  Using Database.exe 

  Navigate to the Copy Database Tables Tab and specify the Headoffice Database and the To Database and check the following tables 

  AccActivty 

  OpSummaires 

  TillSummaires

  SalesSummaires

  Click Copy Tables 

  

  Disable Multivenue in Global Settings

  Run Backoffice on the Venue Database. 

  Navigate to Global Settings and uncheck All the Multivenue Options and Set Headoffice to not Multivenue

  

  Delete the Other Venue and Store Data

  Run SSMS

  Change the VenueID and StoreID to match that of the Venue your are trying to extract

  • delete Venue where VenueID <> 5

  • delete Store where StoreID not in (5,7)

  • delete from Workstation where StoreID not in (5,7)

  • delete from SalesSummaries where StoreID not in (5,7)

  • delete from ProdStore where StoreID not in (5,7)

  • follow the below guide next to reseed the StoreID's

  • Rebuilding a corrupted Store Table

  

  Delete TillSummaries and OpSummaries for Other Stores

  Run SSMS

  Run the following queries they will delete all the OpSummaries and TillSummaires that dont match to WorkstationID's in the current database. 

  DELETE FROM TillSummaries

   WHERE TillOpID NOT IN (SELECT Workstation.WorkstationID

                          FROM Workstation)

  DELETE FROM OpSummaries

   WHERE TillOpID NOT IN (SELECT Workstation.WorkstationID

                          FROM Workstation)

  Delete Products not in Current Stores

  Run SSMS

  This will Flag the Product to "KEEP" using ExportCode_4

  update Product set ExportCode_4 = 'KEEP'

  where ProductID in (select ProdStore.ProductID from ProdStore)

  Once the Product have been flagged then you can delete the Products that are no longer required

  Delete from Product where ExportCode_4 <> 'KEEP' and ProductID <> 1 and IsParent = 0

  Delete Stock Data

  Run Database.exe

  Modify Databases Tab - Delete Stock Only

  

  Delete Operators and Accounts

  Run Backoffice.exe

  Accounts – make them inactive then use database.exe

  Operator – make then inactive then use database.exe

  

  Delete Other

  Run Backoffice.exe

  1. Vouchers

  2. Promos

  3. Schedule jobs

  4. Keymaps ​​​​​​​

  These items can all be done via Backoffice with mass selection.