Restatements Data File

📋Before You Implement
  • Verify that the orders you intend to restate are commissionable and not locked or closed.
  • Restatements overwrite all existing order data — always submit the complete, current state of the order, not just the fields you want to change.
  • Do not include PII (such as email addresses) in the orderId field, and avoid special characters that may break your file format.
  • Contact your Client Integration Engineer if you are unsure about your subscriptionId, actionTrackerId, or file submission method.

File Submission Process

Submission at a Glance
3 steps
01
Prepare Your CSV FileBuild your restatement file following the format requirements above. Validate all field formats, especially timestamps and numeric values, before submission.
Step 1
02
Submit Through the Data Transfer SystemUpload your file using your designated upload method in the Data Transfer system. Contact your Client Integration Engineer if you need access credentials.
Step 2
03
Monitor Email NotificationsWatch for the Import Receipt Confirmation and the Processing Results notification. Review any failure details and resubmit corrected records as needed.
Step 3

How to Upload

01
Log into
CJ Account Manager
02
Navigate to
Subscriptions
Account › Subscriptions
03
Click
Upload File
04
Choose your file
and select Upload

01
Connect to CJ's SFTP server

Use your SFTP credentials to connect. If you need your credentials or need to reset them, submit a support ticket to the CJ team.

Need credentials? Submit a support ticket →
02
Upload the file to the root directory

Once logged in, place the file in the / root directory. Do not upload to a subdirectory.

03
Watch for confirmation emails

If processed successfully, CJ will send two emails — one confirming receipt and a second with the processing status.

Email 1: receipt confirmation  ·  Email 2: processing statusHow to validate your processing status email →

Processing Notifications

📘

To receive processing notifications, ensure your email address is registered in the Data File Upload subscription settings within CJ Account Manager. To verify, log in to your CJ account and navigate to Account → → Subscriptions. If your email is not listed, submit a support ticket to request access.

01
CJ Import Receipt ConfirmationSent Immediately

Confirms that CJ has received the New Orders file you submitted. This email confirms receipt of the file only — it does not indicate that the records inside have been processed or accepted.

Processing
02
CJ New Orders File ProcessedOn Completion

Reports aggregated processing results once your file has finished processing. The subject line includes one of three result statuses, and detailed outcomes are provided in the email body or as an attached file.

Possible result statuses
SuccessAll records processed successfully with zero errors.
Partial FailureA mix of successful and failed records. Review the failed records in the email body or attachment.
FailureAll records failed to process. Review error details in the email body or attachment.
For Partial Failure or Failure outcomes, error details are provided either inline in the email body or as a downloadable attachment depending on the volume of failed records.

What’s Next