Regenerate and Resend Mall Sales File through Back Office (Sales File Utility Tool)


Status Deployed
Objective Allows Store Admin users and Support Team to reprocess sales files as needed (requested by the mall, need to correct values using recent deployment, failed sending due to no internet connection, etc) on the Back Office
Pain Point A lot of back and forth in reprocessing sales files
Audience All Clients that operates under malls
Requestor Malls
User Access Store Admin

Old State New State
Resending is requested through Viber and forwarded to Dev/Product Any user with Store Admin access can regenerate and resend the sales files on Back Office
How to Use
  1. Log in on Back Office using Store Admin access
  2. Go to Reports menu
  3. Click "Sales Text File"


Filter

Field / Button Description User Access
Start Date Starting POS Date that the user wants to view Store Admin only
End Date Ending POS Date that the user wants to view Store Admin only
Filter Shows the sales files within selected Start and End Dates Store Admin only

Batch Actions

Button Description User Access
Batch Generate

Generate option will show up if initial generation failed.

Batch Generate will generate and send all ungenerated sales files that are displayed on the view table

Store Admin only
Batch Send

Send option will show up if sales files were generated but failed on sending.

Batch Send will send all unsent sales files that are displayed on the view table

Store Admin only
Batch Regenerate and Resend

Regenerate and Resend option will show up if initial generation and sending worked.

Batch Regenerate and Resend will regenerate and resend all sales files that are displayed on the view table. It will also use the latest computation/updates if there's any

Store Admin only
Batch Download

Download option will show up if there's generated sales files.

Batch Download will download all generated sales files that are displayed on the view table

Store Admin only

View Table

View Table Column Description
Mall Entity The mall entity name where the location is operating such as SM, Megaworld, Araneta, Robinsons, FBDC, Landmark, Rockwell, Ayala, Ortigas, Greenfield, Mitsukoshi, Shang, etc.
POS Date The POS Date of the transactions and sales files
Date Generated Calendar date when the first sales files were generated
Date Sent Calendar date when the last sales files were generated and sent
Batch Number Sales file names
Actions Allows the users to Generate, Send, Regenerate and Resend and Download sales files

Actions

Button Description User Access
Generate

Generate option will show up if initial generation failed.

Generate will generate and send ungenerated sales files

Store Admin only
Send

Send option will show up if sales files were generated but failed on sending.

Send will send unsent sales files

Store Admin only
Regenerate and Resend

Regenerate option will show up if initial generation and sending worked.

Regenerate and Resend will regenerate and resend sales files. It will also use the latest computation/updates if there's any.

Store Admin only
Download

Download option will show up if there's generated sales files.

Download will download sales files in a zip file.

Store Admin only

Success and Error Messages

Messages Description Malls Resolution
Sales file sent successfully. This means the sales file has been successfully regenerated and resent. Megaworld, Ayala, SM, Araneta, FBDC, Landmark, Rockwell, Ortigas, Greenfield, Mitsukoshi, Shang
Sales file is not sent. Please contact Mosaic Support. This means the sales file was not successfully sent to the mall. Megaworld, Ayala, SM, Araneta, FBDC, Landmark, Rockwell, Ortigas, Greenfield, Mitsukoshi, Shang

For ftp / sftp sending malls such as Megaworld and FBDC, make sure that ftp hostname and credentials have been setup on the Location settings

For gdrive sendin malls such as Rockwell, Araneta and Ortigas, make sure that Gmail Drive Folder ID and Tenant Code have been setup on Back Office

Sales file successfully sent to RLC server. This means the sales file has been successfully regenerated and resent to Robinsons Robinsons
Sales file is not sent to RLC server. Please contact your POS vendor.

This means the sales file was not sent due to following reasons:

  1. incorrect sftp credentials
  2. Robinsons' server is down

Robinsons Make sure that correct hostname and credentials have been setup on Back Office

Future Development

Item Resolution / Workaround Target Timeline
UI BUG: Sometimes, the message shows "Sales file is not sent to RLC server. Please contact your POS vendor." but new sales file was generated and sent Disregard for now. It's actually sent and only a UI issue. It occurs mostly when there's old unsent file.
Implement Sales File page on Enterprise and Super Admin user levels

Implement Batch Regenerate and Resend to Megaworld Regenerate and Resend per POS Date
Like Ayala and Robinsons, implement the Back Office Utility Tool on POS so that cashier can regenerate and resend upon mall request

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us