Expanding Import Details

To view detailed import information:

1. Navigate to /inventory/csv-history
2. Locate the CSV log row you want to view details for
3. Click the expand icon button (KeyboardArrowDownIcon when collapsed, KeyboardArrowUpIcon when expanded) in the first column
4. Tooltip shows "Collapse Details" or "Expand Details" on hover
5. Row expansion state tracked in openRows object (keyed by CSV log _id)
6. When expanded, system automatically fetches detailed data if not already loaded
7. API call made to /inventory/csvlogs/{csvLogId}
8. Detailed import information expands in a CollapsibleTableCell below the row
9. Loading indicator (CircularProgress) shows while fetching details
10. Error alert displays if fetch fails
11. Click collapse icon again to hide details (data remains cached)

Detailed Data Structure

When expanded, the detail section shows:

• Section Title: "Details for {filename}" heading
• Loading State: CircularProgress centered while fetching detailed data
• Error State: Red Alert (variant="filled") if fetch fails with error message
• Summary Box: Shows totals: Total Items Processed, Total Imported Items, Total Errors
• Data Array: detailedData[csvLogId].data contains successful import rows
• Errors Array: detailedData[csvLogId].errors contains failed import rows with error messages
• Export Buttons: "Export Imported Items" and "Export Error Details" buttons when data available

Successful Imports (Data Array)

The data array contains successfully imported rows. Each entry includes:

• Row Object: Complete row data from original CSV file
• CSV Index: Original row number in CSV file (csvIndex field)
• Product Data: SKU ID, product name, and all imported fields
• Quantity: Quantity that was imported
• Price: Price set for the item
• Variant Fields: Condition, language, printing, foil status, etc.
• All CSV Columns: Complete original row data preserved
• Export Format: Can be exported to CSV with all original columns preserved

Failed Imports (Errors Array)

The errors array contains rows that failed to import. Each error entry includes:

• Row Object: Original CSV row data with csvIndex (row number)
• Error Object: Contains error message explaining why import failed
• Error Message: String message or error object with message property
• Row Data: All original CSV fields preserved for reference
• Common Error Formats: String errors, error objects with .error property, or error.message property
• Export Format: Can be exported to CSV with Row Number, all original columns, and Error column
• Error Extraction: System extracts error message from various formats (string, object.error, object.message, JSON stringify fallback)

Exporting Detailed Data

From the expanded details section, you can export:

• Export Imported Items Button: Exports successful imports to CSV (filename: {filename}_imported.csv)
• Export Format: All original CSV columns preserved, includes nested row data with "row." prefix
• Export Error Details Button: Exports failed rows to CSV (filename: {filename}_errors.csv)
• Error Export Format: Row Number column first, then all original columns, then Error column last
• Error CSV Features: Uses Papa.unparse for proper CSV formatting, user-friendly format
• File Download: Uses file-saver library, downloads automatically to browser downloads folder