Troubleshooting product data feed errors

Error behaviour explained

If the system has trouble processing your feed, the behaviour is depending on the severity of the problem. We are categorizing problems into one of two groups:

warning Warnings are problems that lead to partially unprocessable data, but still, result in a usable feed. Products that lead to warnings will be skipped to ensure good data quality on the partner side. The first 10 warnings that occurred when processing a feed will be shown in the UI.

ERRORErrors are problems that lead to the whole feed being unprocessable. Errors cause the system to stop the processing entirely and will not produce a feed for the partner to download.

 

In case of an error, the system will attempt to retry the import using an exponential back off strategy. Continuous failures will increase the delay to increase to a maximum delay of 24 hours. Failed feeds will therefore be reattempted at least once every 24 hours.

Where can I see errors/warnings for my product data feeds?

In the Product data UI (Creatives → Product data feeds), when your feed contains warnings, you will see a yellow warning sign.

Click on the timeline icon to find the recent import details, containing detail messages of the first 10 warnings in your file.

Common errors/warnings

Warnings will skip the affected line, while errors will lead to the whole feed not being processed.

 

Error message

Error code (Only visible via API)

Type

Description

Error message

Error code (Only visible via API)

Type

Description

CSV parse error in line X with message: [Detailed message]

CSV_PARSE_ERROR

warning

There is an unspecified error while parsing the CSV document

Invalid character between encapsulated token and delimiter in line: X

CSV_INVALID_CHARACTER

warning

This is usually an unescaped escape character or a generally unescaped sequence containing an escape character

EOF reached before encapsulated token finished. (Line: X)

CSV_PREMATURE_END_OF_FILE

warning

An escape sequence was not finished before reaching the end of the file

Row column count does not match header column count in line X with values [Available columns]

CSV_INCORRECT_COLUMN_NUMBER

warning

There are columns missing in the specified line.

Could not log into ftp-server. Please check your credentials.

FTP_LOGIN_ERROR

warning

Username or Password for your FTP-Server are incorrect

No products found

NO_PRODUCTS_FOUND

ERROR

The file is empty, or all products were skipped (because of warnings)

Feed not mapped

FEED_NOT_MAPPED

ERROR

 

CSV header is missing mandatory fields with names: 'X'

CSV_MISSING_MANDATORY_HEADER_FIELD

ERROR

A required column is missing in the file.

Product number 'X' is missing mandatory values [X]. Values given: [X]

MISSING_MANDATORY_VALUE

warning

A required value is missing in one of your products

Download failed from [YOUR_URL].

DOWNLOAD_FAILED

ERROR

Download via the specified URL failed. This usually gives you the http status code as well (i.e. 404)