Support Company Careers Contact Us Site Map ChannelAdvisor Home

		Welcome Guest

FTP Error Report

For clients sending HIGH VOLUMES of Inventory (uploads or updates) or Shipment Status files, they have the option of using FTP to send these files to ChannelAdvisor. If you provide an email address when this functionality is enabled, you will receive an email that lets you know if the file was processed successfully. In the table below, we have broken down the components of this email and provided some comments, to the right, to help you interpret the email.

Portions of the FTP Error email	Comments / Descriptions
From: ftpupload@channeladvisor.com Sent: Wednesday, November 07, 2007 8:45 AM To: John Doe Subject: FTP Upload status for past 24 hours ------------------------------------- ProfileName: Printer/Golf Spectacular Deals ProfileID: 23111199	Email header, specifying the report date and the Profile Name / ID of the Merchant account.
Activity Summary: ------------------------------------- FTPUpload found (9) files ready for upload processing: 4printer_107_ABM.txt, 4printer_109_ABM.txt, 4printer_120_ABM.txt, 4printer_125_ABM.txt, 4printer_67_ABM.txt, 4printer_90_ABM.txt, 4printer_95_ABM.txt, CAAdd20071107, CAUpdate20071107	Includes a listing of ALL files that the system finds in the FTP directory, even those files that are not inventory related. In this particular example, a total of 9 files were found in the directory. Of the 9 files, there were two inventory related files. These have been marked in Bold / Blue. The other files are SearchAdvisor related files.
FTPUpload split CAAdd20071107 (1107 lines) was split into 2 sub files. - Errors : 1 FTPUpload split CAUpdate20071107 (1107 lines) was split into 2 sub files. - Errors : 0	This portion of the email identifies all inventory related files that exceed 1,000 rows. The system splits all files exceeding 1,000 rows into subfiles, each with a maximum of approximately 1,000 rows. The report specifies how many files the original inventory file was subdivided into. In this particular example, there were two inventory files, one an upload and the other an update. Each was split into two smaller files. One of the Upload subfiles had a processing error. If a file has an error, the entire file will not load.
FTPUpload completed processing of 4 inventory sub files that started at 11/07/2007 07:56:43 GMT	The phrase "Completed Processing" means that the main files, of which there were two (2), were successfully split into four (4) subfiles and the system attempted to read the four files. This does NOT mean that all four subfiles were actually loaded into Merchant.
Summary of errors: ------------------------------------- Errors logged for CAAdd20071107 ERROR 2007-11-07 07:57:05.657 GMT CAAdd20071107_110707-025607_#1107.txt: On line 48: You must set a classification in order to use classification attributes. Either set a class for this item, or remove its attributes.	This portion of the email identifies the type of error that was encountered. For this particular example, on the 5th line, the report states: "CAAdd20071107_110707-025607_#1107.txt: On line 48: You must set a ...". To identify where this error actually exists in your main file, the first thing to do is look at the value after the # sign. This value represents the last row number in the sub-file. Since this is #1107, we can assume that this is the second of two subfiles. If this were the first subfile, it would have stated #1000. The second file contains row #1101 through #1107 of the original file. In this second subfile, line 48 has an issue. The issue is that an attribute was added without a classification. Line 48 in the second subfile is equivalent to line 1048 in your original file. Fix this error and any similar errors. Either reload the file via the GUI or FTP process. Note: If there is an error in the subfile, the entire subfile will not load. If the file is an upload sheet, do not worry about duplicates. The upload process will ignore them. If the file is an update sheet and you are adjusting quantity values, you may need to be careful about not loading duplicates; depending on the type of adjustments you are making (relative or absolute). Relative means, incrementing or decrementing an existing quantity by some value. Absolute means setting the existing quantity to a new value.