Understanding Error 18013: Why Adjustment Feeds Reject Negative Values
Error 18013 blocks bulk adjustment feeds when fields like AdjustmentAmount or item-price-adj contain a negative value (e.g., -8.50). Amazon requires only positive numbers, so changing -15.99 to 15.99 lets the file pass XML or tab‑delimited validation.
Overview
Amazon sellers who submit order‑adjustment feeds sometimes encounter error 18013, which blocks the file because a refund amount is entered as a negative number. The system expects only positive values to represent money returned to the buyer, regardless of whether the feed is XML or tab‑delimited. Fixing the error is essential for keeping bulk refund workflows on schedule and avoiding unnecessary re‑uploads.
Key Points
- Positive numbers required — All fields that convey a refund, such as
AdjustmentAmountin XML oritem-price-adjin a tab‑delimited file, must contain a positive figure; a value of –12.34 will trigger the error. - Both feed formats affected — The validation runs on XML adjustment feeds and on plain‑text tab‑delimited feeds, so the same rule applies whether you use Amazon’s API or the manual upload screen.
- No charge‑back via feeds — Amazon’s adjustment engine is built solely for refunds; it will not accept a negative amount as a way to charge the buyer’s credit card.
- Simple correction — Replacing the negative entry with its absolute value and resubmitting the feed resolves the issue in a single step.
- Impact on bulk processing — A single malformed line can cause the entire file to be rejected, delaying refunds for dozens or hundreds of orders.
- Alternative for extra charges — If you need to collect additional money, you must do it outside the adjustment feed, typically through direct buyer communication and Amazon‑approved recharge procedures.
How Error 18013 Is Triggered
- Feed preparation — The seller compiles a bulk adjustment file, for example a tab‑delimited sheet that lists
order-id,item-price-adj, and other columns. In one row the seller mistakenly writes-8.50foritem-price-adjto indicate a $8.50 refund. - Upload to Amazon — The file is submitted via the “Upload Feed” interface or through the MWS/SMAPI endpoint. Amazon’s parser reads each line and validates the data types and sign conventions.
Analysis & Recommendations
Why This Matters
A single negative entry causes the entire adjustment file to be rejected, delaying refunds for dozens or hundreds of orders and tying up cash flow. Sellers may miss performance metrics such as Late Shipment Rate if refunds are delayed, and they must re‑upload after fixing each error.
Key Takeaways
- Error 18013 is triggered when AdjustmentAmount or item-price-adj is negative (e.g., -12.34).
- Both XML and tab‑delimited adjustment feeds are subject to the positive‑only rule.
- One malformed line rejects the whole file, potentially affecting hundreds of refunds.
- Replacing the negative value with its absolute value (e.g., -15.99 → 15.99) resolves the error.
Recommended Actions
- →Run a pre‑upload script in Seller Central > Inventory > Manage Feeds that flags any AdjustmentAmount < 0 and replaces it with the absolute value.
- →Edit the feed file to ensure all refund columns contain positive numbers before uploading via MWS/SMAPI or the Upload Feed screen.
- →Upload a small test file via Seller Central > Add Products > Upload Feed to confirm the format passes validation before sending the full bulk file.
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!