redux-scraper/backlog/tasks/task-89 - Merge-duplicate-post-files-with-same-file-order.md

id, title, status, assignee, created_date, updated_date, labels, dependencies

id	title	status	assignee	created_date	updated_date	labels	dependencies
task-89	Merge duplicate post files with same file order	To Do		2025-08-16 19:05	2025-08-16 19:06

Description

Clean up duplicate post files that have the same file_order value within a post by keeping only the most recent file with a successful 200 HTTP response code. This addresses data inconsistencies from multiple scraping attempts of the same file.

Acceptance Criteria

• #1 System identifies posts with multiple files having same file_order
• #2 System merges duplicates keeping most recent file with 200 status code
• #3 Duplicate files are properly deleted with cascading cleanup
• #4 File associations and metadata are preserved for kept files
• #5 Process handles edge cases like no files with 200 status code
• #6 Data integrity is maintained throughout merge process