Routine~12min
The Suspended Seller
Seven seller accounts were suspended for policy violations in Feb–March 2024, but 43 orders kept coming through on those accounts after suspension. The checkout API was reading from a stale seller-status cache. One suspended seller (ClearCache Store) has zero post-suspension orders — it was blocked correctly when ops manually flushed that cache entry.
Tables you'll query
sellersorders
What you'll learn
JOINsDate & Time Functions