Skip to content

POS Transactions

The POS Transactions page is available at:

https://app.pixaro.ai/pos-transactions

Feature Overview

POS Transactions is used to import transaction files from Modisoft and review uploaded POS transaction batches.

This page is mainly used when Modisoft POS transaction data needs to be imported for transaction search, transaction-video review, and reporting workflows.

The page uses the store selected in the top toolbar for the list view.

Access and Navigation

Navigation path: Video Intelligence > POS Transactions

Required permissions: Transaction/POS transaction access for the selected user role.

POS Transaction List

The page title is POS Transactions.

The list shows uploaded Modisoft POS transaction batches.

Columns include:

Column Meaning
POS Type POS system type. Currently Modisoft is used for this import flow.
Uploaded By User who uploaded the POS files.
Uploaded Date Date/time the POS files were uploaded.

If there are no records, the table shows No POS Transactions Found.

The list uses pagination with page sizes of 5, 10, 25, and 100.

Filters

Available filters:

Filter Purpose
From Date Start date for uploaded POS transaction batches.
To Date End date for uploaded POS transaction batches.
POS Type POS system type. Current import option: Modisoft.

Use Search to apply filters.

Use Reset to clear filters and reload the default list.

Upload POS Data

Click Upload POS Data to open the upload dialog.

Required fields:

Field Required Notes
Select Store Yes Store that owns the POS files.
POS Type Yes Select Modisoft for this import flow.
Upload mPos Transaction File Yes Source transaction file.
Upload Pos Transaction File Yes POS transaction metadata file.
Upload All Sales Live Items File Yes Item/detail file used to match transactions with items.

To upload POS data:

  1. Open Video Intelligence > POS Transactions.
  2. Click Upload POS Data.
  3. Select the store.
  4. Select Modisoft as POS Type.
  5. Upload the mPos Transaction file.
  6. Upload the Pos Transaction file.
  7. Upload the All Sales Live Items file.
  8. Click Upload.

If any required field or file is missing, Pixaro shows:

Please fill in all required fields.

After a successful upload, the dialog closes and the list reloads.

What Happens After Upload

The API Server processes the uploaded Modisoft POS files.

The processing flow:

  1. Reads and validates the uploaded transaction files.
  2. Parses transaction rows.
  3. Parses transaction item rows.
  4. Matches transactions with item data.
  5. Saves processed transactions.
  6. Uploads source files to storage.
  7. Saves POS transaction upload metadata.

After processing, the imported Modisoft transactions can be used in the Transactions page.

Backend Notes

POS Transactions uses API Server routes under /transaction-api:

  • POST /pos-transactions
  • GET /pos-transactions/:storeId

The upload request is sent as multipart form data with:

  • storeId
  • posType
  • transactionsFile
  • posTransactionsFile
  • allItemsFile

Troubleshooting

Issue What to Check
Upload button does not complete Confirm all required fields and all three files are selected.
POS Type is missing Select Modisoft as the POS Type.
Uploaded list is empty Confirm the selected store and date filters.
Upload returns an error Confirm the files match the expected Modisoft POS export format.
Transactions do not appear in Transactions page Confirm processing completed and search the correct store/date range.
Uploaded Date appears wrong Confirm store/user timezone expectations and upload timestamp.

Best Practices

  • Select the correct store before uploading files.
  • Upload all files from the same POS export period.
  • Do not mix files from different stores or dates.
  • Use clear date filters when reviewing uploaded batches.
  • After upload, verify imported data in Video Intelligence > Transactions.