Routine~12min

The Archived Address

Logistics raised a concern — some recent orders are pointing to shipping addresses that have been archived. Those addresses may be vacant or wrong. The checkout session cached the address ID and didn't check for archival. Find the affected orders.

Tables you'll query

shipping_addressesorders

What you'll learn

JOINs
Investigate this case →