External Webgains Knowledge Hub

Transaction Management FAQs & Common Errors

This guide covers some of the Frequently Asked Questions for using the Transaction Management tool to confirm, cancel, or adjust transactions and items, as well as which action to choose, how upload results are shown, and how to resolve common errors.

Choose the right action

Use Transaction Management to confirm or cancel full transactions from the Transactions tab, and to cancel or adjust individual items from the Items tab. For larger volumes, download the relevant report, update the CSV file, upload the changes, and review the result in Upload History.

Scenario

Use this tab

Action

Guidance

Approve a full order

Transactions

Confirm transaction

Use the on-screen option for small volumes, or the transaction upload process for bulk approvals.

Cancel a full order

Transactions

Cancel transaction

This applies to the full order and all items within it.

Refund or change one item in an order

Items

Cancel item or adjust item value

Individual items can be cancelled within the on-screen page.

For item value adjustments, use the bulk upload option for item-level editing, and then the final transaction value is updated correctly.

Process many changes at once

Transactions or Items

Download the relevant report, edit the file, and upload the adjustments

Choose the report that matches the level of change you need to make.

Bulk Upload Error Details

After a file has been uploaded, it will move for Processing. An email will be sent to you (the file uploader) with the outcome of the processing to let you know if it was successful or if there were errors.

Upload History status

Meaning

Next step

Completed

The file processed successfully with no errors.

No further action is needed.

Failed

The file could not be processed.

Review the file, correct the issue, and reupload the full file.

Completed with errors

Some rows were processed successfully and others failed.

Download the issue list, correct the failed rows, and reupload only those rows.

If there were errors, you can download the error log from the platform Transaction Management > History.

Common errors within the Bulk File Upload options for Transactions/Items editing include:

Issue

Area

Recommended action

Guidance

The transaction or item cannot be found in Transaction Management.

Transactions or Items

Check that the transaction is still editable and within the applicable Validation Period.

Transaction Management only shows transactions and items that are still eligible for action. If a transaction has already been confirmed or cancelled, use Reporting to view it.

A partial order change is being attempted in the wrong area.

Action selection

Go to the Items tab and use item-level editing.

Use the Transactions tab only when the change applies to the entire order. Use the Items tab when the change applies to one or more products within an order.

A bulk upload completes with errors.

Upload processing

Download the issue list from Upload History and correct only the failed rows.

Reupload only the transactions or items that failed, rather than uploading the full file again.

A bulk upload fails completely.

Upload processing

Review the file, correct any issues, and upload the full file again.

If Upload History shows a failed status or an unknown error, the file was not processed and must be reuploaded.

Columns marked Do Not Edit have been changed.

CSV upload

Download a fresh report and apply the changes again without editing protected columns (noted in row 2 instructions).

Protected columns must not be changed. Editing them can prevent the upload from processing correctly.

The adjustment file is missing required values or reasons.

CSV upload

Add the required modified values and change reason before uploading again.

Common upload errors include missing modified values for adjustments and missing change reasons.

The transaction is already cancelled or outside the validation period.

CSV upload or action processing

Do not retry the action in Transaction Management. The transaction has already fallen outside of the validation period.

The system returns an error when a transaction has already been cancelled or can no longer be adjusted.

The upload states that the file must be a CSV.

On-screen error: the file must be csv

CSV upload

Save the file as a valid CSV using the downloaded report format, then upload it again.

CSV formatting or separator settings can cause the platform to reject a file. If the issue continues, check the file format before escalating.

Please also check that there are no extra spaces added before/after any field values

Order references with leading zeroes do not match after download and upload.

On-screen error: the file must be csv

CSV upload

Check order references carefully before uploading the file.

Some spreadsheet tools can remove leading zeroes. Preserving the original reference helps avoid matching errors.

A large upload does not process.

High-volume upload

Check Upload History and any email error message, then retry if appropriate.

Large files can time out during processing. If the issue continues, capture the file details and error message for support.

FAQs

When should I use the Transactions tab instead of the Items tab?

Use the Transactions tab when the change applies to the entire order, such as confirming or cancelling a full transaction. Use the Items tab when the change applies only to one or more products within an order, such as a partial refund or item value correction.

Can I adjust item values for a full order from the Transactions tab?

No. Item value changes should be made from the Items tab using the item report and upload process. So for example, if a customer has returned 1 item out of their order of 3 items, you can cancel that item within Transaction Management. The remainder transaction value will then update according to the commission rules for the remaining items.

What should I do before confirming a transaction that has item-level changes?

Complete all required item-level cancellations or adjustments first. Making changes at item level does not automatically confirm the overall transaction, so you can make any further item-level changes that are needed.

Once all item-level changes are complete, you can return to the Transactions tab and confirm the overall transaction. Alternatively, it will automatically confirm once it’s validation period ends.

Why can’t I see a transaction in Transaction Management?

Transaction Management only shows transactions or items that are still eligible for editing (within their Validation Period). If a transaction has already been confirmed or cancelled, it will not appear there, but it can still be viewed in Reporting.

What are the most common upload errors?

Common upload errors include missing modified values for adjustments, missing change reasons, transactions that are already cancelled, expired validation periods, transactions that cannot be found, and protected columns being edited.

Uploads can also fail if the CSV structure or formatting has been changed. On-screen error: the file must be csv. Do not change the column headers or fields other than those required for the action. Formatting changes introduced while working with the CSV in Excel can also prevent the file from processing correctly.

If an upload fails, check Upload History for details of the error.

What should I do if only some rows fail in my upload?

Open Upload History, download the error file, correct the issues listed, and reupload only the rows that failed.

If I leave rows with no action in the CSV, will the upload fail?

No. You do not need to remove transactions or items that have not been changed. Rows with no action added are treated as untouched and can remain in the CSV while the rest of the file is processed.

What should I do if the item data for a transaction is incomplete or incorrect?

Incomplete or incorrect item data can indicate an underlying integration issue rather than something that should be corrected within Transaction Management.

If it appears there is an issue with incorrect item information, contact your Account Manager.

Why should I use Transaction Management rather than the older batch adjustment tools?

Transaction Management supports transaction-level and item-level changes in the same workflow and preserves the item-level information needed for accurate processing.

This is particularly important where item-level information affects Smart Commission conditions. Using Transaction Management helps ensure those item-level details are handled correctly.

The older batch tools will be retired in line with supporting item-level adjustments and transaction health.

Can I select all transactions to download them in one go?

To download all transactions, do not select any individual transactions before downloading the Transaction Report. Leaving everything unselected tells the system to download all available transactions.

Using Select all selects the transactions displayed on the current page.

The Select all option is not available for Cancel actions.

Can I update whether a customer is new or existing through Transaction Management?

No. You would need to speak to your account manager to adjust the commission accordingly.