YourOrder : New Procedure for Multi Venues/Multi YO September 2020

Overview

NEW Procedure for Multi Venues/Multi YO September 2020 

(NEW) RAISE REQUEST

1. Under the ‘SSO/Merchant App Implementation’ tab in the YourOrder Requests sheet 

Link Here (Google Drive)

Link Here (Global Sharepoint)

…For any existing records, please upgrade ‘Type of Request’ (Column B) from 

‘Merchant App’ to ‘Both’ 

…For any venue not currently listed, add to any unfilled row requiring Multi Site Single Sign On (SSO): 

• Under ‘Type of Request’ (Column B) select between ‘Single Sign On’ or ‘Both’ if Merchant App is needed as well

• Populate the Head Office contact name, number, email & address into the ‘HO /Single Venue’ columns (Column C – F)

• Populate the Admin Backpanel Bepoz Details into Columns I – K: ‘Bepoz Server address, ‘StoredProc Mac Key’, and, ‘YourOrder API Address’

Each venue in multi venue/website arrangement has its own record/row (one per venue) 

• Merchant App requests ONLY: Specify the ‘No. of Licences’ and ‘What Type of Tablet’ is required, same as before. If Merchant App is not required, please set ‘No of Licenses’ to 0 and ‘What Type of Tablet’ to ‘Not Applicable’ 

1. Send an email to the YourOrder team (

yourorder@bepoz.com.au) to say that you have added requests for new SSO licences for applicable venue(s) into the YourOrder Requests sheet 

Multi Venues ONLY - Request an additional API Till licence for the Head Office SmartController from the Bepoz Accounts team (accounts@bepoz.com.au), supplying the controller’s System ID in the request.

BEPOZ PROCESS - StoredProc with Multi Venues 

1. Download the StoreProcInstall.exe, job_storeproc.dll, and LiteDB.dll files from the link below:

https://bepozglobal.sharepoint.com/sites/yourorderonboarding/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2Fyourorderonboarding%2FShared%20Documents%2FGeneral%2F2%2E%20Software%20and%20useful%20files%2F2%2E%20StoreProc&viewid=b823cf66%2Ddc3d%2D476a%2Da0d5%2D9c7d0d993959

job_storeproc.dll and LiteDB.dll files will be located in the folders:

• Storeproc 1.4.818 for bepoz 4.5.2.18x and 4.6.x.x

• Storeproc 1.5.2.2 for bepoz v4.7

Click the correct folder based on the bepoz version being used.

1. On each of the Head Office (HO) and venue machines - close any SmartController, BackOffice and SmartPOS programs first, run the StoreProcInstall.exe file, and restart the programs with admin privileges. 

(This will automatically delete the apiext DLL files and install the latest LiteDB & StorProc DLLs in the BEPOZ Programs folder) 

Manual process for HO and each venue machine (If required) 

i. Close required BEPOZ programs 

ii. Copy the latest storeproc.dll and LiteDB.dll files into the BEPOZ programs folder 

iii. (IMPORTANT) Delete all DLL files with ‘apiext’ prefix from the BEPOZ Programs folder

 iv. Reopen closed programs from ‘Step i’ above with   admin privileges 

1. Run the four stored procedure SQL scripts in the HO and venue machines i.e. VoucherUpdated, AccountsUpdated, ProductsUpdated & FindAccount 

1. In the HO machine run Bepoz Backoffice to create each venue’s standard XMLAPI and StoreProc schedule jobs. Pay attention to the new flag in the job called 

MultiVenue in the ‘Job Options’ section at the bottom of the window. 

(NEW) Tick ON this MultiVenue option so that it is enabled in the JobStoreProc schedule job of each of the venues in the multi venue arrangement.

(NEW) Apply the licence approved by the BEPOZ Accounts team to the the Head Office venue’s SmartController and create a new API Till in the Head Office machine. Naming suggestion: ‘YourOrder Accounts API Till’ or similar 

1. Create an XMLAPI schedule job for the Head Office venue. Do not create another StoredProc job or request a new port forward in the router for HO as neither of these are required. Please find the configuration below noting that the setup must be the same for every Multi Venue site. 

(IMPORTANT) THESE VALUES ARE FIXED AND MUST MATCH THE VALUES BELOW PRICISELY. 

DLL Name: jobxml_api.Dll

ClassName: XML_API

Venue(s): HEAD OFFICE

MAC secret Key: SP$HO123 (fixed, DO NOT CHANGE) Connection Port: 18192 (fixed, DO NOT CHANGE)

Failure Retried Count: [any number] 

Failure Retries: [any number]

Data Format: XML 

Till: YourOrder Accounts API Till 

Head Office XMLAPI Job’s MAC Secret Key and Connection Port MUST MATCH values above 

(NEW) Add an inbound firewall rule and then a second, outbound rule in Windows Defender Firewall for port 18192 

Inbound and outbound firewall rules (2) needed for Port 18192 

ADMIN BACKPANEL PROCESS 

 (NEW) Once Special Projects has updated the YourOrder Requests spreadsheet with the Hub details from columns L to V in the ‘SSO/Merchant App Implementation’ tab of the spreadsheet (Noting that requests may take up to 8 hours to action): 

• Open the ‘SSO’ tab under the ‘Management Hub’ banner at the top of the Settings section in the venue’s YourOrder Admin Backpanel: 

• Turn on the ‘Enable Single Sign On’ switch and copy the remaining details across from the spreadsheet to the venue’s Admin Backpanel as follows: 

Legend Source (Spreadsheet) Target (Admin Backpanel)

Merchant App ONLY: 

Open the ‘Merchant App’ tab under the ‘Management Hub’ banner at the top of the Settings section in the venue’s YourOrder Admin Backpanel: 

• Copy the details across from the spreadsheet to the venue’s Admin Backpanel as follows: 

Legend Source (Spreadsheet) Target (Admin Backpanel)

PLEASE NOTE: ‘Merchant App Licence Key’ (Column O of spreadsheet) is for providing to the customer so that they can use the Merchant App 

• Open the ‘Main Settings tab under the ‘Merchant App’ banner at the bottom of the Settings section of the Admin Backpanel and turn on the ‘Enable Merchant App’ switch 

• Provide the Merchant App Licence Key to the customer so that they can sign in for the applicable venue