FixFlatFile

Your Amazon US listing file came back with errors. Upload the failed file and we check it and return a corrected file. The diagnosis is free, and you see the full result before you pay anything.

Upload your failed file

The diagnosis is free. You see the full result before you pay anything. Files in TSV, TXT, or XLSX form are accepted. The free diagnosis runs up to 3 times per visitor per day.

What a diagnosis looks like

This is the full diagnosis of a sample luggage file with six errors across three SKUs, produced by the same diagnosis that runs on your upload. A diagnosis of your file shows the same items.

Diagnosis summary

Total errors and warnings	6
Errors	5
Warnings	1
All errors we fix automatically	3
All errors that need your answer	2
All errors the file cannot fix	1
Uncategorized errors	0

We show the version value from the settings row. We do not compare it with the newest template version, because the newest version value is not confirmed in our definitions.

Breakdown by SKU

SKU: LUG-BLK

We fix this in the file:

Error 90117 - We fix this in the file - Error

Field: item_name

Report text: The value provided for 'item_name' exceeds the maximum allowed length for this attribute.

Reason: The text is longer than the limit for its field.

Fix: We shorten it to the limit.

Basis: Classified by the error code.

Error 90057 - We fix this in the file - Error

Field: purchasable_offer.audience

Report text: The value 'EVERYONE' provided for 'purchasable_offer.audience' is not a valid value.

Reason: A value is not in the allowed list for its field.

Fix: We replace it with a value from the allowed list. If the replacement cannot be decided from the file, we ask you.

Basis: Classified by the error code.

Note: The pre-check found the same problem: Pre-check: the value against the allowed list. We do not guess a replacement for a value outside our table.

Error 90122 - We fix this in the file - Warning

Field: item_highlights

Report text: HTML tags were found in the value provided for 'item_highlights'. HTML is not allowed in this field.

Reason: A text field contains HTML tags.

Fix: We remove the tags and leave plain text.

Basis: Classified by the error code.

Note: The pre-check found the same problem: Pre-check: tags found in a text field, the check for error 90122.

SKU: LUG-BLU

We need your answer:

Error 8560 - We need your answer - Error

Field: externally_assigned_product_identifier

Report text: A value is required for 'externally_assigned_product_identifier' but none was provided.

Reason: A required value is empty, or the product code needs checking.

Question: SKU LUG-BLU, field externally_assigned_product_identifier: Tell us the missing value, or the correct product code.

Basis: The report text points to a missing value, so we placed this in the group that is fixed with your answers.

Error 8541 - We need your answer - Error

Field: item_name

Report text: The value you submitted for 'item_name' does not match the value in the Amazon catalog.

Reason: Your value differs from the value in Amazon's catalog.

Question: SKU LUG-BLU, field item_name: We prepare a change toward Amazon's value. Confirm that we may apply it.

Basis: Classified by the error code.

SKU: LUG-PARENT

The file cannot fix this:

Error 5665 - The file cannot fix this - Error

Report text: Your brand is not approved. You must complete brand approval before listing products under this brand.

Reason: Brand registration or approval is not in place, so the file cannot fix this.

Next step: Check the registration or approval status of your brand in Amazon Brand Registry in Seller Central. Once registration is in place, you can list.

Basis: Classified by the error code.

What we did not check

The diagnosis covers the items below at a later stage.

The attributes specific to this product type, such as brand, manufacturer, material, color, dimensions, and capacity, with their official names, whether each is required, length limits, and allowed values. They sit inside the schema for each product type and cannot be confirmed from public documents. - The definition is unconfirmed, so we did not check this.
The allowed values of variation_theme for this product type - The definition is unconfirmed, so we did not check this.
The field limit for bullet_point in the template. Amazon's policy guidance gives 10 to 255 characters per bullet, but the limit of the field itself is unconfirmed. - The definition is unconfirmed, so we did not check this.
The length limit for product_description. It is often stated as 2,000 characters, but we have not confirmed it in the original public documents from Amazon. - The definition is unconfirmed, so we did not check this.
The limit for the search terms field. It is often stated as 250 bytes, but we have not confirmed it in the original public documents from Amazon. - The definition is unconfirmed, so we did not check this.
The allowed values for item_type_keyword and the recommended browse nodes. They sit in the Browse Tree Guide, which is distributed inside the seller login. - The definition is unconfirmed, so we did not check this.
The official field name and allowed values for the condition field - The definition is unconfirmed, so we did not check this.
The official field name for the SKU column and its constraints, such as length - The definition is unconfirmed, so we did not check this.
The format of the settings row in generated templates and its version value - The definition is unconfirmed, so we did not check this.
The final list of code types for externally_assigned_product_identifier - The definition is unconfirmed, so we did not check this.
Definition of field variation_theme.name, status unconfirmed - The definition of this field is not final, so we did not check this field.
Definition of field externally_assigned_product_identifier, status partial - The definition of this field is not final, so we did not check this field.
Definition of field main_offer_image_locator, status partial - The definition of this field is not final, so we did not check this field.
Comparison of the full header set with the template definition, the pre-check for error 90011 - Our definition covers the common part of the template only, so the full header set cannot be compared yet.
Template version check - Our definitions do not hold the newest template version value, so we only show the value from the settings row.

