How to Troubleshoot CSV Upload Errors
Summary
This guide explains how to identify and resolve processing errors that occur when you upload a transaction CSV file. Understanding these errors will help you quickly correct your file and re-upload it successfully.
When to Use This
Use this guide when the status of your CSV upload shows "Processing Error" on the upload report page. This indicates that the system found issues in your file that prevented it from being processed.
How to Troubleshoot CSV Upload Errors 1512x946
Step-by-Step Instructions
- Identify the Failed Upload: Go to the transaction upload Report page. Locate the file that has a "Processing Error" status.
- View Error Details: To the left of the file's creation date, click the red warning triangle icon.
- Analyze the Error Message: A pop-up window titled "Upload Error Details" will appear. It will list the specific errors found in your file, often including the row number and a description of the problem (e.g., "Error on row 1: CartItem.TaxAmount is not 0 but has ExemptionCertificateID").
- Correct Your CSV File: Open your original CSV file and navigate to the row mentioned in the error message. Correct the data based on the feedback provided.
- Re-upload the File: Save the corrected CSV file and upload it again using the standard upload process.
Common Questions (FAQs)
1. What does the red triangle icon mean? The red warning triangle indicates that your CSV file failed to process due to one or more errors in the data.
2. Will the error message tell me exactly what to fix? Yes, the error details typically specify the row number and the exact reason for the failure, making it easier to locate and fix the issue.
3. If one row has an error, will the other rows be uploaded? No, if the file has processing errors, the entire upload will fail. You must correct all listed errors and re-upload the entire file.
Troubleshooting Tips
- Unclear Error Message: If an error message is difficult to understand, refer to the CSV formatting guide. The issue is often related to incorrect data types, missing required values, or data that exceeds the maximum length for a field.
- Multiple Errors: Some files may have multiple errors. It's best to fix all reported errors before re-uploading to avoid repeated failures.