Changelog – October 24, 2025

🔧 Bug Fixes & Refinements

COALESCE Logic Enhancement: Updated SQL queries in shipment reference API to use COALESCE for improved style ID handling
Ensures fallback to default styles when primary style is unavailable
Improves reliability of shipment reference data retrieval
Query Optimization: Streamlined shipment reference queries for better performance
Data Integrity: Enhanced fallback mechanisms to prevent null reference errors

Print Formatting Improvements: Enhanced print styles in BulkPackingListsPage component
Better print-specific element visibility control
Improved layout for print media
Cleaner print output with proper spacing and breaks
Print Styles Utility Updates: Enhanced multiPagePrintStyles in src/lib/print-styles.ts
More robust print media queries
Better page break handling
Improved print-specific CSS rules
Component Structure: Streamlined rendering logic for packing lists
Improved code clarity and maintainability
Better separation of print vs screen rendering

Shipment References Population: Updated scripts/populate_shipment_references.py for improved data handling
Better error handling
More efficient database operations

src/app/api/orders/[id]/shipment-references/route.ts: Enhanced COALESCE logic for style ID handling

src/app/(authenticated)/batches-new/[id]/packing-lists/page.tsx: Refactored for better print handling
src/components/batches/shipment-reference-display.tsx: Minor refinements for style display

src/lib/print-styles.ts: Enhanced print style generation with better formatting rules

More Reliable Shipment References: Fallback logic ensures shipment references always display correctly
Better Print Quality: Improved print formatting for packing lists
Consistent Output: More predictable print results across different browsers

Improved Maintainability: Cleaner component structure and better separation of concerns
Better Error Handling: COALESCE logic prevents null reference errors
Enhanced Readability: Streamlined rendering logic