Auto parts e-commerce in Algeria: TecDoc and VIN search, Gemini AI assistant, Next.js store and Filament admin.
The client's catalogue is a 137,029-row Excel file with many anomalies: #VALUE! errors, inconsistent prices, missing references and duplicates with different prices. A partial import would have published inconsistent data.
An audit command produces an Excel report ranked by severity, which the client uses to fix their file. The importer then checks the whole file without writing anything. On any blocking issue it rejects the import. Otherwise it imports everything in a single transaction.
The code covers 20 of the 21 contracted modules, plus a subscription module. There are 74 Pest test files (about 520 cases), 33 Filament resources and 13 dashboard widgets.