Charge: yes. There are 5 errors we can fix automatically or with your answers.

How it works

Upload the file that failed. The processing report Amazon returned is optional. Attaching it helps us find the failing rows faster.
Read the diagnosis. It names the SKU, the row, and the field for each error, and states in plain words what is wrong and what we will change. It separates errors from warnings. An error stops acceptance. A warning means the listing was accepted but may not display the way you intended.
Pay USD 29 for the submission.
Download the corrected file and the list of changes. The corrected file keeps the format of your original template, so you can upload it as it is. The list of changes shows the SKU, the field, the value before, the value after, and the reason for every change.
Upload the corrected file to Amazon. If Amazon returns new errors caused by the file, we rework the file at no extra charge, within the limits stated in the small print below.

You never hand over your Seller Central login. You upload two files and download the result.

The diagnosis appears as soon as the upload finishes. The corrected file is ready to download as soon as payment completes. Amazon then takes between 15 minutes and 24 hours to process a resubmission. That processing time is Amazon's, and it is not part of our delivery time.

What we fix, what needs your answer, and what we cannot fix

Fixed from the file alone:

90011: column headers missing or out of line with the current template
90057: a value that is not in the allowed list for its field
90117: a title or description over the length limit for its field
90122: HTML tags inside a text field
8016 and 99010: variation parent and child rows that do not line up
90188, and the part of 8560 about product code format: a check digit that does not match
Conversion of an xlsx file into the tab-delimited text format Amazon accepts

Fixed after you answer a question on the diagnosis screen:

8560 and 99001: a required value is empty
5461 and 8572: the correct product code is needed
8542: an ASIN change needs your confirmation
8541: your value differs from the value in Amazon's catalog. We prepare the change toward Amazon's value and apply it only after you confirm. We never overwrite your values without your confirmation.

Not fixable in the file:

5665: brand registration or approval is missing
8026: you do not have permission to list in the category
90202: a restriction is placed on the product

For these three, the diagnosis states the reason and the steps to take in Seller Central. We do not call them fixed. If your diagnosis contains only this group, we charge nothing.

Coverage

Coverage at launch is Amazon US, for new listings and for updates, in tab-delimited text or xlsx, up to 10,000 data rows per submission. We start with a small set of general categories, beginning with bags and luggage: backpacks, handbags, luggage, and wallets. Apparel is not covered yet. Variation rules differ by apparel category, and we add categories only when their template definitions are ready. The diagnosis accepts an apparel file and returns it as not covered, and we count those requests. If your category is not covered, the diagnosis says so before any payment.

Price

Fixing costs USD 29 per submission, charged once. One submission is one original file and the rounds of resubmission that follow from it. There is no subscription.

Monitoring is planned at USD 49 per month. When a template definition changes, we check your stored files against the new definition and tell you which SKUs are affected, with a way to fix them from the notice. Monitoring is not open for signup yet. This page will take signups when it opens.

If you hire a freelancer instead

One-off error fixes on freelance marketplaces trade between USD 10 and USD 40 per job. Jobs that also create the file and submit it for you start at USD 75. Three differences apply here:

A freelancer who works inside your account needs access to your Seller Central. Sellers have had listings suspended and warnings issued after mistakes by someone they gave access to. We never ask for access.
The diagnosis here runs as soon as you upload, and the corrected file is ready as soon as payment completes. A freelancer works to their own schedule.
You see the full scope of the fix before you pay, including the errors we cannot fix. The price does not change after you see it.

Support

Support is by email only: support@fixflatfile.com. We reply within 1 business day.

Small print

Payment covers delivery of a corrected file for the scope shown in your diagnosis. Amazon decides whether a file is accepted. FixFlatFile does not guarantee acceptance, and does not guarantee sales results after acceptance. We do not refund payments. If your diagnosis contains no error that can be fixed in the file, we do not charge you. Rework covers new errors caused by the file, up to 5 rounds per submission and up to 30 days from the first delivery of the corrected file. Rejections caused by your Amazon account or by Amazon's catalog are not covered by rework. Our liability for a submission is limited to the amount you paid for that submission. The full terms are in the Terms of Service.