1. Formatting supplier offers for comparison
Challenge: Each supplier uses their own layout and column names, complicating side-by-side comparisons.
Magic Table Solution: Choose a comparison template and map the supplier’s columns to it — e.g., map “Item Ref” → “SKU,” “Price (€)” → “Unit Price,” “MOQ” → “Minimum Order.”
Example: Format 5 supplier sheets into a common template for easy price and delivery comparison.
Benefits:
-
Instant comparability between offers.
-
Reduced manual work.
-
Standardized analysis process.
2. Consolidating purchase order history
Challenge: Purchase order exports from different systems have inconsistent field names.
Magic Table Solution: Align all files to a single structure — “PO_Number,” “Supplier,” “Date,” “Total_Amount” — and export the unified version.
Example: Merge 3 PO history files from different ERP modules into a clean dataset for spend analysis.
Benefits:
-
Easier spend tracking.
-
Standardized reporting.
-
Faster auditing.
3. Preparing supplier data for internal tools
Challenge: Importing supplier data into internal systems requires a specific format that’s often painful to achieve manually.
Magic Table Solution: Simply upload the supplier’s raw Excel and align columns to your ERP’s supplier import template.
Example: Map supplier files to your Oracle import template in a few clicks.
Benefits:
-
Quick import without IT help.
-
Reliable, consistent uploads.
-
No risk of broken formats.