Amazon seller operations · field note

Amazon SP API: "400 Bad Request" while setting up source

A working diagnosis of this problem and the sequence that actually resolves it, written from the operational side rather than the marketing side.

Reported context: <!-- Welcome to Airbyte! We're really appreciate your report and know that this will help us build an amazing tool. If you want to contribute yourself, you can find a good place to start by searching for the good-first-issues label or maybe... by trying to solve this one? (we can help debug this with you!) Right now we are in alpha, so we're releasing versions a lot more frequently than normal. You can help us get to

What is actually going on

Fee structure changes are the most common root cause. Referral fees, FBA fulfilment fees and storage surcharges are recalculated on different schedules, so a listing that was profitable last quarter silently drifts negative.

Listing indexation failures usually trace back to backend search terms exceeding the byte limit, duplicate keyword stuffing, or a suppressed buy box caused by price or availability signals.

The sequence that works

  1. Export the last 12 months of settlement reports and rebuild unit economics per SKU: referral fee, FBA fee, inbound freight, storage, returns, ad spend.
  2. Rank SKUs by contribution margin after ads, not by revenue. Any SKU below 15% margin is a candidate for repricing or discontinuation.
  3. Audit backend search terms byte by byte. Remove duplicates already present in the title, and remove competitor brand names that trigger suppression.
  4. Rebuild reorder points from actual receiving dates over the last 90 days, not from supplier promises.
  5. Set a weekly buy box health check: price versus the lowest competing offer, stock cover in days, and suppression alerts.

Where people lose time

Verify before you trust it

Run the checks above against your own data instead of adopting them at face value. The failure modes are specific enough that a single afternoon of measurement will either confirm this diagnosis or rule it out — both outcomes are useful, and guessing is not.

Amazon Search Terms Playbook
A ready-to-use package for exactly this workflow — $27.55, delivered immediately.
Get Amazon Search Terms Playbook · $27.55
Sold via Gumroad, which acts as merchant of record and handles payment and applicable taxes. All sales are final; see the return policy before purchase.