Saved Views

10 predefined views. Custom user views land in Phase 2.

1. 1.

   Ready to Import

   sync_state IS NULL AND validation = ready

2. 2.

   Needs Update

   action_state = 'update'

3. 3.

   Errors to Fix

   validation = blocking

4. 4.

   Active Products

   status = 'active'

5. 5.

   Inactive Products

   status = 'inactive'

6. 6.

   Newly Added Unimported

   created_at > last_sync AND sync_state IS NULL

7. 7.

   Updated Unimported

   updated_at > last_synced_at AND sync_state IS NOT NULL

8. 8.

   Sync Failed

   sync_outbox.status = 'failed' for this product

9. 9.

   Stale Overrides

   at least one product_overrides.is_stale = true

10. 10.

    Recently Synced

    last_synced_at > NOW() - INTERVAL '7 days'