An automated pipeline that reads order numbers from SAP, searches across all dealer tabs with intelligent column mapping per tab, and syncs the matched data back to SAP.

Each dealer tab’s column positions are explicitly mapped in configuration, so the system handles layout variations without breaking.

The engine resolves case mismatches, trailing spaces, and formatting inconsistencies automatically before matching, eliminating false negatives.

If a serial number already exists in the target sheet, the system skips it; if not, it writes the serial number and syncs customer, location, and salesman data back to SAP.

When a dealer adds a new column (which happened mid-project), the system adapts, because each tab’s column positions live in a maintainable config.