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