Ayala Malls Accreditation

HQ - pabloelliz.almi@ayalamalls.com.ph

One Ayala - carlosbryll.almi@ayalamalls.com.ph

Metropoint - uy.ela@ayalalandbsi.com

Vertis North - servanezjomarhi.almi@ayalamalls.com.ph

Fairview Terraces - samsonmark.almi@ayalamalls.com.ph

1. Daily Sales Data (text file)  
2. Hourly Sales Data (text file)
3. Z-Read Data (text file)
4. EOD Sales Data (CSV file)
5. Hourly Sales Data (CSV file)

1. Hourly CSV are generated and synced to the store laptop every hour + 20 mins (buffer time)
2. Other sales files are generated and synced at 6:00:00 am

Provided by the mall admin.

The Company Code of each Ayala mall

Provided by the mall admin.

The unique Contract Number of each store set by mall admin.

Provided by the mall admin.

The name of the store set by mall admin.

Provided by the mall admin.

The longer name of the store set by mall admin.

The following steps should be done everytime we have new locations to onboard:

1. The client will send a request to Ayala Mall IT Team for the Company Code, Contract Number, Tenant Name and Merchant Name. 
2. The client or Ayala team will forward the details to Mosaic Team (Data Implem) for laptop configuration.
3. Mosaic Team (Data Implem) will encode the Company Code, Contract Number, Tenant Name and Merchant Name on the Back Office > Location details using Super Admin account.
4. As part of Ayala’s requirements, the client needs to have a laptop or computer wherein sales will be consolidated and should be connected to the Ayala Network.
1. Mosaic Team (Support) will install their Tenant API (orange app) to this computer.
2. Mosaic Team (Support) will also install a program that will automatically download the sales files and upload them to local network folder shared with Ayala. 
5. Install new APK and set the location as "Ayala" on the first screen.
6. That’s it! Sales files will be automatically sent to Ayala every hour and at 6:00 am. The laptop must be up for the whole business day and 6:00 am.

Ayala might request to reprocess  sales files for following reasons:

1. no eod synced to Ayala
2. errors
1. if the error has "Cross Validation, Discrepancy (15) NO_TRN (##) not equal to total of transaction (##)", this means some transactions were not reflected on Hourly CSV

1. Advise the store to check the orange app, a.k.a. telnet connection, on the laptop. Make sure that telnet is Connected

2. On POS > Settings > Ayala Sales File, check if the paths have been setup

3. On POS > Settings > Ayala Sales File > Regenerate and Resend

1. Prepare the POS Location ID, AWS Keys and C/D folders

1. Mosaic Data Implem or Support will encode the Loc ID, Tenant (Location Name) and Back Office Username on this file: Mall Sales Files Sending Credentials
2. Mosaic Support to request the AWS Keys Generation throught Teams Group Chat: Ayala AWS Keys Generation Request
3. Mosaic Dev (Dex) will encode the AWS Keys on this file: Mall Sales Files Sending Credentials
4. Mosaic Support to create the C/D folders

1. Path to the Ayala folder for text files. Note that Ayala has instructed us to install Project UNO here as well 

   Example: D:\Ayala 

2. Path to the Ayala Tenant API’s OUTGOING folder. The laptop must have the Ayala Tenant API program 

   Example: C: or D:\Ayala\tenant_api\storage\app\OUTGOING 

2. Request for the sales file and laptop config details

1. Client to reach out to Ayala Mall IT team for the following and request to send to us (JC)
1. Company Code
2. Contract Number
3. Tenant Name
4. Merchant Name
5. Mall Autopoll IP Server
6. Network Details
2. Mosaic Support to encode the details on this file: Mall Sales Files Sending Credentials

3. Set up the Mosaic Script on laptop

1. Mosaic Support to Download the script ZIP file at Mosaic Ayala Script and unzip its contents on C disk

2. Double click on install.bat. A Command Prompt window will briefly appear then go

   away.

   a. This copies files to the C:\Mosaic\ folder and configures the ayala-sync script

   to run hourly.

3. Check the C:\Mosaic folder and verify that all files have been copied:

   

Set up AWS credentials

4. Open a Command Prompt and type: C:\Mosaic\rclone config

5. Type n and hit Enter.

   a. All inputs from here onwards are case-sensitive!

6. When asked for a name, type mosaic-s3a. This must be named mosaic-s3 to work.
7. When prompted for “Storage”, type s3
8. For “provider”, type AWS
9. When prompted for “env_auth”, type 1

10. You should now be at an access_key_id prompt. Paste the AWS Access Key for this

    location.

11. For secret_access_key, paste the AWS Secret Access Key for this location.
12. For region, type ap-southeast-1

13. For the following prompts after this, just hit enter:

    a. Endpoint

    b. location_constraint

    c. server_side_encryption

    d. sse_kms_key_id

    e. storage_class

14. For Edit advanced config? choose n

15. You will be asked to confirm the endpoint settings. Confirm that everything is

    correct (especially the access keys) then answer with y

16. A list of remotes will be shown. It should contains mosaic-s3

17. Type q and hit Enter to exit.

Set up environment variables

18. Open the Start menu and search for “environment variables”
19. Click on “Edit environment variables for your account”. Something like this should appear. Set this aside for now

20. Open Windows Explorer then navigate to the Ayala Tenant API’s OUTGOING folder.

    It may be somewhere under a tenant_api folder. Copy the path to this folder from the

    address bar.

21. In the Environment Variables window’s “User variables for  “New...”
22. Add a variable named AYALA_CSV_PATH and paste the path in the value box

23. Hit OK.
24. Go back to Windows Explorer and navigate to the shared folder for this location’s sales files. Copy the path to this folder from the address bar.
1. This is the folder where we will be automatically creating folders for each year, inside of which will be sales files
2. Do not select a specific year’s folder, that means you went one level too deep in the folder hierarchy
25. Return to the Environment Variables window and create a new variable called AYALA_TEXT_PATH. Paste the folder path in the value box, then hit OK.
26. Create an environment variable named MOSAIC_LOCATION_ID and set its value to the location ID of the location being set up
27. In the Environment Variables window, hit OK.

Checking the setup

28. Open the C:\Mosaic folder
29. Double-click on checker.bat. It will indicate if all expected environment variables have been created. Otherwise, check that all environment variables were correctly set up.
1. Note that this only checks the existence of environment variables. Make sure the values that are in them are correct

You're done!

4. Set up the Ayala Project Uno on laptop

1. Support / Ayala Mall IT Team to download the Ayala Tenant API from — and install on the laptop
1. Telnet status should be "Connected" in order to sync the sales files to Ayala

5. Encode the Back Office Association Details

1. Data Implem to encode the following on Back Office:
1. Company Code
2. Contract Number
3. Tenant Name
4. Merchant Name

6. Send the previous days' sales files (as per request)

1. Log in on Back Office using the location's store admin access
2. Go to Reports menu
3. Go to Sales Text File menu
4. Select the date range of the sales files
5. Click Generate or Batch Generate