Routine~12min

The Ghost Catalog

4 products were deactivated in December 2023 but kept appearing in the storefront because the cache was never purged. 156 orders came in on deactivated products in January 2024. One product was deactivated correctly and should show zero post-deactivation sales.

Tables you'll query

productsorder_items

What you'll learn

JOINsDate & Time Functions
Investigate this case →