Development of a Custom Python Automation Script

We require a Python script to automate the daily processing and analysis of sales data exported from our Shopify store. The script must handle CSV files containing order details, customer information, product SKUs, quantities, prices, and timestamps.
Required functionality:

Read and parse multiple CSV files from a specified input folder.
Clean the data: remove duplicates, handle missing values in key columns (email, order ID, total price), standardize date formats to YYYY-MM-DD.
Calculate key metrics per day: total revenue, number of orders, average order value, top 5 selling products by revenue and by units sold.
Generate a summary report as a new CSV file with aggregated daily stats and a separate Excel file with pivot-like breakdowns (using pandas and openpyxl).
Add basic error handling and logging to a text file for any issues during execution.
Include command-line arguments for input folder path and output folder path.

Technical requirements:

Python 3.10+.
Use only standard libraries plus pandas, openpyxl (no additional installations beyond these).
Script should run efficiently on datasets up to 50,000 rows per file.
Code must be well-commented, modular (functions for each major step), and include a main function.
Deliver the complete script as a .py file plus a short README.md with usage instructions and example command.