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 |
|
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:
|
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 |
