WooCommerce Orders Export Sample Dataset

WooCommerce's native order export from the admin panel generates UTF-8 CSV files with exact production headers: Order ID, Date Created, Status, Currency, Total, Billing First Name, Billing Last Name, Billing Email, Line Items, Order Notes, and Shipping Method. This dataset contains 6,300 synthetic order records. The WooCommerce export quirk that causes CSV structural collapse is that the Line Items and Order Notes fields frequently contain raw HTML markup (<br>, <p>, <strong>) and embedded CRLF line breaks from product descriptions and checkout notes. When a customer leaves a multi-paragraph order note or a product description contains HTML tags, the entire CSV row structure fractures — naive parsers split a single order into 3-5 invalid rows at every unescaped newline. The structural dirty data inventory includes: 2,100 Order Notes cells with embedded CRLF line breaks and raw HTML tags, 890 Line Items cells containing quoted commas within product names (e.g., 'Widget A, Large, Blue'), and missing UTF-8 BOM causing accented customer names (Müller) to display as mojibake. Expected Output: Yields 6,300 clean order records with intact multiline content. Ideal for: ETL testing, DuckDB demos, Power BI, Excel Power Query, CI pipelines. Process this file through the woocommerce-cleaner tool to strip HTML artifacts and collapse multiline order notes.