Validation results¶

Validation response¶

Successful validation result

"Success! Fashion Connector will be able to process the file."

means all or some of the file rows will be processed.

Failed validation result

"FAILED! Fashion Connector will not be able to process the file. Please correct the errors."

means file rows will not be processed

Response example

Warning and error structure

type - category of the problem
message - information about the problem
line_numbers - list of the rows on which problem has occurred. Numeration starts with 1 for header row, first data row is 2. In addition to line_number, store_id and ean fields might be included if possible to retrieve.
details - section providing consequence of the problem

Error example:

{
      "type": "Store does not exist in our system",
      "message": "Retailer does not have a configured store with this id XXX in our system.",
      "line_numbers": [
        {
          "store_id": "1",
          "ean": "5704498811166",
          "line_number": 2
        },
        {
          "store_id": "1",
          "ean": "4061749183108",
          "line_number": 3
        }
      ],
      "details": [
        "Corresponding rows will not be exported"
      ]
}

CSV Encoding Error ¶

File encoding is not supported.

Tip to fix

Check file encoding. Supported encodings

CSV File Error ¶

General error in feed file processing with unknown cause. Such error should not happen

Tip to fix

Contact Connected Retail for investigating the issue

CSV header and row columns do not match ¶

Row has more columns than feed file header

Tip to fix

Remove extra columns and ; from the rows

Disabled article ¶

Article was disabled in Management UI or was disabled in retailer configuration by Partner Consulting on your request

Tip to fix

Consider enabling article or remove article from the file

Duplicated value ¶

Values like EAN and article_number should be unique per store

Tip to fix

Remove duplicates

Empty stock feed file ¶

Processed file was empty

Tip to fix

Make sure data is sent in the feed file

Invalid column value ¶

Format of the value is invalid

Tip to fix

Check value formats in the table and adjust values accordingly

Minimum price ¶

Price value is lower than minimum price configured for retailer

Tip to fix

Consider decreasing minimum price (contact Connected Retail for changing configuration) or remove rows with too low prices

Missing mandatory columns ¶

Mandatory columns not present in the file

Tip to fix

Add mandatory columns to file

Missing values ¶

Values for some fields are empty

Tip to fix

Add missing values for fields listed in error message

Row has null values ¶

Row contains null characters not supported in our system

Tip to fix

Locate and remove null characters from the feed file

Store does not exist in our system ¶

Store id used in store column was not configured in our system

Tip to fix

Check and fix store id, remove rows with incorrect store ids from the feed file or contact Connected Retail for changing store id configuration

Too many columns with same prefix ¶

Only two columns starting with the store_ prefix are allowed

Tip to fix

Remove excessive columns starting with store_ from the file, leaving maximum two store columns

Unknown columns ¶

Feed file contains columns not present in the list and not starting with prefix store_

Tip to fix

Remove unknown columns from the feed file

Too many quotes in a value ¶

Feed file contains a field that has too many quotes that cannot be escaped according to RFC 4180 convention.
If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote. For example: "aaa","b""bb","ccc"

Tip to fix

Escape double quotes inside the fields properly, avoid "some"thing" or ""something""""