FixFlatFile

Amazon error 8560

Error 8560 covers two different problems under one code. The first is a required value that is empty in the file. The second is a product code that fails a check on its format or on its check digit, the last digit of the code. The two problems are repaired in different ways, so the message in the report has to be read before anything is changed.

What the processing report tells you

The processing report gives five entries for each failed row: the record number, the SKU, the error code, the type, and a message. Record 1 is row 3 of your file, so the row for a record sits at the record number plus two. For error 8560, the message carries the separation between the two problems. A message about a missing or required value belongs to the first problem. A message about the check digit or the format belongs to the second. The message also names the field involved. The report does not supply the missing value, and it does not say which digit of a code is wrong.

What this error means

A required attribute is a field the template marks as required for the product type. An empty cell in such a field leaves the row with nothing for Amazon to accept in that field, and the row fails. A product code carries a check of its own. The last digit is calculated from the digits in front of it, and Amazon runs the same calculation on the code in the file. A code whose last digit disagrees with the calculation, or whose length and format disagree with its code type, fails under the same error code.

Causes, in the order to check them

  1. A required attribute or column was left empty on the row.
  2. The check digit of the product code is wrong, because the last digit was mistyped or an earlier digit of the code was mistyped.
  3. The code has the wrong length or format for its type.

How to fix it yourself

For a missing value:

  1. Find the row from the record number and read the field named in the message.
  2. Open the Data Definitions sheet of your template and confirm that the field is required for your product type.
  3. Enter the correct value for that field, taken from your product records.
  4. Read across the same row and fill any other required field that is empty, so the row goes back in one upload.

For a product code:

  1. Count the digits of the code and compare the count with the length of the code type. A UPC carries 12 digits and an EAN carries 13.
  2. Where the length is right, compare the code in the file with the code on the product, digit by digit. Correct any digit that differs from the product.
  3. Where every digit matches the product except the last one, calculate the check digit again and set the last digit to the result. For a UPC, add the digits in the odd positions, multiply that sum by three, add the digits in the even positions, and the check digit is the amount that brings the total to the next multiple of ten. For an EAN, the digits in the even positions carry the multiplication by three instead.
  4. Upload the file again.

A recalculated digit repairs a mistyped digit. It does not repair a code that belongs to a different product. Where the digits belong to another product, the correct code for this product goes into the file in place of them.

When the file cannot fix it

A submission can carry errors that sit outside the file. A missing brand registration or approval returns error 5665. A missing permission to list in the category returns error 8026. Editing the file does not repair either one. The diagnosis lists those errors separately, with the reason and the step to take in Seller Central. If every error in your diagnosis belongs to that group, we charge nothing.

Check your file

The free diagnosis reads your failed file and the processing report Amazon returned. It shows every error by SKU, states which errors we fix automatically, which ones need your answer, and which ones the file cannot fix. You see the full breakdown before you pay anything. You can start from the FixFlatFile home page.

Requirements differ by category, and Amazon decides whether a file is accepted.