Skip to content
English
  • There are no suggestions because the search field is empty.

How do I fix sales order import errors in the 3PL Client Portal?

CLIENT GUIDE: Here's how to troubleshoot and resolve issues preventing successful order imports.

Overview

If your sales order import returns an error, don't worry—it usually comes down to a few common issues like missing fields or invalid data formats. This guide will show you how to identify what went wrong and fix it so you can try again.


Step 1: Locate the error message

  • Go to the 3PL Documents section in the portal.

  • Click Apply to refresh the list.

  • Find the row with the failed import – the Status will say Save Data Failed.

  • Click the Error Message field in that row to view detailed feedback.


Step 2: Understand the error

The system will provide information like:

  • Which line(s) in your Excel file caused the error

  • The specific column or field that’s invalid or missing

  • Suggestions for correction (e.g., “Missing Customer PO #”)

Take note of the error details before proceeding.


Step 3: Open and fix your Excel file

Open the original file you attempted to upload and:

Verify all yellow-highlighted (required) fields are filled
⚠️ Correct any formatting issues (dates, numbers, etc.)
🚫 Remove duplicate order numbers if applicable
🟩 Green-highlighted fields are optional, but it's best to confirm they contain valid data too.


Step 4: Re-upload the corrected file

Once corrected:

  • Navigate back to Import/Export > 3PL Documents Import/Export

  • Select Sales Order again

  • Upload the revised Excel file

  • Click UploadYes to confirm

Check the 3PL Documents list again to confirm that the new attempt shows Status: Success.

Tip: Start small. If you’re unsure whether the corrections fixed the issue, test with a smaller file or fewer lines to validate your format before importing your full order list again.

 

Related guides