How to Fix Error 99073: Duplicate SKUs or Product IDs in Bulk Uploads
Error 99073 blocks rows that contain duplicate SKUs or external_product_id values within a single bulk upload. In a 5,000‑row spreadsheet, two duplicate SKUs caused both rows to be rejected, requiring a manual clean‑up. Using Excel’s Conditional Formatting, a COUNTIF helper column, or XML tag search can catch repeats before resubmission.
Overview
Sellers uploading product listings in bulk may encounter Amazon’s feed processing error 99073 when the same SKU or external product identifier appears more than once in a single upload file. The error stops the affected rows from being processed, forcing a manual clean‑up before the feed can be accepted. Resolving the issue quickly is essential to keep catalog updates on schedule, especially during high‑volume periods.
Key Points
- Automatic duplicate scan — Amazon’s feed engine reviews every row for repeated SKUs or external IDs, and a single duplicate blocks the entire batch of affected rows.
- Two identifier fields checked — Both the
item_skucolumn and theexternal_product_idcolumn (UPC, EAN, GTIN, etc.) are validated for uniqueness. - All bulk formats covered — The rule applies equally to flat‑file spreadsheets and XML feeds submitted through Seller Central.
- Only within‑file repeats matter — The error is triggered by duplicates inside the uploaded file, not by conflicts with existing catalog entries.
- Immediate processing halt — Once a duplicate is found, Amazon rejects the offending rows and returns error 99073 in the feed processing report.
How Error 99073 Works
- File ingestion — When a seller submits a bulk feed, Amazon parses each line (or XML node) sequentially. Example: Row 2 contains SKU “ABC123”, row 57 also contains “ABC123”.
- Identifier validation — The system checks the
item_skuandexternal_product_idvalues against a temporary list built from the current upload. Example: The same UPC “012345678905” appears in rows 10 and 45, triggering a duplicate flag. - Error flagging — Upon detecting a repeat, Amazon tags the corresponding rows with error 99073 and excludes them from further processing. Example: The feed report lists “Error 99073 – Duplicate SKU” for rows 2 and 57.
- — After the entire file is scanned, Amazon returns a processing summary that includes the duplicate‑related error messages, allowing the seller to locate the problematic rows.
Analysis & Recommendations
Why This Matters
Duplicate rows trigger error 99073, forcing sellers to locate and remove repeats, which can delay catalog updates by hours, especially during high‑volume periods. A 5,000‑row upload with just two duplicate SKUs resulted in both rows being rejected, illustrating the need for pre‑submission validation.
Key Takeaways
- Error 99073 is raised when the same SKU or external_product_id appears more than once in the same upload file.
- Both flat‑file spreadsheets and XML feeds are subject to the duplicate‑check rule.
- A helper column with =COUNTIF($A$2:$A$5000, A2) flags any SKU count >1, allowing quick removal of duplicates.
- In the example, 2 rows out of 5,000 were rejected due to duplicate SKUs, requiring a manual re‑upload.
Recommended Actions
- →Open the bulk file in Excel, apply Conditional Formatting > Highlight Cells Rules > Duplicate Values on the SKU column, then repeat on the external...
- →Insert a helper column with =COUNTIF($A$2:$A$5000, A2), filter for values >1, delete or amend the flagged rows, and save before re‑uploading.
- →For XML feeds, open the file in a code editor (e.g., VS Code), search for repeated <SKU> or <ExternalProductID> tags, remove or merge duplicates, t...
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!